새 오버로드를 사용하면 암호화된 XLSX, XLSM 및 XLTX 통합 문서에 대한 암호를 수락할 수 있습니다.
11월 7, 2022
신규 버전
기능
Added 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).
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).
Added new WorkBook.Encrypt(string password) method 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 supported for XLSX, XLSM and XLTX types of workbooks.
Added new WorkBook.Decrypt(Stream stream, string password) method which will decrypt a Stream a password provided as an argument and return resulting decrypted MemoryStream. Only supported for XLSX, XLSM and XLTX types of workbooks.
Improved precision of AutoSizeRow and AutoSizeColumn methods.