07-28-2011 01:18 AM
Hi All,
I am using Labview 7.0 and have successfully transported my data in to excel file. Further my requirement is to protect the excel sheet cell. I found many examples and codes for protecting sheet but my question is Can i make the excel sheet's cell write protected?? If yes than how ??
Also i came to know through those examples that using invoke node for Activex controls and selecting class as Excel._ worksheet, where i can set the method as Protect. To this invoke node i need to connect reference but don't know how to create reference for the new excel report??
If any one has idea abt that, then please.... guid me through vi's or snapshots.
Thanks & Regards,
Ratna
07-28-2011 05:50 AM
Hi,
Can anyone tell me how to create reference of excel report ???
ratna
07-28-2011 08:29 AM
Does this help?
07-29-2011 01:38 AM
Hi vt92,
Thanks for ur reply, i woluld suggest u to have a look at excel report.png image as this may clear my requirement. In that vi i have transffered my data into excel sheet (area marked with red colour box) after that i m bringing that worksheet to front n then saving the report. Now my requirement is to make that worksheet password protected before saving it.
Actually, I have gone through my discussion forums n found that to make worksheet password protected, need to use invoke node with class as Activex Excel._Worksheet n in that select method as protect but my confusion is wat input shuld i gave to that invoke node???
Regards,
Ratna