| T O P I C R E V I E W |
| jens-peter |
Posted - 07/15/2003 : 09:46:28 AM
Is there a way to creata, let's say, 500 columns at once and NOT looping worksheet.AddCol 500 times?
TIA
Jens |
| 4 L A T E S T R E P L I E S (Newest First) |
| jens-peter |
Posted - 07/16/2003 : 03:28:46 AM
Thanks Mike!
This does the trick :)
Jens |
| Mike Buess |
Posted - 07/15/2003 : 6:26:08 PM
Hi Jens,
This should do it (although I've never actually tried with N as large as 500)...
worksheet -a N; // Add N columns to the active worksheet
Oops, this is the Origin C forum. Make that
LT_execute("wo -a 500");
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 07/15/2003 6:34:57 PM
Edited by - Mike Buess on 07/15/2003 6:35:38 PM |
| jens-peter |
Posted - 07/15/2003 : 10:54:10 AM
Thanks for the hint!
But it seems to me that no more than 11 columns can be created at once. I tried the Strimng "0 1 2 3 4 5 6 7 8 9 10 ...", and only the first 11 columns were added to the worksheet.
Jens |
| Septor |
Posted - 07/15/2003 : 10:00:15 AM
try it with
Worksheet wks;
wks = (Worksheet)proj.ActiveLayer();
ActWksName = wks.GetPage().GetName();
LT_set_str("%Z", ActWksName);
LT_execute("%Z!wks.insert(name list)");
the list can consist of one or more desired column names separated by spaces.
|
