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…

We are excited to announce the release of Spire.XLS 13.10.1. This version improves the efficiency of Excel to PDF conversion and supports customizing the names of pivot table fields. It also enhances the conversion from Excel to HTML. Moreover, some known issues are fixed in this version, such as the issue that deleted annotations were not removed successfully from the document. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-4907 Improves the efficiency of Excel to PDF conversion. New feature SPIREXLS-4857 Supports customizing the names of pivot table…

We are pleased to announce the release of Spire.XLS 13.9.1. This version supports saving shape to image. What’s more, some known issues are fixed in this version, such as the issue that the data wrapping was incorrect after converting Excel to CSV. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-4866 Supports saving shape to image. Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); Worksheet sheet = workbook.Worksheets[0]; //convert shapes to images SaveShapeTypeOption shapelist = new SaveShapeTypeOption(); //save the shapes in worksheet to images. shapelist.SaveAll = true; Dictionary<IShape,Bitmap> images =…

We are excited to announce the release of Spire.XLS 13.8.9. This version supports adding signature lines, getting shapes in sheets, and customizing the paper size without scaling the content during printing. Besides, some known issues are fixed in this version, such as the issue that the slicer was lost after saving the Excel document. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-2146 Supports customizing the paper size without scaling the content during printing. sheet.PageSetup.SetCustomPaperSize(224, (float)25.4); sheet.PageSetup.Orientation = PageOrientationType.Portrait; New feature SPIREXLS-4640 Supports adding Signature Line. sheet.Range["A1"].AddSignatureLine("e-iceblue","E-iceblue","123@123.com", "description"…