Exporting Grid To Excel With Password?

4 posts, 0 answers
  1. Rob
    Rob avatar
    4 posts
    Member since:
    Mar 2016

    Posted 30 Jan Link to this post

    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.

     

  2. Stefan
    Admin
    Stefan avatar
    1965 posts

    Posted 01 Feb Link to this post

    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
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Rob
    Rob avatar
    4 posts
    Member since:
    Mar 2016

    Posted 01 Feb in reply to Stefan Link to this post

    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

  4. Tanya
    Admin
    Tanya avatar
    726 posts

    Posted 02 Feb Link to this post

    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
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top