LabVIEW
Adding a simple encryption to a CSV, Excel, or Zip file
Does any one have an idea on how to password encrypt an Excel file (or csv) in LabVIEW or zip up the excel file/csv and add a password to it that way? I need to be able to add a simple encryption to confidential patient data files after they are created and be able open them to read later by the same program.
I think the solution would be to use some sort of property/ invoke node with ActiveX like I've attempted to do in the picture below but I can't find anything that explains exactly how property and invoke nodes work with ActiveX to achieve what I wanted, and I was hoping someone would have a tutorial that a LabVIEW beginner like me could use.
A few other things over I've tried recently:
I've tried using OpenG to create a password protected ZIP file that the patient data would be inside it seemed like an easier solution at first but the password protection didn't do anything maybe I was using it wrong but I couldn't figure it out or find a solution online.
Something else that I looked at was adding a "blowfish" encryption to encrypt the data but seemed extremely complicated and all I need is a simple password encryption.
Finally I tried using an add on called AES crypto but I felt that the encryption methods that were featured in the add on were limiting. For patient names they would be at different lengths and in the example programs it showed that if a string was shorter than 128 bits then it would't be able to encrypt the string. Which is an issue if the patient has even a regular length name.
If you have any thoughts or find anything useful let me know.
Thanks,
usmanf
With the AES encryption, you are supposed to add in a buffer to fill in a block.
My simple encryption for text files is to just invert all of the bits in the file (read as a byte array, NOT, Byte Array To String). It is very crude and not really secure, but enough to keep technicians from messing around.
