Writing strings using pagesave

[leah]

Hi there. I'm trying to use pagesave to transfer a mix of strings and series to excel, but the strings are giving me some trouble.

It seems that if I try to save either more than one string or if the string isn't in the first position after the @keep statement, it won't save. So this runs:

pagesave(type=excelxml) "U:\Templates.xlsx" range="Raw" @smpl 2000 2002 @keep "hello" gdp

But these don't:

pagesave(type=excelxml) "U:\Templates.xlsx" range="Raw" @smpl 2000 2002 @keep gdp "hello"
pagesave(type=excelxml) "U:\Templates.xlsx" range="Raw" @smpl 2000 2002 @keep "hello" "there"

Is there any way to get around this? Thanks.

[EViews Steve]

Hi leah, sorry for the late reply...

I believe @keep doesn't currently support quoted strings. And even if it did, it doesn't allow you to insert hard-coded string values straight into the column. Each name specified in the @keep list has to resolve to an actual object name in your workfile.

If I understand you correctly, you are trying to save the page with a mixture of series objects and actual hard-coded strings (such as "hello") in the output file? The only way I know how to do this is to create a new alpha object named "hello" and place your hard coded string into each row, then include this named alpha object in your @keep.

Steve