| T O P I C R E V I E W |
| Shivavishnu |
Posted - 03/28/2018 : 4:57:11 PM
Hi,
I'm trying to append multiple sheets with the same name from different books to a single sheet. The worksheets I'm trying to append have the same name "Summary", but the multiple workbooks they're held within have different names. I wanted to simply put a wildcard in for the book name as follows, but it's unable to resolve the range string.
wAppend irng:=([*]Summary!) method:=row ow:=[<new>]<new>
How should I go about doing this?
Thanks,
T
Origin Ver. and Service Release (Select Help-->About Origin): 2018 (64-bit) b9.5.0.193 (Student Version)
Operating System: Windows 10 Pro |
| 2 L A T E S T R E P L I E S (Newest First) |
| Shivavishnu |
Posted - 03/29/2018 : 10:05:54 AM
Thanks, it worked perfectly! |
| AmandaLu |
Posted - 03/29/2018 : 03:35:02 AM
Hi,
wappend cannot recognize wildcard in the input range. To find all the worksheet named “Summary”, you will need to loop all windows:
str$ = "";
doc -e W{
if( exist([%H]Summary!)==2 )
{
str$ += "[%H]Summary,";
}
}
str.Delete(len(str$));
wAppend -r 2 irng:=(%(str$));
Thanks,
Amanda
OriginLab Technical Service
|
|
|
