EViews.com

Hi,

We would like to export only the values of series into an existing Excel worksheet while preserving the existing data. The new EViews 8 pagesave function with the 'mode=update' option comes close to doing so, although I can't find a way for the names of the series not to be included as a header to the values. Is there a way to achieve this? Something as the 'nonames' option of the write command?

Best regards,

Étienne

Try something like

Thanks Glenn, it works. As a test, to export only the values (no dates, no headers) of a series named x into an existing spreadsheet, beginning at cell C3 of Sheet2, I used the following command:
To write the same values in a row, I used:
The order of the filename and the range specification is different than the one in the example given in the command reference, though it corresponds to the order the syntax section suggests (pagesave(type=excelxml, mode=update, noid) C:\Local\Book1.xlsx nonames range="Sheet2!C3" @keep x).

Please note that if I specify mode=create (and a non-existent file name), it does write starting at cell C3, but on the first sheet, Sheet1.

Best regards,

Étienne