Spire.XLS 15.3 supports creating, modifying and removing slicer
2025-02-28 08:49:25
We're pleased to announce the release of Spire.XLS 15.3. This version supports creating slicer using table data, modifying slicer, retrieving slicer information and removing slicer. Besides, it also fixes an issue that the slicers were lost when converting Excel to PDF. More details are shown below. Here is a list of changes made in this release Category ID Description New feature - Added support for creating slicer using table data. Workbook wb = new Workbook(); Worksheet worksheet = wb.Worksheets[0]; worksheet.Range["A1"].Value = "fruit"; worksheet.Range["A2"].Value = "grape"; worksheet.Range["A3"].Value = "blueberry"; worksheet.Range["A4"].Value = "kiwi"; worksheet.Range["A5"].Value = "cherry"; worksheet.Range["A6"].Value = "grape"; worksheet.Range["A7"].Value = "blueberry";…
Spire.XLS 15.2.3 supports preserving the original format in the ExportDataTable() function
2025-02-20 08:20:46
We are pleased to announce the release of Spire.XLS 15.2.3. The latest version supports preserving the original format in the ExportDataTable() function. Moreover, several known bugs are fixed successfully in this update, such as the issue that Japanese characters were converted to English characters after updating the pivot table. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-568 Supports preserving the original format in the ExportDataTable() function. ExportTableOptions op = new ExportTableOptions(); op.ExportColumnNames = true; op.KeepDataType = true; var r = sheet.Range["A1:M7"]; New feature SPIREXLS-5539 Supports the MUNIT…
Spire.XLS 15.1.3 supports the CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND functions
2025-01-14 07:32:12
We're pleased to announce the release of Spire.XLS 15.1.3. This version adds the support for many functions, CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND, CHOOSECOLS, CHOOSEROWS, and DROP. Besides, it also fixes some issues that occurred when converting XLSM to PDF, Excel to PDF, calculating formula values and setting tab color. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5542 Supports the CSCH function New feature SPIREXLS-5548 Supports the RANDARRAY function. New feature SPIREXLS-5621 Supports the COTH function. New feature SPIREXLS-5622 Supports the SEQUENCE function. New feature SPIREXLS-5627 Supports the…
Spire.XLS 14.12.2 supports the SEC, WRAPCOLS, PERCENTOF, REPTARRAY, SUBSTITUTES functions
2024-12-19 03:11:42
We're pleased to announce the release of Spire.XLS 14.12.2. This version adds the support for many functions, including SEC, WRAPCOLS, WRAPROWS, PERCENTOF, REPTARRAY, SECH, SUBSTITUTES and more. Besides, it also fixes some issues that occurred when converting Excel to PDF and printing Excel files. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5561 Supports the SEC function. New feature SPIREXLS-5562 Supports the WRAPCOLS function. New feature SPIREXLS-5563 Supports the WRAPROWS function. New feature SPIREXLS-5574 Supports the VSTACK function. New feature SPIREXLS-5577 Supports the PERCENTOF function. New feature SPIREXLS-5578…
Spire.XLS 14.11.3 supports passing values to group pivot tables
2024-11-25 07:40:36
We're pleased to announce the release of Spire.XLS 14.11.3. This version supports passing values to group pivot tables, and also supports the new formulas including ACOT, ACOTH, COT, TOROW, TOCOL. Moreover, some issues that occurred when converting, loading, saving and printing Excel documents have been successfully resolved. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5469 SPIREXLS-5470 SPIREXLS-5546 SPIREXLS-5564 SPIREXLS-5565 Supports the new formulas including ACOT, ACOTH, COT, TOROW, TOCOL. New feature SPIREXLS-5534 Supports passing values to group pivot tables. Workbook wb = new Workbook(); wb.LoadFromFile(inputFile); Worksheet pivotSheet…
Spire.XLS 14.10.2 supports ARRAYTOTEXT, ARABIC, BASE, COMBINA, XOR formulas
2024-10-31 05:49:33
We're pleased to announce the release of Spire.XLS 14.10.2. This version supports ARRAYTOTEXT, ARABIC, BASE, COMBINA, XOR formulas, and also supports embedding images into cells as well as getting a cell's NamedRange. What’s more, the issues that occurred when converting Excel to PDF, retrieving number of pages, and exporting data has been successfully resolved. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5350 MarkerDesigner now supports applying filter value parameters. New feature SPIREXLS-5396 ARRAYTOTEXT formula has been supported. Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Text = "True"; workbook.Worksheets[0].Range["A2"].Text =…
Spire.XLS 14.9.5 supports adding filters to row fields/column fields of pivot tables
2024-09-27 08:35:49
We are excited to announce the release of Spire.XLS 14.9.5. The latest version supports adding filters to row fields/column fields of pivot tables. Furthermore, some known bugs are successfully fixed in this update, such as the issue that the content is incorrect when converting Excel documents to images. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5255 Supports adding filters to row fields/column fields of pivot tables. XlsPivotTable pt1 = workbook.Worksheets["PivotTable_1"].PivotTables[0] as XlsPivotTable; pt1.RowFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000); pt1.ColumnFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000); pt1.CalculateData(); New feature SPIREXLS-5393 Supports the TEXTBEFORE…
Spire.XLS 14.9.1 supports identify OLE objects in Msg format
2024-09-06 08:49:19
We are happy to announce the release of Spire.XLS 14.9.1. This version supports identify OLE objects in Msg format and disabling DTD processing. It also implements the support for the BAHTTEXT formula. Moreover, some known issues are fixed successfully in this version, such as the issue that the result of data summing using MarkerDesigner function was incorrect. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5307 Adds the 'OleObjectType.Msg' type to identify OLE objects in Msg format. Workbook wb = new Workbook(); wb.LoadFromFile(inputFile); Worksheet sheet =wb.Worksheets[0]; OleObjectType type;…
