We are excited to announce the release of Spire.XLS for Java 12.6.0. This version supports setting whether to export hidden worksheets when converting Excel to HTML. Besides, after converting Excel to HTML, a contrasting color border is added to the currently selected tab in the converted HTML and the spacing on both sides is added to the text of the worksheet tabs. Moreover, it also enhances the conversion from Excel to HTML, Excel to PDF, and Excel to images. Additionally, some known issues are fixed, such as the issue that sparklines are lost after copying sheets and the issue that the function of setting the cell background color to transparent does not work. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-3865 | Supports setting whether to export hidden worksheets when converting Excel to HTML.
Workbook book=new Workbook();
book.loadFromFile("test.xlsx");
//false--- export the hiden worksheets
//true--- not export the hiden worksheets
book.saveToHtml("output.html",false);
|
| New feature | SPIREXLS-3872 | After converting Excel to HTML, a contrasting color border is added to the currently selected tab in the converted HTML. |
| New feature | SPIREXLS-3873 | After converting Excel to HTML, the spacing on both sides is added to the text of the worksheet tabs. |
| Bug | SPIREXLS-3724 | Fixes the issue that updates chart data with wrong results. |
| Bug | SPIREXLS-3764 | Fixes the issue that the content exceeded the cells after Excel was converted to images. |
| Bug | SPIREXLS-3803 | Fixes the issue that "NullPointerException" was thrown when converting Excel to images. |
| Bug | SPIREXLS-3815 | Fixes the issue that the background color and text color of the worksheet tab changed after converting Excel to HTML. |
| Bug | SPIREXLS-3831 | Fixes the issue that the application hangs when converting Excel to PDF. |
| Bug | SPIREXLS-3832 | Fixes the issue that sparklines were lost after copying sheets. |
| Bug | SPIREXLS-3841 | Fixes the issue that macros were lost after saving the document. |
| Bug | SPIREXLS-3867 | Fixes the issue that the application throws "ArrayIndexOutOfBoundsException" when loading an XML file. |
| Bug | SPIREXLS-3871 | Fixes the issue that the content was offset after Excel was converted to HTML. |
| Bug | SPIREXLS-3875 | Fixes the issue that setting DPI did not work when converting charts to images. |
| Bug | SPIREXLS-3877 | Fixes the issue that some data values were incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-3907 | Fixes the issue that setting the cell background color to transparent does not work. |
Click the link to download Spire.XLS for Java 12.6.0:
