Hi
A new requirement my company has is for us to be able to save excel sheets as html pages. We used Aspose.cells in the past but our license has since expired and i need to make sure the latest version will be able to accommodate for what we need before we can justify renewing the subscription.
A previous issue i had was that charts were not showing up on html pages and that has now been resolved. I downloaded the latest version this morning and have continued with some tests. I know find another issue (which can be seen in the attached files) where it seems that the tabs on the html page are being linked to the incorrect worksheets. This is causing the first tab on the html to not be displayable and the last worksheet from the .xlsx to not be shown.
Could you kindly have a look and let me know if this can be resolved and how quickly.
Much appreciated.
Hi,
I am able to reproduce the issue converting your Excel file to Html. I have logged your issue into our issue tracking system with an id: CELLSJAVA-21967. We will figure your issue out soon.
Thank you.
Hi,
After looking into your issue further, we come to know, we think it is because the security settings of IE or other browser type. If you could enable the scripts or allow blocked contents, the tab and contents should be shown fine. We have allowed blocked contents for IE and it works fine. So, it is not an issue of Aspose.Cells for Java by any means.
Thanks.
Hi
Thank you for your assistance. Using IE, I see the worksheets map to the tabs correctly after I allow the active X objects. I just have 2 queries now:
1. In the excel workbook, there were 2 sheets (Sheet1 and Sheet2) created showing the licence file expiry warning. In the HTML page, the last sheet (Sheet2) is not there.
2. I know this is not related to the Aspose product at all and is perhaps out-of-scope for your assistance, but do u possibly know how to do the same “allow” fix in both firefox and google chrome as in IE. I cannot get it working and i am not very clued up in internet settings.
Thanks again
Hi,
1) Well, the evaluation sheets i.e. “Sheet1” and “Sheet2” are there with an extra sheet “Sheet3” in the output html file. But, you need to open the generated html file in IE browser e.g IE8.0. For your information, whenever a new file is generated using Aspose.Cells API without using the valid license file, an evaluation warning sheet would always be added to the generated file. When you use and set the license no evaluation warning sheet is added.
2) Well, you may try to browse/search internet to get to know for enabling your desired settings on for different browsers like firefox, google chrome.
Thank you.
Hi
I undestand that those extra sheets are created due to me not using a valid licence files, however im still expecting to the the exact same sheets in the html as in the xlsx but i do not.
The xlsx ends with Sheet1 and Sheet2 but Sheet2 does not exist int the html? I am using IE8. I also don’t see any Sheet3?
Hi,
I think you might be using some older version of the product. It works fine with latest version/fix v2.4.3, please try the version downloading from the site (Downloads module):
http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry270590.aspx
Also, I attached the output html file using the code:
Workbook wb = new Workbook();
wb.open(“d:\files\TestReport\Another test report - 2010-09-04 13-00-00.xlsx”,FileFormatType.EXCEL2007);
wb.save(“d:\files\TestReport\MyHtmlReport.html”,FileFormatType.HTML);