Excel

[cjp1]

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?

[P@Anand · Accepted solution]

How are you generating the Excel file? You can use the "Set permissions" file primitive in Advanced file functions to do what you want.

[Thoric]

---

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.

[P@Anand]

---

@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)

[cjp1]

Thanks for the quick reply the set Permissions vi worked

[RavensFan]

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.

[Thoric]

---

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 

[BC2010]

 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)

[Bob_Schor]

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

[JBarrman]

Hello BC2010:

In this link you can find several ways to do what you are asking.

http://www.ni.com/newsletter/51339/en/