EViews.com

Posted: **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

Posted: **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

Posted: **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?

Posted: **Tue Apr 02, 2019 7:15 am**

Did you try my test program, and did it work?

Posted: **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".

EViews.com

pagesave with mode=update does not work

pagesave with mode=update does not work

Re: pagesave with mode=update does not work

Re: pagesave with mode=update does not work

Re: pagesave with mode=update does not work

Re: pagesave with mode=update does not work