Excel Spread Sheet Encryption

[Dev2018]

Hello All, 

I have generated a .csv file with all the necessary information that I entered as a result of some task execution using the Writing Tab Delimited String to Delimited Spreadsheet. The .csv file is now saved in the location that I have directed it to. Works as expected. 

Now I am looking to generate an encrypted spreadsheet that should be "read only" or "password protected sheet" using the Write Delimited Spreadsheet.vi. Looking forward for your responds. 

Thank you in advance. 

[RavensFan]

A couple things.

Write Delimited Spreadsheet does not create an Excel Spreadsheet file.  It creates a text file.  If you name it as a .csv, then Excel is able to import that file when it opens it, but it is still not an Excel file.

So any encrypted/password functions that Excel has won't apply to it.

[aeastet]

What are you hoping for with your result? Do you want a file that one authorized people can open and read? Do you need it to only open in Excel? You could use a zip file with a password to do what you are looking to do. You could write a binary file and give the other person a reader (you would have to build this). You could go a step further and write encrypted data. then save it to a binary file. You would again need a reader that would decode the encryption and format back to data that you want. There was a LabVIEW version of a program for encryption called Blowfish. I am not sure if it is still available or not.