Spire.XLS for Java 12.7.4 supports custom sorting
2022-07-21 03:25:29
We are pleased to announce the release of Spire.XLS for Java 12.7.4. This version supports custom sorting and supports converting Excel containing chart types defined by Excel 2016 to PDF and images. Moreover, it also enhances the conversion from Excel to HTML and Excel to PDF. Additionally, some known issues are fixed, such as the issue that the line format was changed after adding TrendLines to chart. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3704 Supports custom sorting. wb.getDataSorter().getSortColumns().add(0, new String[] {"12345","Argentina", "Area", "Chile", "Capital","USA","Ecuador","Guyana"} ); wb.getDataSorter().sort(wb.getWorksheets().get(0).getRange().get("A1:A8"));…
Spire.XLS for Java 12.7.0 supports filling the chart series markers with custom images
2022-07-13 09:02:42
We are excited to announce the release of Spire.XLS for Java 12.7.0. This version supports filling the chart series markers with custom images and supports loading and saving files in UOS format. In addition, it fixes some known issues such as the data was incorrect after updating pivot tables. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3948 Supports filling the chart series markers with custom images. IShapeFill markerFill = chart.getSeries().get(0).getDataFormat().getMarkerFill(); markerFill.customPicture("pic.png"); markerFill.setTexture(...); markerFill.SetPattern(...); //If use pattern filling, foreground color and backgroud color are needed. markerFill.setForeColor(...); markerFill.setBackColor(...); New…
Spire.XLS for Java 12.6.0 supports setting whether to export hidden worksheets when converting Excel to HTML
2022-06-08 09:13:26
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…
Spire.XLS for Java 5.5.0 enhances the conversion from Excel to PDF
2022-05-07 07:13:17
We are pleased to announce the release of Spire.XLS for Java 5.5.0. This version enhances the conversion from Excel to PDF. In addition, it fixes some known issues like the content of chart lost after copying worksheets multiple times. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-3792 Fixes the issue that the content format was incorrect after adding images in Excel and converting it to PDF. Bug SPIREXLS-3778 Fixes the issue that the content of chart lost after copying worksheets multiple times. Bug SPIREXLS-3811 Fixes the issue that…
Spire.XLS for Java 5.4.3 supports setting a maximum number of pages to convert when converting Excel file to PDF
2022-04-19 09:20:07
We are happy to announce the release of Spire.XLS for Java 5.4.3. This version supports setting a maximum number of pages to convert when converting Excel file to PDF, and enhances the conversion from Excel to PDF, Excel to PDFA, Excel to HTML. In addition, it fixes some known issues such as the output file was failed to open after adding watermark to an Excel file. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Supports setting a maximum number of pages to convert when converting Excel file…
Spire.XLS for Java 5.3.3 supports setting text direction for the chart category axis
2022-03-22 01:30:24
We are happy to announce the release of Spire.XLS for Java 5.3.3. This version supports setting text direction for the chart category axis as well as sorting for a Table, and enhances the conversion from Excel to image, Excel to PDF. In addition, it fixes some known issues such as the application threw "NullPointerException" when appending a rich text. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3641 Supports setting text direction for the chart category axis. chart.getPrimaryCategoryAxis().setTextDirection(TextVerticalValue.EastAsianVertical); New feature SPIREXLS-3706 Supports sorting for a Table. Workbook workbook…
Spire.XLS for Java 5.3.1 supports creating Excel 2016 Charts
2022-03-11 01:13:28
We are happy to announce the release of Spire.XLS for Java 5.3.1. This version supports creating Waterfall Chart, Pareto Chart, Histogram Chart, BoxAndWhisker Chart, TreeMap Chart, SunBurst Chart, and Funnel Chart. Also, it enhances the conversions from Excel to PDF and Excel to Image. In addition, it fixes some known issues such as the obtained signature information is not correct. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Supports creating the Waterfall Chart. Workbookworkbook=newWorkbook(); workbook.loadFromFile("input.xlsx"); Worksheetsheet=workbook.getWorksheets().get(0); ChartofficeChart=sheet.getCharts().add(); //Setcharttypeaswaterfall officeChart.setChartType(ExcelChartType.WaterFall); //Setdatarangetothechartfromtheworksheet officeChart.setDataRange(sheet.getRange().get("A2:B8")); //Datapointsettingsastotalinchart officeChart.getSeries().get(0).getDataPoints().get(3).setAsTotal(true); officeChart.getSeries().get(0).getDataPoints().get(6).setAsTotal(true); //Showingtheconnectorlinesbetweendatapoints officeChart.getSeries().get(0).getFormat().showConnectorLines(true); //Setthecharttitle…
Spire.XLS for Java 5.1.5 enhances the conversion from Excel to PDF/HTML/images
2022-01-18 06:08:35
We are happy to announce the release of Spire.XLS for Java 5.1.5. This version enhances the conversion from Excel to PDF/HTML/images, as well as HTML to Excel. In addition, it fixes some known issues such as the application threw an exception when loading excel file. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-3540 Fixes the issue that the application threw an exception when loading excel file. Bug SPIREXLS-3561 Fixes the issue that the page number position was incorrect after converting excel file to PDF. Bug SPIREXLS-3574 Fixes the…
