Excel Sheet Grid lines are disappears while saving byte stream into WorkBook

Aspose.Cells Product Family
1

Hi Aspose Team,

I want to generate the excel sheet with gridlines after loaded the byte array stream into workbook.
But, I’m getting the final Excel sheet without gridlines using the below sample code

Please help me to fix this issue and refer the attached generated Excel image.

String dataDir = Utils.getSharedDataDir(LoadingHTML.class) + “loading_saving\”;
//Sample HTML.
String sampleHtml ="<td colspan=“2”> 

Better
Column1 Column2 Column3
Column4 Column5 Column6
";

ByteArrayInputStream bais = new ByteArrayInputStream(sampleHtml.getBytes());
Workbook wb = new Workbook(bais);
wb = new Workbook(bais);
wb.save(dataDir + “outputWithoutGrid.xlsx”);

image.png (4.9 KB)

2

@Shyamu,

Thanks for the screenshot.

Aspose.Cells follows MS Excel standards and sepcfications when reading/parsing HTML files. Please open your HTML file into MS Excel manually and check if it shows gridlines. In case, it shows different results, kindly do share the HTML file (you may save the file to disk if you are generating from streams), we will check it soon.