Hi Kina,
Thank you for your interest in Syncfusion ExcelRW.
Currently it is not possible to open spreadsheets which are password protected. The problem is that when excel files are protected their contents are encrypted and the encryption algorithm is not available. One alternative could be that you could use Macros to protect workbooks, end users need the password to view the files but ExcelRW would still be able to open files protected using Macros.
Please let me know if you have any questions.
Thanks,
Stephen.
>Hi,
>The method ExcelUtils.Open(filename) generate an exception when the workbook is protected. The exception message is: {"\r\nParameter name: length\r\nActual value was 3." }
>You''ll find attached an example of a protected workbook.(kina is the password to unprotect the workbook and the worksheets)
>I use the Syncfusion.ExcelRW.Base dll version 3.0.1.0
>
>Regards,
>
>Kina
>
>
protected_Book_1869.zip
>
>
