07-10-2014 10:41 AM
I.m writing data to a excel .xlsx file after which I want to write protect the file is there a way to do this?
Solved! Go to Solution.
07-10-2014 10:50 AM - edited 07-10-2014 10:52 AM
How are you generating the Excel file? You can use the "Set permissions" file primitive in Advanced file functions to do what you want.
07-10-2014 10:54 AM
P@Anand wrote:
How are you generating the Excel file? You can use the "Set permissions" file primitive in Advanced file functions to do what you want.
Have you ever had success with that? I find on current Windows technology that this function isn't very effective.
If the OP wants to set the Excel Protect Content flag to stop editing of the contained data, then there's nothing in the Report Generation Toolkit for this (as far as I know). But you could probably work it out from some study of the COM interface to Office and a little bit of work.
07-10-2014 10:57 AM
@Thoric wrote:
P@Anand wrote:
How are you generating the Excel file? You can use the "Set permissions" file primitive in Advanced file functions to do what you want.
Have you ever had success with that? I find on current Windows technology that this function isn't very effective.
To be honest I never used it in any of my application . Once I saw the question I went to help and made sure that it can be used to set the file permissions (Read, write, ful control)
07-10-2014 11:34 AM
Thanks for the quick reply the set Permissions vi worked
07-10-2014 12:21 PM
Then please mark P@Anand's message as the solution to your question rather than your own thank you message. You will first need to unmark your message as the solution by going to the Options menu to the upper right of your message.
07-11-2014 08:11 AM
P@Anand wrote:
@Thoric wrote:
P@Anand wrote:
How are you generating the Excel file? You can use the "Set permissions" file primitive in Advanced file functions to do what you want.
Have you ever had success with that? I find on current Windows technology that this function isn't very effective.
To be honest I never used it in any of my application . Once I saw the question I went to help and made sure that it can be used to set the file permissions (Read, write, ful control)
I think maybe the read/write permission part works, but it's also supposed to work on other attributes which don't work at all. Anyway, glad it works for the OP
09-29-2015 08:24 AM
Hi everyone,
i want to ask you how can i convert data and xy-graph into excel sheet?
Thanks
ps.: is something wrong with my programm? because nothing is in the graph (no plots)
09-29-2015 08:40 AM
Dear BC2010,
This question (or variants on it) have been asked and answered many times on this forum, and in the LabVIEW Examples.
If you want to ask a new question, don't tag it on to the end of someone else's query, but start your own. Even better, do a little research (you can often find answers by using Google) and try to develop code (that you post) yourself. Note that if you do post code, you need to post running code, which means either post the VI itself or a Snippet (and if you don't know what a Snippet is, find out!).
Bob Schor
09-30-2015 10:04 AM
Hello BC2010:
In this link you can find several ways to do what you are asking.
http://www.ni.com/newsletter/51339/en/