Exporting Grid To Excel With Password?

[Rob]

I'm able to export a .xls file without any trouble, but I would like to make it password protected.  Is this supported?

I found this: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/protection/worksheet which appears to be what I'm trying to achieve, only in JavaScript.

 

[Stefan]

Hello, Rob,

Currently, the export document can be protected when the RadSpreadprocessing library is used. We have an MVC demo showing how to export the Kendo UI Grid using the RadSpreadprocessing:

https://demos.telerik.com/aspnet-mvc/spreadprocessing/grid-integration

Also, I can suggest submitting a feature request to have this as a built-in option inside the Grid Excel export:

http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback?category_id=170340

Regards,
Stefan
Progress Telerik

[Rob]

Thank you for the response.

 

After looking over more of the documentation, I'm a little unclear on something.  It looks like Excel files have different concepts of 'protection'.  There is the sheet-level protection that prevents a user without the password from modifying certain things, but there is also the file-level protection that requires a password before it can be opened.

 

I haven't been able to find an example with Telerik libraries that will password protect the entire file.  From within Excel, it's the 'Password to open' value that controls this.  Does the RadSpreadProcessing support this functionality?

 

Thank you again

[Tanya]

Hi Rob,

Indeed, the protection of a spreadsheet file can be applied on several levels. Protecting a workbook, in general, prevents modifying its sheets in terms of adding, removing, renaming, etc. You can also protect a worksheet - this allows you to keep the data in the sheet unmodified. The last option - protecting the whole file with a password, however, is not supported in RadSpreadProcessing. We have logged a feature request for that functionality and you can vote for its implementation as well as track its status through the public item in our feedback portal.

Regards,
Tanya
Progress Telerik