A password protected Excel document causes an error message "End of central Directory not found".
Would it be possible to get a more appropriate error message at least? The possibility to enter a Password would be great, of course.
4 Answers, 1 is accepted
This is most likely using Xls file format. Import of this format type is currently not supported. You can vote for the public item, and subscribe to track it for eventual status changes:
SpreadProcessing: Support for import and export of .XLS documents
RadSpreadsheet operates with a rich document model that is completely decoupled from UI. The documentation of the model can be found in the RadSpreadProcessing section of the documentation for Telerik Document Processing here.
Supported file formats are Xlsx, Pdf, Csv, Txt.
If this is not the case, could you share the document you are using?
You can easily reproduce the issue by creating a simple xlsx file and protecting this file with a password. I'm trying to upload a test document "password_asdfgh.xlsx". Since the forum does not allow xlsx to be uploaded I've renamed the extension to png.
In case you need it, password is "asdfgh".
Thank you for elaborating on the matter. The feature you are trying to use is not yet implemented by the RadSpreadSheet. "Encrypt with password" not only sets a password necessary to open the workbook, but it also fully encrypts the file. The protection feature implemented in RadSpreadsheet is the protection of the workbook structure.
We have this logged in our Feedback portal here, where you could vote for the item and follow it in order to get immediate updates on it.
1. Change the extension (Microsoft Office 2010 or previous versions only).
2. Open a password-protected Excel spreadsheet with VBA (for opening and blocking editing Excel worksheets).
Changing the extension is a relatively simple way to open Excel with password protection[/url].