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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

SaveAsHTML and number format

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 [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.

[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


CONFIRMATION

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.

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

;