Excel - XSL protect/password

Posted on 2007-10-16
Last Modified: 2013-11-18
Does anyone know if during an excel transform via xsl sheet, is it possible to add the protect params and a password?

Question by:William
    LVL 60

    Assisted Solution

    by:Geert Bormans
    I assume the answer is "no"
    The idea behind transformation to XML is to open up the spreadsheet for use in other applications
    encrypting only works on the binary excel format
    LVL 12

    Accepted Solution

    When you try to save a password protected sheet to xml, excel explicitly forbids it.
    If the file is in xml format it cannot be password protected in any way. (range, worksheet, workbook)

    I figure the reason is, anybody with a text-editing tool could simply edit out the password protection section.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
    SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
    The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
    The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now