We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

SaveAsHTML and number format

Thread ID:





98612 Mar 11,2011 08:17 AM UTC Mar 14,2011 09:27 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On March 11, 2011 08:17 AM UTC


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?


Sridhar [Syncfusion]
Replied On March 14, 2011 09:27 AM UTC

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.

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.


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



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon