We're pleased to announce the release of Spire.XLS 14.7.2. This version supports obtaining the custom properties of a worksheet and the original document name of the embedded OLE object. What’s more, the issues that occurred when converting Excel to image and PDF 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-5274 Supports obtaining custom properties of worksheets. Workbook workbook = new Workbook (); workbook.LoadFromFile("funds-test.xlsx"); ICustomPropertiesCollection customProperties = workbook.Worksheets[0].CustomProperties; for (int i = 0; i < customProperties.Count; i++) { XlsCustomProperty xcp = customProperties[i]; string name…

We're pleased to announce the release of Spire.XLS 14.6.6. This version supports converting Excel to Markdown format, and fixes some issues that occurred when converting Excel to image/HTML, and adding filter to Excel PivotTable. More details are shown below. Here is a list of changes made in this release Category ID Description New feature - Supports converting Excel to Markdown format. Workbook workbook = new Workbook(); workbook.LoadFromFile("input.xlsx"); workbook.SaveToFile("output.md",FileFormat.Markdown); Bug SPIREXLS-5191 Fixes the issue that the application threw "ArgumentOutOfRangeException" when setting "horizontal" and "vertical" type borders. Bug SPIREXLS-5243 Fixes the issue that the effect was incorrect when calling "Worksheet.Activate()" method. Bug…

We're pleased to announce the release of Spire.XLS 14.5.3. This version supports adding images to the first page header and footer, obtaining active selection range, as well as finding cells based on regular expressions. In addition, some known issues that occurred when converting Excel to PDF/ images, importing data into Excel, and autofitting columns have been successfully fixed. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5128 Supports adding images to the first page header and footer. //Load image System.Drawing.Image bufferedImage = System.Drawing.Image.FromFile(inputFile_Img); //Set image on first page…

We are pleased to announce the release of Spire.XLS 14.3.3. This version supports PivotTable grouping functionality. In addition, it also supports adding the FindAll() method to CellRange and setting "Repeat All Item Labels" for PivotTable. Some known issues have also been successfully fixed in this version, such as the issue that the content was incorrect after saving Excel files. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-765 Supports PivotTable grouping function. XlsPivotTable pt = worksheet.PivotTables[0] as XlsPivotTable; IPivotField field = pt.RowFields[0]; DateTime start = new DateTime(2024, 5,…

We're pleased to announce the release of Spire.XLS 14.2.1. This version supports setting the clipping position of header and footer images. In addition, some known issues that occurred when converting XLSX documents to PDF or images have been successfully fixed. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5038 Supports setting the clipping position of header and footer images. sheet.PageSetup.LeftHeaderPictureCropTop=6.15; sheet.PageSetup.LeftHeaderPictureCropBottom=7.15; sheet.PageSetup.LeftHeaderPictureCropLeft =7.15; sheet.PageSetup.LeftHeaderPictureCropRight = 6.15; sheet.PageSetup.LeftFooterPictureCropTop=0.15; sheet.PageSetup.LeftFooterPictureCropBottom=0.15; sheet.PageSetup.LeftFooterPictureCropLeft =0.15; sheet.PageSetup.LeftFooterPictureCropRight =0.15; sheet.PageSetup.CenterHeaderPictureCropTop=0.15; sheet,PageSetup.CenterHeaderPictureCropBottom=0.15; sheet.PageSetup.CenterHeaderPictureCropLeft=0.15; sheet.PageSetup.CenterHeaderPictureCropRight =0.15; sheet.PageSetup.CenterFooterPictureCropTop=0.15; sheet.PageSetup.CenterFooterPictureCropBottom=0.15; sheet.PageSetup.CenterFooterPictureCropLeft =0.15; sheet.PageSetup.CenterFooterPictureCropRight=0.15; sheet.PageSetup.RightHeaderPictureCropTop=0.15; sheet.PageSetup.RightHeaderPictureCropBottom=0.15; sheet.PageSetup.RightHeaderPictureCropLeft=0.15; sheet.PageSetup.RightHeaderPictureCropRight=0.15; sheet.PageSetup.RightFooterPictureCropTop=0.15; sheet.PageSetup.RightFooterPictureCropBottom=0.15;…

We are excited to announce the release of Spire.XLS 14.1. This version adds XLT, XLTX, and XLTM formats to the FileFormat enumeration and improves the memory usage of converting worksheets to images. Besides, it also enhances the conversion from Excel to PDF and CSV. Furthermore, some known issues are fixed successfully in this version, such as the issue that retrieving cells failed. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5036 Improves the memory usage of converting worksheets to images. New feature SPIREXLS-5006 Adds XLT, XLTX, and XLTM…

We are delighted to announce the release of Spire.XLS 13.12. This version enhances the conversion from Excel to PDF. Besides, many known issues are fixed in this version, such as the issue that the calculation of some formulas failed. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-4838 Fixes the issue that it threw System.IndexOutOfRangeException and System.NullReferenceException exceptions when converting worksheets to HTML documents in multi-threaded parallel. Bug SPIREXLS-4899 Fixes the issue that the VLOOKUP function was parsed incorrectly. Bug SPIREXLS-4969 Fixes the issue that the obtained transparency value…

We're pleased to announce the release of Spire.XLS 13.11.4. This version mainly fixes the issues occurring when convert Excel to HTML or PDF. In addition, some known issues are fixed, such as the function SHEET(A3) did not auto calculate, and the watermark was incorrect after copying a worksheet. More details are as follows. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-4876 Fixed the issue that some cells were missing when convert Excel to HTML. Bug SPIREXLS-4880 Fixed the issue that the font directory did not take effective when converting Excel to PDF. Bug…