I have been using the import wizard (Origin Pro 8.5) to pull x and y columns of data from many ascii files. This works fine but I would like to automatically interpolate the data to make my data processing life easier. So I searched the help and forums then went to advanced options of the import wizard and put down several permutations of:
This did not work. I would greatly appreciate any suggestions for getting this to work. Also I am not married to this approach, my ultimate goal is a spreadsheet full of evenly spaced y-axis data imported from many different files.
Sam, thank you for your reply. When using the script you gave me interpolated values of column 2 are placed after each data set. So that my spreadsheet looks like this:
X1 Y1 Interp1 X2 Y2 Interp1 X3 Y3 Interp1
I need it to interpolate the subsequent imports not just column 2. That is why I was trying to put it in a loop so that the iy:=Col(2) would change and interpolate the new data.
Sam, I have "run script after each file imported" selected and "Start New Columns" is selected as the Import Mode. Each ascii file has 4 columns but I am only importing the middle two, one x and one y.
I believe that Origin is considering column 2 as being from the Origin sheet and not the importing file (note that if I put iy:=Col(3) I get an error message on the first import and then it repeatedly interpolates Origin column 3).
I have sent three sample files via the web form. Thank you again for your time.
Batch import and interpolate (Origin Pro 8.5)
Posted - 08/02/2011 : 6:02:01 PM
