The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 More columns!!! Please...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

bacharan

1 Posts

Posted - 12/24/1998 :  7:29:00 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
When I try to import ASCII files into a worksheet, the maximum number of columns created is exactly 427, whatever the number of files to import is. How can I increase this number to 1000 (for example), because I would like to plot all this files at the same time.

Gary Lane

USA
150 Posts

Posted - 12/29/1998 :  1:29:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Origin 5.0 has a limit of 427 columns per worksheet. However, you can have multiple worksheets in the same project file so Origin can store all of your data in one project file...just not in one worksheet. Furthermore, you can plot data from different worksheets into the same graph window by adding the datasets via the Layer Contents dialog box (double click on the layer icon in the upper left corner of any graph window). This will allow you to plot any of your 1000 columns in one graph window.

The Origin ASCII import routine has a column limit of 255 when importing ASCII files into worksheets (I am not an Excel expert by any means but it appears to me that Excel's import limit is 256). To work around this constraint, import your ASCII data into an Origin Matrix (Matrices have a much higher import routine column limit and a much higher column limit in general) and then copy paste the matrix columns into multiple worksheets. I was able to import over 1000 columns of data and plot them into one graph window using this method. Please note that there is also a limit of 427 datasets in one layer so you will need to create multiple layers in your graph window as well.

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000