writing data to excel sheet

[Gagan_01]

Hi,

I have a few questions when writing to an Excel sheet, please refer to the VI attached.

Question1. In the present VI the data that gets stored from the second VI into the excel sheet is offset by 5 rows, how do i get this to start from the same row as the data written in the first for loop.

Question2. How can i reverse this data in loop 2 such that it gets written as 5 4 3 2 1 and not 1 2 3 4 5.

Any ideas would be much appreciated. I want the data to be wirtten directly to the file as soon as it is read to prevent loss of and data due to software crash.

I guess the answer to Question 2 would be that i have to wait for the entire array to be read before reversing it, i can work with that but what about the first question.

Thanks

GM 

[Gagan_01]

Sorry forgot to attach VI

[Gagan_01]

Damn sorry i found another mistake

Question1. In the present VI the data that gets stored from the second FOR LOOP into the excel sheet is offset by 5 rows, how do i get this to start from the same row as the data written in the first for loop

[johnsold]

The Tabs being fed to the Write Chars to File VI in the second loop are what is causing the offset. A Tab causes the spreadsheet to move to the next cell in the row. What purpose do the Tabs serve?

As for reversing the data you would need to collect all the data for the row and reverse it before writing to the file. Since you indicated that you are writing to file as the data is collected to prevent data loss, you have to decide whether to risk the loss of a whole row of data or to post-process the file to reverse the data after the collection is completed.

The Write Characters to File and Write to Spreadsheet File VIs open/write/close the file internally. This can slow operations in a loop. Depending on the data collection rates and the risk of data loss, you may want to consider whether the frequent opening and closing, especially in the second loop, is apprpriate.

Lynn

[Gagan_01]

Hi,

Thank you for your response, i purposely added the Tabs so that i can be offset by two columns, but i cannot start from row 0. I guess the only way to do this is to collect all the data and arrange it accordingly.

GM