Wavefrom graph time from .csv

[Oesen]

Hello everyone 🙂

I use "read from spreadsheet file" to read a two column .csv file in a waveform graph.

Time is defined in the first column and the Data is defined in the second column.

The problem occurs in the x-axis of the graph (Time-axis). It doesn't match with the numbers from the .csv as shown on the picture below, but the Y-axis has correct values.

The VI is uploadet

[altenbach]

Can you attach your data file?

[Oesen]

I can't attach .csv files here in NI forum.

It says:

Please correct the highlighted errors and try again.

• The attachment's content type (application/vnd.ms-excel) does not match its file extension.

[BillMe]

I don't think your x-axis is formatted for relative time. If you look at your data, the 14th row is the one you have highlighted in the graph which corresponds to the x-axis value.

And from the error message it sounds like you didn't save your excel file as csv but simply renamed the extension.

[altenbach]

---

@Oesen wrote:

I can't attach .csv files here in NI forum.

---

You can put anything you want in a zip file before attaching.

What is the actual dt value you obtain by subtracing?

[Oesen]

Right !.. I have uplodet it now 🙂

[Oesen]

Hi BillMe

It is formated now, and it doensn't make anything difference

[altenbach · Accepted solution]

Works fine here once I configure it to use a comma as decimal delimiter (using format=" %,;%.3f " on read from spreadsheet file).

You seem to use a foreign version so that should not be necessary, depending on the language setting of your computer but it seems to be the problem.

As a first step, you should display the entire 2D array in an array indicator to ensure that your number don't get truncated somehow. If they get truncated, dt will be set as zero and thus ignored and taken as 1.

 

[Oesen]

Thanks for the help altenbach !. It works now 🙂

[BillMe]

No wonder I couldn't make any sense out of the csv file format.