The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum for Programming

LabTalk Forum

deleting a workbook Sheet

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

Smilies

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
kitzbrado	Posted - 08/04/2008 : 03:41:18 AM Hello Can you please tell me how I can delete/create a whole Sheet in a workbook? I know how I can manipulate different columns in different sheets but I didn't find a way to delete or create a single sheet. Thank you.
5 L A T E S T R E P L I E S (Newest First)
adamleewiner	Posted - 08/05/2008 : 04:18:13 AM Thank you very much. An USTCer always keep trying.
kitzbrado	Posted - 08/05/2008 : 02:09:39 AM Thank you for the answers.
cpyang	Posted - 08/04/2008 : 09:08:30 AM Before 80SR2, you need to do the following to delete a sheet from any book regardless of active book or not: win -o book1 {page.active$=sheet2;lay -d}; In 80 SR2, we have "fixed" this and now it is very simple: layer -d name; // del layer/sheet in active page layer -d [book]sheet;// general range notation CP
adamleewiner	Posted - 08/04/2008 : 05:35:21 AM SIR: How to make a sheet active? How to remove a specified sheet that is not active from a workbook? quote: Originally posted by Deanna Hi Kit, We have an X-Function, newsheet, which provides an convenient way to insert a new worksheet to a workbook. Please see details here: http://www.originlab.com/www/helponline/Origin8/en/mergedProjects/X-Function/data_manipulation/newsheet.htm To remove a worksheet, please first make the sheet active and then run the following script command: layer -d Deanna OriginLab Technical Services An USTCer always keep trying.
Deanna	Posted - 08/04/2008 : 04:23:11 AM Hi Kit, We have an X-Function, newsheet, which provides an convenient way to insert a new worksheet to a workbook. Please see details here: http://www.originlab.com/www/helponline/Origin8/en/mergedProjects/X-Function/data_manipulation/newsheet.htm To remove a worksheet, please first make the sheet active and then run the following script command: layer -d Deanna OriginLab Technical Services

The Origin Forum

Snitz Forums 2000