Excel report

[dueduekcue88]

Hello,

i generate some data from measurment and want to write this data into an excel template. For that i want to control in wich cell the data will be written. Do anyone have an example for that or can explain it please? I used the standard examples from LabView but it didnt work that way i wanted. Thanks a lot!

Best regards

Özgür D.

[XM43]

Hi dueduekcue,

There are examples available in NI Example finder:  I recently went through it, it is fairly straight forward.

You would need "Report Generation toolkit" (This is one way I know of)

Also, in order to write to a specific column, I defined those column in excel first (Define Name) and then simply used their name in cluster constant as below:

This is something that I just did in rush. I am sure there are better ways to do what you want. But this should at least get you started.

Edit: Did not read that you already had gone through examples. (oops)

Well in that case, where did you get stuck? What part did not work out for you?

[Bob_Schor · Accepted solution]

If you have the Report Generation Toolkit, there is an Example on the Forum that shows (I think pretty clearly) how to generate a simple Excel "Report" (Spreadsheet).  On the Forum's Search Bar, type "Revised Generate Excel Report Example".  The author is a friend of mine ...

Bob Schor

[dueduekcue88]

Thanks a lot! It worked!

[ZHOUYHUI]

I need to use the report tool to open excel on the Mac version, but I can't write data into a separate sheet now. What should I do

[Bob_Schor]

---

@ZHOUYHUI wrote:

I need to uPse the report tool to open excel on the Mac version, but I can't write data into a separate sheet now. What should I do

---

Please do not "hijack" another member's Post.  Start your own Post, describe what you are trying to do, and post the LabVIEW code that you are trying to use.  You can also post a "picture" of the Block Diagram, but without all the actual VIs, such a picture is not too useful.

Bob Schor