This is a migrated thread and some comments may be shown as answers.

Password protected Excel document

4 Answers 115 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 04 Jul 2017, 10:30 AM

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.

 

Thanks

Michael

4 Answers, 1 is accepted

Sort by
0
Peshito
Telerik team
answered on 07 Jul 2017, 08:36 AM
Hello Michael,

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?

Regards,
Peshito
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
0
Michael
Top achievements
Rank 1
answered on 10 Jul 2017, 06:08 AM

Hello Peshito,

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".

 

Best regards

Michael

 

 

0
Peshito
Telerik team
answered on 11 Jul 2017, 12:31 PM
Hi Michael,

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.

Regards,
Peshito
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
0
liz
Top achievements
Rank 1
answered on 28 May 2019, 03:45 AM
There are two most commonly used methods to solve this problem:
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].
Tags
Spreadsheet
Asked by
Michael
Top achievements
Rank 1
Answers by
Peshito
Telerik team
Michael
Top achievements
Rank 1
liz
Top achievements
Rank 1
Share this question
or