The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Not ASCII #Command Error!

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

[quote][i]Originally posted by lillt91[/i]
[br]Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: Windows 8

Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System:  Windows 8

Hi everyone, this is my code for a little script i wrote to handle my data. Sadly it wont work the way i want bc it crashes at the point "newbook;". Does anyone know how to fix it?

the error origin shows me: 
"newbook
Not ascii
#Command Error!"

[quote]range strom = 2:9;
del wcol(32);
del strom;

wtranspose iw:=<active> ow:=<active>;

worksheet -s 0 1 0 1;  
wks.SetAsLabel(C,-1,0,0);

col(1)=Data(1,22);

wcolwidth irng:=%H width:=7;

//deleting cols with empty data
ncols=wks.ncols;
for(ii=ncols;ii>=1;ii--)
{
	if (mean(wcol($(ii))) == 848)
	{
		del col($(ii));
	}
}

//add new book, activate book1 again 
[red]newbook;[/red]
win -a Book1;
wks.name$ = Raw;

//interpolation
n=2;
for(ii=2; ii<=wks.ncols; ii++)
{
interp1xy iy:=[Book1]"Raw"!wcol($(ii)) method:=spline npts:=154 oy:=[Book2]"Sheet1"!wcol($(n));
n++;
}[/quote]

[/quote]

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
lillt91	Posted - 05/05/2018 : 06:38:57 AM Origin Ver. and Service Release (Select Help-->About Origin): 2018b Operating System: Windows 8 Origin Ver. and Service Release (Select Help-->About Origin): 2018b Operating System: Windows 8 Hi everyone, this is my code for a little script i wrote to handle my data. Sadly it wont work the way i want bc it crashes at the point "newbook;". Does anyone know how to fix it? the error origin shows me: "newbook Not ascii #Command Error!" quote: range strom = 2:9; del wcol(32); del strom; wtranspose iw:=<active> ow:=<active>; worksheet -s 0 1 0 1; wks.SetAsLabel(C,-1,0,0); col(1)=Data(1,22); wcolwidth irng:=%H width:=7; //deleting cols with empty data ncols=wks.ncols; for(ii=ncols;ii>=1;ii--) { if (mean(wcol($(ii))) == 848) { del col($(ii)); } } //add new book, activate book1 again newbook; win -a Book1; wks.name$ = Raw; //interpolation n=2; for(ii=2; ii<=wks.ncols; ii++) { interp1xy iy:=[Book1]"Raw"!wcol($(ii)) method:=spline npts:=154 oy:=[Book2]"Sheet1"!wcol($(n)); n++; }
1 L A T E S T R E P L I E S (Newest First)
YimingChen	Posted - 05/07/2018 : 11:34:30 AM Hi, I can't reproduce the issue. Would you mind sending your project to <tech@originlab.com> so that we double-check with your data? Thank you. Yiming -OriginLab

The Origin Forum

Snitz Forums 2000