virendra.ray:FileStream fs = File.OpenRead(str_outputFilexls);Please attach your template Excel file, so that we could check your issue properly.By the way for your issues:virendra.ray:But cells which contains formula are not having any value in HTML file.Please try calling Workbook.calculateFormula() before saving the HTML file, if it works fine.virendra.ray:Also if the column width is not proper in excel, html
contains ########## as value.I am also having problems with values which are not wrapped.You may try to call Worksheet.autoFitColumn method accordingly, see the document for reference:It should be same as MS Excel, please check the Excel file into MS Excel. If you still find the wrapping text issue or other issue, let us know with your input and output file (by Aspose.Cells) here. We will check it soon.Thank you.
File is attached for your reference
Hi,virendra.ray:File is attached for your referenceThanksVirendra
I was able to notice your issue but we need to investigate this issue further.
Please provide us your complete runnable project so that we could look into it further and log it in our database for a fix.
Also, I found, Aspose.Cells can load your file and then when I save it back it saves the workbook fine and the saved workbook can then be opened in Ms-Excel 2010 fine.
However, it loses your fill formatting. I have attached the output file and screenshot for your reference.
Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.xls", SaveFormat.Excel97To2003);
I want to retain the formatting along with the data.
Thanks for your posting and using Aspose.Cells.
I have logged a ticket against your mentioned issue with the id: CELLSNET-41234.
We will look into this issue and try to fix it. However, you should provide a simple sample project replicating your issue with the latest version: Aspose.Cells
for .NET v220.127.116.11.
It will help us look into your issue more precisely and we will be able to fix it quickly.
The issue about formatting is fixed in the latest aspose version 18.104.22.168.
However, the template file (Export.xls ) is not a standard Ms-Excel generated html. We could not parsed it so perfect now.
Please download and try this fix: Aspose.Cells for .NET v22.214.171.124 and let us know your feedback.