IronXL v2022.11.10251

Version 2022.11.10251 Features & Upgrades

https://www.nuget.org/packages/IronXL.Excel/2022.11.10251

Release Notes:

  • Adds: Overloads for WorkBook loading methods to accept a password for encrypted XLSX, XLSM and XLTX workbooks. 
    • Full list of added overloads:
    • TryLoad(string filename, string password, out WorkBook workBook)
    • TryLoadExcel(string filename, string password, out WorkBook workBook)
    • Load(byte[] data, string password)
    • Load(Stream stream, string password)
    • LoadExcel(byte[] data, string password)
    • LoadExcel(Stream file, string password)
    • LoadExcel(string filename, string password)
    • FromByteArray(byte[] data, string password)
    • FromStream(Stream stream, string password)
  • Adds: Method WorkBook.Encrypt(string password) which will write a workbook into a MemoryStream, encrypt it using a password provided as an argument or the one stored in WorkBook.Password property and return resulting encrypted MemoryStream - Only supports XLSX, XLSM and XLTX workbooks
  • Adds: Method WorkBook.Decrypt(Stream stream, string password) which will decrypt a Stream a password provided as an argument and return resulting decrypted MemoryStream - Only supports XLSX, XLSM and XLTX workbooks
  • Fixes: Bug where some border styles cause an exception when exporting workbook as HTML
  • Fixes: Bug where InsertRow method would throw an exception, if the row was inserted in the place of the last existing row
  • Improves: Precision of AutoSizeRow and AutoSizeColumn methods
  • Improves: Performance of InsertRow method by 25%