How to save 1D array data to excel continuously

[syamni]

Sir,

how to save 1D array data to excel continuously,in such a way that all the  data from first scan must be placed in first raw and all data's from the second scan must be placed on the second raw and go on...

sy@m..

[Dennis_Knutson]

Do you mean row?

In any case, do you want to save in native Excel format or is a text file that Excel can read okay? The simplest is to write a text file with the Write to Spreadsheet File/Write to Measurement File/Write to Text File function. What have you tried? What is generating the data? Have you looked at any of the numerous examples?

[GerdW]

Hi syamni,

sounds like you want to create a 2D array from your scan data and save that to a CSV file using WriteSpreadsheetFile...

[Dennis_Knutson]

---

@GerdW wrote:

Hi syamni,

sounds like you want to create a 2D array from your scan data and save that to a CSV file using WriteSpreadsheetFile...

---

Or just wire the 1D array to the 1D array input.

[syamni]

Sorry for the spelling mistake..

The thing is I am getting stream of 1D array like 123456123456123456123456... go on from a gpib instrument.And when I am going to save in spreadsheet file I am getting the saved data as 123456123456123456123456.Actually I want to save as

123456

123456

123456

123456 and go on in excel format. Have you got my point...

Waiting for your comment....

Sy@m....

[Dennis_Knutson]

Well, 123456123456123456123456 is not a 1D array. It is a single string. So, are you really getting an array or not? Since there seems to be confusion as to what is actually read and how, attach your code.

[IanW · Accepted solution]

Hi Sy@m

Here's a vi which might give you some ideas to try out:

[syamni]

thank you..thanks a lot....

 sy@m..