We are happy to announce the release of Spire.XLS 11.11.2. This version supports to set border for data bar of chart, and set drop lines for line chart and area chart, as well as set the customized page size when converting an excel file to pdf. It also enhances the conversion from Excel to PDF, Excel to HTML. In addition, it fixes some known issues like MS Excel failed to open the saved xlsx file. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-1805 Supports to set border…
We are happy to announce the release of Spire.XLS for Java 4.11.3. This version enhances the conversion from Excel to PDF, it also fixes some known issues like the checked "Align with page margins" item was missing. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-2736 Fixes the issue that the format was not correct when converting an excel to PDF Bug SPIREXLS-3158 Fixes the issue that the obtained cell value of the date format was wrong Bug SPIREXLS-3485 Fixes the issue that the checked "Align with page margins"…
We are glad to announce the release of Spire.XLS for Java 4.11.0. This version supports to get the created time and the last saved time of Excel file. Meanwhile, it enhances the conversion from Excel to PDF and fixes some known issues. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3488 Supports to get the created time and the last saved time of Excel file. BuiltInDocumentProperties properties1 = workbook.getDocumentProperties(); properties1.getCreatedTime(); properties1.getLastSaveTime(); Bug SPIREXLS-3427 Fixes the issue that the conditional formats did not take effect when converting an Excel file to PDF Bug SPIREXLS-3444…

Spire.XLS 11.10.5 supports multiple new charts

Thursday, 28 October 2021 06:00
We are happy to announce the release of Spire.XLS 11.10.5. This version supports some new charts, such as Waterfall, Pareto and Histogram. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Supports Waterfall, Pareto, Histogram, BoxAndWhisker, TreeMap, SunBurst and Funnel charts. Workbook workbook = new Workbook(); workbook.LoadFromFile("waterfall_sample.xlsx"); var sheet = workbook.Worksheets[0]; var officeChart = sheet.Charts.Add(); //Set chart type as waterfall officeChart.ChartType = ExcelChartType.WaterFall; //Set data range to the chart from the worksheet officeChart.DataRange = sheet["A2:B8"]; //Data point settings as total in chart officeChart.Series[0].DataPoints[3].SetAsTotal = true; officeChart.Series[0].DataPoints[6].SetAsTotal = true;…
We are happy to announce the release of Spire.XLS for Java 4.10.1. This version supports setting the marker color for the SparkLine as well as supports printing comments when converting Excel to images. In addition, it enhances the conversions from Excel to PDF/HTML and also fixes the issue occurred in the process of adding hyperlinks to files. More details are given as follows. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3391 Supports setting the marker color for the SparkLine. Workbook book = new Workbook(); book.loadFromFile("D:/SparkLine.xlsx"); Worksheet worksheet = book.getWorksheets().get(0); SparklineGroupCollection sparklineGroup =…
We are excited to announce the release of Spire.XLS 11.10.4. This version enhances the conversion from XLS to PDF. In addition, it fixes the issue that the application threw an error when loading an .xlsx file. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-3386 SPIREXLS-3470 Fixes the issue that the content was incorrect when converting Excel to PDF. Bug SPIREXLS-3396 Fixes the issue that the application threw an error "Invalid LegendPositionType string val" when loading an .xlsx file. Bug SPIREXLS-3422 Fixes the issue that the combination chart type…
We are happy to announce the release of Spire.XLS 11.9.3. This version supports converting Excel to UOS/OFD. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Supports converting Excel to UOS. Workbook workbook = new Workbook(); workbook.LoadFromFile(xlsxFile); workbook.SaveToFile(uosFile, FileFormat.UOS); New feature - Supports converting Excel to OFD Workbook workbook = new Workbook(); workbook.LoadFromFile(xlsxFile); workbook.SaveToFile(ofdFile, FileFormat.OFD); Click the link to download Spire.XLS 11.9.3: https://www.e-iceblue.com/Download/download-excel-for-net-now.html More information of Spire.XLS new release or hotfix: https://www.e-iceblue.com/forum/spire-xls-new-release-or-hotfix-t4630.html