Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Sat May 03, 2014 6:17 am

I am trying to evaluate Spire.XLS's ability to convert a excel to html. I made a simple .xls as a test. Its a simple two column spread sheet with a sum formula on the second column as follows:

a | 1
b | 2
c | 3
d | 4
| 10 <=== ( forumula here is =SUM(B1:B4) )

When converted to html, I see "=SUM(B1:B4)" in the output instead of 10.

Code: Select all
           
             Workbook workbook = new Workbook();   
             workbook.LoadFromFile(filePath);
             workbook.CalculateAllValue();               
             String outputString = "";
             foreach (var sheet in workbook.Worksheets)
             {   
                    using (MemoryStream mstream = new MemoryStream())
                    {                       
                        sheet.SaveToHtml(mstream);             
                        outputString += System.Text.Encoding.UTF8.GetString(mstream.ToArray());
                    }
                }                               
            }


I have tried both the free edition, nuget edition and tried to apply the hotfix as well which appears to have converted it to a evaluation version. Nothing seems to calculate. What am I missing?

jon_x
 
Posts: 2
Joined: Sat May 03, 2014 12:33 am

Mon May 05, 2014 2:31 am

Hello,

Sorry for late reply as weekend.
Thanks for your feedback. We have noticed the issue you experienced, which has been transferred to our Dev team, once there are any progress, we will inform you ASAP. Sorry for inconvenience.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Wed May 28, 2014 8:44 am

Hi,

We have resolved your problem.

Please download the latest version spire.xls_hotfix_7.4.9 (the download link:http://www.e-iceblue.com/downloads/hot_fix/spire.xls_hotfix_7.4.9.zip)and test it.

If you have any problem,please inform us.

Thanks,
Lisa
E-iceblue support team
User avatar

lisa.chen
 
Posts: 21
Joined: Thu Mar 20, 2014 2:31 am

Return to Spire.XLS