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
 How to add column to all workbooks in a project?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

JOSAMUEL

United Kingdom
1 Posts
Posted - 07/23/2021 :  1:48:30 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi all,

I have 10 workbooks for example in a project with the workbooks named as 1 till 10. Now I need to add a column in all of the 10 workbooks. However, when I'm adding, the column added in the workbook named 1 should have the number 1 in all the rows, and the column added for the workbook named 2, should contain the number 2 in all the rows. likewise, it should go on until file 10th file. Any idea how to do this?

Thanks in advance.

JOSAMUEL

snowli

USA
1411 Posts
Posted - 07/23/2021 :  6:11:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I suppose you mean book long names are 1 to 10 since book short names can't start with number.

Then suppose you only have 1 sheet in book, try this

doc -e W {
book$ = page.longname$;
wks.ncols=wks.ncols+1;
csetvalue col:=$(wks.ncols) formula:=book$;
}

Thanks, Snow
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