The Origin Forum - wAppend multiple sheets

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

wAppend multiple sheets

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Shivavishnu

USA
4 Posts

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

AmandaLu

439 Posts

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

Shivavishnu

USA
4 Posts

Posted - 03/29/2018 : 10:05:54 AM

Thanks, it worked perfectly!

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000