Spire.XLS 9.12.20 supports retaining the filtered stream data when converting Excel to CSV

We're pleased to announce the release of Spire.XLS 9.12.20. This version supports retaining the filtered data when converting Excel to CSV and also fixes these issues that occurred when converting Excel to PDF, manipulating and loading excel file. View more details below.

New Features:

• Supports retaining the filtered stream data when converting Excel to CSV.

worksheet.SaveToStream (Stream stream, string separator, bool retainHiddenData);

Bug Fixes:

• Fixes the issue of the drop-down box was missed.
• Fixes the issue that the worksheet.IsEmpty returned incorrect results.
• Fixes the issue that it threw the exception "the object reference was not set to the object instance" when loading an Xlsx file.
• Fixes the issue that the worksheet.IsPasswordProtected returned incorrect results.
• Fixes the issue that the content was incorrect when converting from Excel to PDF.
• Fixes the issue that the speed was slow when using Filter() method to filter.
• Fixes the issue that it threw the exception “ArgumentOutOfRangeException” when loading an Xlsm file.
• Fixes the issue that it threw the exception “The specified parameter has exceeded the range of valid value “when copying a sheet by using the workbook.Worksheets. AddCopy (sheet) method.
• Fixes the issue that the image was shrunk when converting Excel to PDF.
• Fixes the issue that it threw “XmlException” when loading an Xlsx file.
• Fixes the issue that the content was missed when converting from an Xlsm file to PDF.
• Fixes the issue that the additional content appeared when converting an Xlsx file to PDF.