The Origin Forum

The Origin Forum

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
misrapr	Posted - 12/26/2007 : 08:03:25 AM Origin Version (Select Help-->About Origin): 8 Pro Operating System: Win XP Pro How to find the number of sheets present in a workbook and get their names ??
2 L A T E S T R E P L I E S (Newest First)
misrapr	Posted - 01/03/2008 : 01:32:23 AM Thanks Cpyang !! that worked like a charm ....
cpyang	Posted - 12/26/2007 : 10:03:41 AM A. From LT 1. page.nlayers, as a book is a page and each sheet is a layer. 2. wks.name$, but better use range, see below: loop(i,1,page.nlayers) { range ss=$(i)!; ss.name$=; } B. from OC, idea is the same WorksheetPage wp = Project.Pages(); foreach(Layer lay in wp.Layers) { Worksheet wks = lay; printf("sheet name is %s\n", wks.GetName()); }

The Origin Forum