I am generating the HTML to Excel file using aspose-cells-17.1.7.jar.
But at run time an error is occurring and blank excel file is generating.
Please provide a solution so that i can generate the excel file with full data without upgrade the aspose-cells-17.1.7.jar
HTML to Excel conversion is very complex thing. Excel to HTML is relatively much easier. Not every type of HTML can be converted to Excel.
HTML is a markup language and rendered by Web Browsers. Just check the size of Google Chrome, FireFox, Internet Explorer etc. They are almost more than 60 MB and they are full of composite DLLs etc. On the other hand, Aspose.Cells is a single DLL and its size is around 10 MB.
In short, free form HTML (i.e. HTML not generated by Microsoft Excel) is very hard to convert to Excel file.
Besides, it is out of Aspose.Cells scope to convert HTML to Excel. Because it deals with Excel files not HTML files. These are just additional features.
However, we have already logged your issue (CELLSJAVA-42332) in our database for product team consideration and investigation. Once, it will evaluate your issue, we will be in better position to help you.
I will suggest you, first create a simplest Excel file, then save it to HTML using Microsoft Excel menu commands and then observe what tags or markups like (h1, h2, div etc.) are being generated by Microsoft Excel, then use those tags to generate your HTML. In this way, you will be able to generate the HTML dynamically which is easily understandable by Aspose.Cells and you will also not have to wait for this issue to be fixed. Thanks for your understanding and have a good day.
This is Vishal. We have already purchased you license because we have html file which we want to convert to Excel. In our earlier communication you have said that if HTML file is excel driven then ASPOSE API will work. Now we have given excel driven html file and your API is not able to convert all the data to EXCEL. This is flaw in this API. This is a production blocker for us so please look into this with high priority.
We have raised the priority of your issue to High (i.e. Blocker) but we are afraid, we cannot guarantee a quick fix as the issue is very complex. Once, we get some updates regarding your issue, we will let you know as soon as possible. Thanks for your understanding and have a good day.
We faced two more issues while convert the HTML to Excel file.
Excel file not generated and error is occurring :
While we are trying to convert the HTML to Excel file we are getting given below error message on console
com.aspose.cells.CellsException: You want to put a string longer than 32K to Cell A217. MS Excel only allows to put a string shorter than 32K to a Cell.
at com.aspose.cells.zhq.a(Unknown Source)
Data Losss while converting the HTML to Excel :
We are facing the data loss issue also.
NOTE : input and output files are attached for referenceaspose.zip (28.6 KB)