read perticular collumn of xls file

[kabariya]

hi

i have one data file in which i want to read 3rd column(c) and want to plot it with respect to time.

help reuired please

thanks

[GerdW]

Hi kabariya,

first you should rename that file to "*.csv", it's not a real Excel XLS file...

Then you should use ReadFromSpreadsheetFile to load the file and IndexArray to index the 3rd column. When you know the time of the data creation you could use a waveform to plot your data, otherwise simply plot the column data over an arbitrary X axis...

Edit:

You have asked this in a different thread before. WHY DO YOU CREATE DOUBLE POSTS FOR THE SAME TOPIC?

[kabariya]

hi

so what to do  to convert

 "*.csv" file to Excel XLS file...

[GerdW · Accepted solution]

Hi kabariya,

your attachment is actually a CSV file so all you need to do is to rename it...

[kabariya]

yes i would like to do this.

thanks