Writing data to excel file.

[Alv]

I'd like to write data to a excel file at a location within the file (ex. sheet1, column A, row 4). Can this be done?

[LunaBlue]

Yes, there should be an labveiw example.

Alv wrote:
> I'd like to write data to a excel file at a location within the file
> (ex. sheet1, column A, row 4). Can this be done?

[Michael_Munroe]

Yes. Look at the example Write Table to XL. It demonstrates the process of opening Excel, creating a workbook, selecting a sheet and writing a block of data. You can modify this example to open an existing file, select a different sheet (by index or name) and write data to anywhere on the sheet. Each piece of data is written to a specified location using the index of the two For loops (row and column). Just adjust the numeric row and column values to the desired offset.

Michael Munroe
www.abcdef.biz

[Alv]

I've been writting my data to spreadsheet file (txt.file), Can I use Read From Spread Sheet File vi.? I tried understanding the code. Don't really understand what going on there.

[Michael_Munroe]

Write to Spreadsheet creates a tab or comma delimited file. If you need to offset the location of the data being written, insert additional tabs to offset to the right or additional CR/LF to offset down one row. Then when the data is read back in, it will be shifted in the array. If read by Excel, it will be offset on the page. There is no way to use these functions to move data to another sheet without writing a separate file.

Michael