I use Eviews 13 Oct 2022 build
The export command for vectors does not seem to work in a fully automatised way.
The code below generates the menu window "Export Matrix Data". Clicking on "Advanced Excel Options" shows default paramter settings not corresponding to the options and parameters "cellmft", "mode" and "range" provided in the call of the execute procedure .
Best, mamo
- menue1.png (13.33 KiB) Viewed 4159 times
- menu2.png (9.17 KiB) Viewed 4159 times
'Assumption Excel file book1.xlsx with a sheet named "Sheet1" exists in the working directory
vector(5) x
x.fill 1, 2, 3, 4, 5
x.export(t=xlsx, cellfmt=preserve, mode=update) book1 range=Sheet1!G2