real time add to excel spreadsheet

[MSD100]

I am using real time waveform chart for displaying results along with excel spreadsheet to write into file...I am able to write the values of y-axis of chart into spreadsheet..but don't know how to link up that value with x-axis in spreadsheet...I mean how can enter both x-axis and y-axis values of real time chart so that one column having value of x-axis (real time in this case) and other column having y-axis....so one can link the values......also how to add heading to first column of excel sheet??

[muks]

Do you have report generation tool kit? By spread sheet do you mean/want it in excel or any other format?

[MSD100]

I have already done it in excel by saving .xls.....I am able to store y axis part....but don't know about x-axis,... I don't know about tool-kit...

[muks]

Can you post your data/vi or a screen shot to show how you are getting the data?

[MSD100]

I have used real time chart and write to spreadsheet examples to do that....attach vi later......so using realtime chart and write to spreadsheet example able to do that but unable to enter time in excel.....

[RTSLVU]

Without seeing what you are trying to do all I can say is...

Build a two dimensional array with your X and Y values.

Use the Array to spreadsheet function to save the array to an xls file

you will end up with two columns containing your X and Y values

[Joe_H]

If you are using the write to spreadsheet file function then you are not actually writing to an Excel file. What you are writing to is a Tab delimited or Comma Seperated file that Excel can read. In order to write to a "True Excel File" then you have to use the Report Generation Toolkit or you must manually do it through Active X components.

Please post what you have done and we will be able to assist you furthur. It is really just a matter of building your array correctly before you write it to the file.

[MSD100]

vi is attached.........

[Troy12]

Hello,

Instead of open/array to spreadsheet string-write to text file/close, you can pass array to Write to Spreadsheet File VI (see attached image) with the required delimiter type.

- Troy

[MSD100]

To Troy,

Will it write the timestamp into excel?