OK so you are saying that you can’t handle this scenario at your end. Can you please check attached HTML file and send me the updated HTML file that can be converted to Excel file for our understanding that what HMTL data we need to remove.
Thanks,
Vishal
We have requested the product team to provide you a good or perfect html that can be converted to Excel file easily for your help.
This issue has been logged as
Any update on this?
I have logged your comment in our database against the ticket CELLSJAVA-42402 and requested the product team to provide some update regarding it. Once, we will get some news for you, we will share it with you.
We are fixing the issue CELLSJAVA-42402 and we are hopeful to provide you a fix before 4-Oct-2017.
Please check the modified HTML provided by the product team. Please try it with the following fix using the code given below
Download Links:
Modified HTML By Product Team.zip (3.0 KB)
Output Excel File.zip (11.0 KB)
Java
HTMLLoadOptions options = new HTMLLoadOptions();
options.setAutoFitColsAndRows(true);
Workbook wb = new Workbook(dirPath + "WI-171_modify.html", options);
wb.save(dirPath + "out_java.xlsx");
I am not able to download the zip files.
You are not the owner of this topic, please log in as
vishu88in
and then you will be able to download the files.
Thanks. I am waiting for this release.
I logged in using vishu88in but not able to download these zip files
I have sent you message at your @vishu88in. It contains my email, please email me at that email id and I will reply you back with attachment.
Please share the release update.
By release update, do you mean official release of October? The official release 17.10 will be available somewhere between 15-Oct to 25-Oct.
If you meant hot fix, then I have shared it in above post. If you cannot download it, then please let me know how should I send it to you. Since, it is Java hot fix and around 7 MB, so it cannot be sent via email.
Hi Shakeel,
Problem is how I can modified our HTML to this modified HTML. Please suggest.
Also please let me know that 17.10 release will work with our HTML or modified HTML?
The modified HTML is a Template HTML. You should analyze its HTML and generate the similar HTML, if you want to get correct output Excel file using Aspose.Cells.
If you have downloaded the attachments in my above post, you might have downloaded out_java.xlsx found inside the Output Excel File.zip. If you open this Excel file, you will see, it is correctly generated from modified HTML.
So, your future HTML should follow the Template HTML provided by us to generate correct results of conversion.
Hi Shakeel,
We are converting HTML file from email body so it is not in our control to modify HTML file like as you have provided. Please suggest how we can follow the Template HTML if we are just converting email body to HTML file.
Thanks,
Vishal
The issues you have found earlier (filed as CELLSJAVA-42402) have been fixed in Aspose.Cells for Java 17.10.
Hi,
Thanks for providing the updated library.
After use this updated library we found that data loss issue is still not fixed.
Please provide the latest library after proper testing.
NOTE : Generated excel file is attached with msg.WI-171.zip (4.7 KB)
Well, we only fixed the issue (logged earlier as “CELLSJAVA-42402”). It does not fix or include any enhancement for your earlier logged issue “CELLSJAVA-42389”. I am afraid, we cannot support importing your so complex HTML for now, we might support it later.
As we told you earlier (in our previous posts) with attachments, please refer to it and you have to follow it up for now: