pagesave with mode=update does not work

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

fhespeler
Posts: 12
Joined: Thu Jul 07, 2016 3:10 am

pagesave with mode=update does not work

Postby fhespeler » Mon Apr 01, 2019 2:55 pm

Dear all,

I attempt to save a alpha series via the command

pagesave(type=excelxml,mode=update) "C:\Users\fhespeler\Desktop\blhelp.xlsx" range="ticker!B1" @keep ticker

but is does not work. I checked for the existence of the file via

@fileexist("C:\Users\fhespeler\Desktop\blhelp.xlsx")

and got a 1 as a result, so the file clearly exists. Also if I exchange mode=update with mode=overwrite, the file is successfully overwritten. What can I do?

My EVIEWS version is EVIEWS 10+ Enterprise Edition

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: pagesave with mode=update does not work

Postby EViews Gareth » Mon Apr 01, 2019 3:04 pm

Could you define what "does not work" means?

I just tried a quick test, and it seemed to work fine.

Code: Select all

wfcreate u 100
alpha ticker = "hello"
pagesave(type=excelxml) myfile.xlsx range="b2" @keep ticker

ticker = "world"
pagesave(type=excelxml, model=update) myfile.xlsx range="b2" @keep ticker
Follow us on Twitter @IHSEViews

fhespeler
Posts: 12
Joined: Thu Jul 07, 2016 3:10 am

Re: pagesave with mode=update does not work

Postby fhespeler » Tue Apr 02, 2019 6:24 am

The first command did not produce any saving results. Could it be that's due to the target file containing EXCEL Bloomberg formulas in another sheet than the target sheet?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12172
Joined: Tue Sep 16, 2008 5:38 pm

Re: pagesave with mode=update does not work

Postby EViews Gareth » Tue Apr 02, 2019 7:15 am

Did you try my test program, and did it work?
Follow us on Twitter @IHSEViews

fhespeler
Posts: 12
Joined: Thu Jul 07, 2016 3:10 am

Re: pagesave with mode=update does not work

Postby fhespeler » Tue Apr 02, 2019 7:32 am

Your testfile worked perfectly. It first produced a file with entries "hello" and then overwrote this with entries "world".


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest