GitHub user Raja10D added a comment to the discussion: Locking or Password-Protecting Excel Files in Hop (Post Excel Writer Step)
> there is a "Protected by user" option that lets you specify a password in the > "Sheet & Template" tab of the Excel Writer transform. I noticed that there are two options available: "Protected by User" and "Password." Could you clarify which one I should use to lock or password-protect the Excel file? **I have entered a values in both fields, for eg: "demo" in both fields but after running the pipeline, the file is not locking with the value "demo", I entered in "Protected by User" field and "Password" field** Do I need to enter a fixed value in the respective field, or can I use a variable instead? Is it possible to set the password dynamically based on the input file name, such as using "R12354" as the password for the file "R12354batch12.xls"?  GitHub link: https://github.com/apache/hop/discussions/5156#discussioncomment-12802077 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
