Insert rows to excel spreadsheet using LabVIEW

[achfire]

Hi

is it possible to get each row of a table in a a different worksheet, for example the 1st row in the 1st worksheet and so on using just EXCEL ADVANCED VIs.

for example the 1st row in the 1st worksheet

[achfire]

any suggestion

[Pawan_Nanotech]

Hello....
I think you want to ask about to add something in a row of excel sheet...If I am right then here its a very easy task provided by labview functions shown in below .vi

[achfire]

thanks

i will take a look in your Vi,if it wil help me,because i'm looking to get each row of the same table in a different worksheet of the same excel workbook

[Roohcifer]

Hi achfire,

If you want some more control (like creating worksheets), take a look at this example:

https://decibel.ni.com/content/docs/DOC-20014

As for getting each row into a new worksheet, tables auto-index at for loop boundaries just like arrays do. On the above example, add a for loop so that you are creating a new sheet, indexing your table by row at the for loop boundary, and writing that row's data to the table. 

Let us know if you run into more issues!

Best,

[achfire]

where exactly to add the loop,because i already use it but i didn't succed,maybe i missed something

[Roohcifer · Accepted solution]

Hey achfire,

I made a few edits to your code, and it appears to work now. Generally speaking, we don't want to open and close references or files within a loop. Instead we can open the file once, read/write to it in our loop, and then save/close it when finished. I also removed the index array function, as for loops can auto-index at loop bounaries. (This also prevents us from having to wire a number of iterations into the "N" terminal.)

Let me know if this helps!

[RavensFan]

What is the purpose of the 1-D string array constant that is empty?  It looks like it is just there to turn the 1-D array into a 1 row 2-D array.  If so, you just need the build array function with only one input and get rid of the empty string array constant.

[achfire]

Roohcifer

ii doesn't work because i have labview 2012

[Roohcifer]

Hi achfire,

Try modifying your code to look like this: