Reading of password protected xls file

[anivij]

hiii

I am using Labview7.0 version.

I have two files.Name of the two files are

1.Demo.xls

2.Demo.dat

User will do changes into the Demo.xls file.After completing the changes into the Demo.xls file I am transfering the contents of Demo.xls file into Demo.dat file.

If Demo.xls file is without password protection then data are getting properly transfered into the Demo.dat file But if Demo.xls file is with password protection then i am not able to transfer the data into the Demo.dat file.

Plz give me the solution of how to transfer the contents of password protected excel file into the .DAT file as per explained in the above example

regards

anivij

[MikeS81]

Hi anivij,

how do you transfer the data from *.xls file to *.dat file? Do you use ActiveX?

Mike

[anivij]

hii Mike

yes, I am using ActiveX

using invoke node selecting workbooks option in ActiveX component & assigning OPEN proerty to open the Excel sheet.with this method Password protected excel file is properly getting open & i can do the changes into excel file save operation properly.

But in the next stacked sequence i am not able to transfer the data of this password protected excel file into the .dat file.

For reading the data from this password protected excel file  i am using READ STRING FROM SPREADSHEET FILE.vi tool & writing into the .dat file with WRITE FILE.vi tool

with this operation i am getting encrypted data in .dat file.

So plz give me the solution how to access the data from PASSWORD PROTECTED EXCEL FILE?

anivij

[MikeS81]

Hi anivij,

i think you should also use the ActiveX function to read your data. Is it possible for you, or do you have special requirements for it?

Mike

[anivij]

Hii Mike

actually i am trying with ActivX but i am not able to get it so plz tell me how to get it through ActivX

anivij

[MikeS81]

Hi anivij,

attached is an example for you. The interesting cases for you, are the light blue ones.

Hope it helps.

Mike

[MikeS81]

Hi anivij,

sorry they are all for LabView 8.0. But here are pictures of it.

Mike