12-30-2009 08:34 PM
12-30-2009 09:12 PM
Are you actually writing to an Excel Spreadsheet? Or are you using the Write to Spreadsheet file function which does not write to an Excel spreadsheet, but creates a text file that Excel is able to open?
I'm going to assume the latter. There is no way to just "append" a column to it. You will need to read the whole file, append the column to the array, and write out the whole file column overwriting the previous file.
12-30-2009 09:30 PM
If you write directly in Excel you could utilize "write_to_active_cell.llb" (http://zone.ni.com/devzone/cda/epd/p/id/4523) with small modifications.
Jean-Marc
12-31-2009 10:59 AM
Hi,
Assume you have report generation toolkit installed for MS office,
You read the array data and want to append the data to excel file, each time you read the array data increment the column number by one, If you report generation toolkit for MS office you will get excel VI's asking for the which row which column.
You can alter column value everytime to update new data into excel file.
12-31-2009 04:21 PM