The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Set As for multiple selected worksheets

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
AKazak	Posted - 04/28/2020 : 2:10:59 PM Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2019b (64-bit) 9.6.5.169 Operating System: W7 Pro x64 SP1 Greetings! I have a workbook with many sheets of imported data and want to designate the columns in batch. It seems that GUI doesn't allow us to do this, doesn't' it? Is a macro the only option? Thank you.
7 L A T E S T R E P L I E S (Newest First)
AKazak	Posted - 05/01/2020 : 03:26:15 AM quote: Originally posted by cpyang What Nikolay is saying is that programmers coming from C/C++ like to write i++ instead of i+=1, that's all, it is entirely a matter of coding habit. CP OK, I see. I also code C/C++ by the way.
cpyang	Posted - 04/30/2020 : 7:57:19 PM What Nikolay is saying is that programmers coming from C/C++ like to write i++ instead of i+=1, that's all, it is entirely a matter of coding habit. CP
AKazak	Posted - 04/30/2020 : 6:25:12 PM quote: Originally posted by nick_n Great. But usually "iC++", easy to read and write. Nikolay What is iC++? Please share the corresponding hyperlink.
nick_n	Posted - 04/30/2020 : 2:08:16 PM Great. But usually "iC++", easy to read and write. Nikolay
AKazak	Posted - 04/30/2020 : 1:41:35 PM quote: Originally posted by AKazak Great, thank you for suggesting this! I will create a script and post it here. int ncols = wks.ncols; string WorkBookName$ = %H; string SheetName$ = wks.name$; for(int iC = 1; iC <= ncols; iC += 1) { range TargetColumn = [WorkBookName$]%(SheetName$)!col($(iC)); TargetColumn.type = 2; // https://www.originlab.com/doc/LabTalk/ref/Wks-Col-obj
AKazak	Posted - 04/29/2020 : 05:15:49 AM quote: Originally posted by nick_n Hi, Yes. For looping over objects see: https://www.originlab.com/doc/LabTalk/guide/Looping-Over-objs#Looping_over_Workbooks_and_Worksheets Nikolay Great, thank you for suggesting this! I will create a script and post it here.
nick_n	Posted - 04/29/2020 : 02:26:33 AM Hi, Yes. For looping over objects see: https://www.originlab.com/doc/LabTalk/guide/Looping-Over-objs#Looping_over_Workbooks_and_Worksheets Nikolay

The Origin Forum

Snitz Forums 2000