SaveAsHTML and number format

[anatoly]

Hi,

If any workbook has cell with format set to number and number of decimal digits set to 0 its content looks like integer in Excel but is shown as decimal if export to HTML with XlsIO SaveAsHTML method.

Could you please look at the sample attached and advise?



DecimalTest_192ee35.zip

[Sridhar]

Hi Anatoly,

Thank you for using Syncfuion products.

XlsIO also provides various save options to control images and text in an Excel file. It enables you to save a worksheet with the displayed text or value in the cell to HTML file. The following code example illustrates this.

[C#]
HtmlSaveOptions options = new HtmlSaveOptions();
options.TextMode = HtmlSaveOptions.GetText.DisplayText;
options.ImagePath = @"..\..\Output\";
sheet.SaveAsHtml("Sample.html", options);

Please go through the following online documentation for the same.

http://help.syncfusion.com/ug_84/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Fsheettohtml.htm

Please let us know if you have require any further clarifications.

Thanks,
Sridhar.S