quote:

---

Originally posted by hschausb

I am trying to find out how OriginLab sorts the used WorksheetPages.

I am programming Origin C and need a steady WksPages which do not change their count/sort number on every reboot of OriginLab.

I am initializing my WksPages like this “WorksheetPage book1 = Project.WorksheetPages(x);”. x is the WksPage count in the project. And these counts change around every second reboot of OriginLab which means I have to check if the WksPage objects are included to the right name every time.

Can anybody tell me “HOW” this count is done by OriginLab. I tried playing with the name of the WksPages (alphabetically, creation date) but I cannot find the pattern of the count/sort in the project.

---

foreach(WorksheetPage wp in Project.WorksheetPages){ /* your code */}

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

It seems to be sorted so that the active WorksheetPage (from project saved latest) is returened from Project.WorksheetPages(x) with the x as large as possible.

The following code should give you the WorksheetPage's in a stable order:

foreach(WorksheetPage wp in Project.WorksheetPages){ /* your code */}

---

quote:

---

Originally posted by hschausb

quote:

---

It seems to be sorted so that the active WorksheetPage (from project saved latest) is returened from Project.WorksheetPages(x) with the x as large as possible.

The following code should give you the WorksheetPage's in a stable order:

foreach(WorksheetPage wp in Project.WorksheetPages){ /* your code */}

---

Would you mind explaining why I should use a "foreach" if the code only runs through the first Worlpage?
Also I do not understand how this sets up a static worksheet count? Which comand is it that does that?
And the last question. I am working with self made functions and everything. What is supposed to go into the "your code" part? The main programm with all sub functions? Only the main programm? Should this be in the main programm included during the inclusion of the WorksheetPages and Worksheets?

---

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

Originally posted by cpyang

Maybe you can explain a bit more on what you are trying to do? Why do you need to write code based on some count? Why not use name which is more reliable and self-explanatory?

CP

---

quote:

---

Originally posted by Castiel

It seems to be sorted so that the active WorksheetPage (from project saved latest) is returened from Project.WorksheetPages(x) with the x as large as possible.

The following code should give you the WorksheetPage's in a stable order:
foreach(WorksheetPage wp in Project.WorksheetPages){ /* your code */}

---

quote:

---

Originally posted by hschausb

quote:

---

Originally posted by cpyang

Maybe you can explain a bit more on what you are trying to do? Why do you need to write code based on some count? Why not use name which is more reliable and self-explanatory?

CP

---

I am new to Origin C and there is a high possibility that I have missed this, so bear with me.
IT IS POSSIBLE TO INCLUDE WORKSHEETS BASED ON NAME??? I have looked for 2 hours and could not find a way to include worksheets based on their name. I also could not find a way to check if there is any Worksheet with a specific name already existing (Object.Exist is not the right thing; at least for Origin C).
If you have a way, pleas, please, pretty please tell me. You would be my hero.

quote:

---

Originally posted by Castiel

It seems to be sorted so that the active WorksheetPage (from project saved latest) is returened from Project.WorksheetPages(x) with the x as large as possible.

The following code should give you the WorksheetPage's in a stable order:
foreach(WorksheetPage wp in Project.WorksheetPages){ /* your code */}

---

Why would I use the “Active Worksheet” if this changes depending on which Worksheet I am working on?

---

WorksheetPage wp("Book1");

Worksheet wks("[Book1]Sheet1");

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------

quote:

---

Originally posted by Castiel

To get a WorksheetPage by name:

WorksheetPage wp("Book1");

To get a Worksheet by name:

Worksheet wks("[Book1]Sheet1");

See the constructors of WorksheetPage and Worksheet:
https://www.originlab.com/doc/OriginC/ref/WorksheetPage-WorksheetPage
https://www.originlab.com/doc/OriginC/ref/Worksheet-Worksheet

---

quote:

---

Originally posted by hschausb

Can somebody please delete this post.
I cannot delete it even as the orginal author.
Thank you very much.

---

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------