How to append an Excel worksheet

[Dennis_B.]

When using the Append Table to Report vi (Functions Palette>>Programming>>Report Generation>>Append Table to Report.vi) you wire a string constant to specify the point in which excel will insert data (MS Office parameters). It is fairly straight forward, just set the column and row numbers. But, how would you configure it to accommodate a mathematical location. In other words, for example, at the first iteration insert a three row table five rows down from the top and every iteration thereafter insertion in multiples of five????????

What I'm doing is building an excel worksheet from an x/y graph each time the graph is updated.

[Andrew_E · Accepted solution]

Hey Dennis,

I am attaching a screenshot of a section of code that should do the trick.

[Dennis_B.]

Hi Andrew,

  Thanx for the code.  I'm kind of new to Labview, what sub vi did you use in the while loop?  I can't find it.

[Jeremy_B]

I believe that VI is the Append Table to Spreadsheet VI.

[Dennis_B.]

Hi Jeremy,

  I can't find this VI, can you tell me exactly where it is located, I'm using ver 8.6.  I'm starting to think our IT department did not load the entire developer suite on my PC.

Thanx,

Dennis

[Jeremy_B]

I think the VI may be from an older version of the toolkit, I don't seem to have the exact icon.  You can probably use the Append Table to Report VI.

[Dennis_B.]

Hi Jeremy,

  I tried it and it works as advertised.  Thanx for the help.

Dennis