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
 Copying lots of data from excel
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Peretti

Italy
Posts

Posted - 03/03/2008 :  10:06:44 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 8
Operating System: Windows Xp

Hi, i have some problems copying data from an excel file to origin.
I'm plotting a bytime graph; i have 20 measureas, each of 15 min, and the sampling period is of 0.1 sec. so i have to move about 9000 values.
i don't understand if it's normal that origin needs so much time (about 4-5 minutes) to copy the data.
the pc configuration is: pentium 4 3.61 GHz, 1 GB Ram

Is there someone who can help me?
please, my boss is breaking my balls...

cpyang

USA
1406 Posts

Posted - 03/03/2008 :  12:39:39 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
The fastest way to bring Excel data to Origin is to drag and drop that Excel book into Origin. You can then copy and paste to other Origin books after that.

Could you send us your excel file so that we can look to see why it is so slow? If we just create new excel file with that much data, we do not see this problem.

You can send emial to me directly at cp@originlab.com


CP



Go to Top of Page

Peretti

Italy
Posts

Posted - 03/04/2008 :  05:40:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
hi. i can't send you the measurement file, but i can explain you how it is made.
i have to move a coloumn of data; the number of cells that i want to copy is about 9000. the values into these cells are progressive (for example from 5400.1 to 6300.1); the values into another range of cells, that i have to copy, are like: 60.0 58.8 62.1 59.6 etc..
i tried to open the excel file into origin (not with the drag and drop method but with the "open excel" button), but the process didn't speed up.
i tried to turn off my firewall (kaspersky), but i saw in task manager that the memory (about 108 M) utilized by origin didn't grow;
and the process didn't speed up.
however,
thank you
MC
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