updating Excel file via export vector.export does not seem to work fully automatised
Posted: Thu Jan 19, 2023 1:41 am
Dear Eviews team,
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
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 12521 times
- menu2.png (9.17 KiB) Viewed 12521 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