Export Excel to HTML with GridLines

If you want to export your Excel file into HTML with GridLines, then please use the HtmlSaveOptions.export_grid_lines property and set it true.

Export Excel to HTML with GridLines

The following sample code creates a workbook and fills its worksheet with some values and then saves it in HTML format after setting the HtmlSaveOptions.export_grid_lines to true.

from aspose.cells import HtmlSaveOptions, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create your workbook
wb = Workbook()
#  Access first worksheet
ws = wb.worksheets[0]
#  Fill worksheet with some integer values
for r in range(10):
    for c in range(10):
        ws.cells.get(r, c).put_value(r * 1)
#  Save your workbook in HTML format and export gridlines
opts = HtmlSaveOptions()
opts.export_grid_lines = True
wb.save(dataDir + "ExportToHTMLWithGridLines_out.html", opts)