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
 Max number of worksheets
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

SamBellamy

France
Posts

Posted - 08/03/2006 :  10:05:36 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 6.1
Operating System:Win2000 Pro

Hi,
I am using a LabTalk script to treat a large number (several hundreds) of high resolution laser spectra. Each "slice" of the global spectrum is loaded in a different worksheet, but it seems that I can not import more than 500-600 files. Is there a known limit to the number of worksheets in a project? It does not seem to be a RAM problem, after checking with FreeRAM.

Thanks,
Sam

easwar

USA
1965 Posts

Posted - 08/03/2006 :  2:04:29 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sam,

Can you provide more details? Does your script pop up say a multi-open file dialog, and you select more than 500 files, in which case the limitation could be a limit on the buffer that holds all the file names...

Best to contact tech support and send them more details or your OGS file etc.

Easwar
OriginLab


Go to Top of Page

cpyang

USA
1406 Posts

Posted - 08/03/2006 :  2:54:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Aside from the possibility of the Multi-Files-open dialog, there might also be a problem of showing many windows at a time.

There is no limit on the number of pages (window, or worksheet window), but there are limits from the OS in simultaneously keeping all of them visible. What you might need to do would be

A. after import, make the worksheet hidden

or

B. after import, move the worksheet into a folder such that it will be hidden since only worksheets in active folder are shown by default.

CP


Go to Top of Page

SamBellamy

France
Posts

Posted - 08/04/2006 :  05:53:00 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply

Thanks for your replies.
Here's some more information about my problem. In fact, to start the data processing, I manually import all the spectrum slices using the "Import Multiple ASCII" command. Two things may happen:
1 - I am importing too many files (somewhere above 700-800, if no other applications are running on my PC) and the application shuts down during this operation
2 - I import 500-600 files and this is done with no problems. Then I start processing the data with my LabTalk script, which creates again a large number of worksheets and graphs (100-200 more windows) but it comes a time where the LabTalk script stops and a message is shown that says something like "Cannot create a blank document" or something similar.

So I guess that your hints are correct, it should be something related to the buffer for the worksheets names or about showing all the windows at a time. I will try to hide as many windows I can during the execution of the script using "win -ch 1".

By the way, another question: is it possible to perform operations (create directories, moving worksheets/graphs, ...) on the Project Explorer using commands in a LabTalk script? I could never find how to do that.

thanks,
Sam
Go to Top of Page

SamBellamy

France
Posts

Posted - 08/04/2006 :  09:52:42 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply

I tried to import a huge data acquisition of 1581 files and it worked following CP's "A" suggestion. Indeed, I first tried to import all the 1581 files in a single load and Origin shut down. Then I restared importing the first 750 files, and it worked fine, and I changed them to "hidden". Then I imported files 751-1581 and again everything was fine. So, really, it seems that, at least with WIN-2000 OS, there is a limit to the number of visible windows that can be handled at a time. (Incidentally, other applications running strongly reduce the number of files needed to crash the application: with a second Origin window open and processing data, I could not load more than 300 files.)
Now the LabTalk script is processing the 1581 files spectrum, with some "win -ch 1" command added to keep most windows hidden. I will post a couple of lines message next monday (data processing takes tens of hours) to confirm that everything works.

Thanks again,
Sam
Go to Top of Page

easwar

USA
1965 Posts

Posted - 08/04/2006 :  3:24:45 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:

By the way, another question: is it possible to perform operations (create directories, moving worksheets/graphs, ...) on the Project Explorer using commands in a LabTalk script? I could never find how to do that.



Hi Sam,

In the current version, Origin 7.5, such script access exists for manipulating Project Explorer. Also Origin C programming was introduced in 7.0 which has access to Origin objects. You may want to try the 7.5 demo.

Easwar
OriginLab


Go to Top of Page

SamBellamy

France
Posts

Posted - 08/07/2006 :  04:02:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
The 1581 files data processing failed, but probably for reasons related to RAM, or other hardware issues. I am pretty sure that it will work simply splitting theprocessing in two 800 files sections. The error message was different from the usual "Cannot create a blank document" and I think that my first problem has been fixed hiding the worksheets.
Yet, it seems that I have to upgrade both my hardware and Origin version if I want to get where I'd like to be....
Thanks again,
Sam
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