Sending data to excel, but only writes to cell A1

[Mary Mary]

I've modified the counter.vi example to count the # of pulses given by an encoder and I 've plotted the data versus time. But now when I try to send the data to an excel spreadsheet, it keeps writing over the previous data in cell A1. How do I format the "write to spreadsheet.vi" so that it will write the data in separate cells? In order to write in just the A1 file, I had to convert the "U32" bit to "SGL" bit and then concatenate it with the "Build Array.vi" then attached that to "write to spreadsheet.vi". Inside the loop, it asks for a new file after acquiring each data point and writes it only in cell A1. Outside the loop, it records only the last data point in A1. How can I rectify this?

I've been scanning through the example vi files for the "write to spreadsheet.vi" and data logging examples with no luck.

I would appreciate any help you could give me.

Thanks

[Wendy L]

Hello Mary,

First, you might want to wire a "TRUE" boolean constant into the "Append to File" input terminal of the Write To SpreadSheet File VI. The default value is false so the VI replaces data in an existing file.

If this doesn't correct the problem, would it be possible for you to post your VI so that we can take a look at how it is setup.


Thanks.

[Mary Mary]

Thank you Wendy for your help. The True boolean constant worked! Can't believe the solution was so easy.