import .csv table

Hi,

You can import your table using  View:utility tab: tools:Table create.Import option for csv ,txt & .dat is available.

See attached thumbnail.

Regards

Rahul R

<?xml version="1.0" encoding="UTF-8"?>

HI Nppo,

Here is a small screen shot of a single lined XY data.

In the image A represents X and B represents Y.

Input the X and Y values in the excel sheet and save the same as .csv file.

<?xml version="1.0" encoding="UTF-8"?>

Thank you for your answer and I am sorry I wasn't clear. that is what I have been doing but the problem is my .csv file I don't know how it has to be written. For example it looks like:

100;17107
101;18008

102;18233

103;18130

103.25;18239

etc...

where 1st value is frequency and 2nd is stiffness, but this format doesn't work.

Hi,

In which format you are getting the Frequency vs Stiffness data(ASCII, dat etc).Looks like in your csv file you are not getting two columns.one for freq and another one for Stiffness.

Or you are getting any error while running for discontinuty in data points?

Regards

Rahul R

Your are right, I only get one column. It is just an excel file I transformed into .csv because the acceptable formats are csv/txt/dat

Try to get data in two columns.Then only Hm will read data correctly.

Regards

Rahul R

I tried it and it didn't work.  all values in both x and y in table are zero. it only works when I insert the values manually

<?xml version="1.0" encoding="UTF-8"?>

Hi,

I mean from which tool and in which format you are getting freq vs stiffness value.

Regards

Rahul R

I had the same issue for .csv import.

The format I had in .csv file was:

100;17107
101;18008

102;18233

103;18130

103.25;18239

etc...

This format lead to the right number of points but with 0 for all cells (same as nppo).

I changed it to (replace ' ; ' by ' , '):

100,17107
101,18008

102,18233

103,18130

103.25,18239

etc...

And table import works...

May be an issue in Excel parameter for .csv format..

Nice workaround.

Regards

Rahul R