Transfer Data on a spreadsheet

[AntoineLt]

Hi everyone,

For my project I work with a CCD camera, and I have to record scan's data. Data is composed of the time corresponding for each scan while a scan will give the intensity received by the camera for each pixels.

My trouble is that when I export datas on Labview, I don't know how I can place them the way that time would be on the first spreadsheet line and that pixels number would be on the 1st column. In fact, for now when I create an Array and export my data I have the time on the first line and data under as if the pixels number was placed horizontally ( as time).

A second trouble is that between 2 scans value there is always a blank column of 0 wich I want to delete, so I tried to create a Delete From Array function with a Quotient & Remainder function as to delete columns when the remainder of the iteration loop divided by 2 equal 0 (blank columns are on pairs columns)

So basically, I would like to know if there is any easy way to custom an excel spreadsheet when we export Labview's data into excel.

[Alexander_Sobolev]

Ok, I tried to understand labview program without labview program, now your turn.

When you are placing time, write spreadsheet ends the line. Data goes to the next line. First add time to the scan, then append resulting array to file.

>>  I don't know how I can place them the way that time would be on the first spreadsheet line and that pixels number would be on the 1st column.

Spreadsheet files are written line by line. You can not add column into file without reading it and replacing data.

If you are writing into file after each scan, pixel numbers should be in the first row, times - in the first column. Otherwise you need to accumulate all data and write 2D array.

I would advise to use raw file write functions. Open file once, use array to spreadsheet string, write this string and new line into file. Close after done measuring. Faster, more control of the data structure and formatting.