Table.save to row+1
Posted: Fri Mar 24, 2023 3:02 am
When exporting av table to Excel using Table.Save, the table is exported to expected row + 1, rather than expected row.
Of course, as an workaround, I can just export to expected row-1. But the thing is I want to export to A1 specifically.
* Eviews 13 Enterprise edition - Mar 1 2023 build.
* MS Office Professional Plus 2016
Code: Select all
'Create test table
Create u 1 1
Table tab
tab(1,1) = "a"
tab(1,2) = "b"
tab(2,1) = 100
tab(2,2) = 100
'Save example file in same directory as prg-file
%Path = @Runpath
Cd {%Path}
'Export to Excel, starting at A1, A2 and A3
tab.save(t=xlsx, n="", mode=update, cellfmt=preserve, strlen=256) "tabsave.xlsx" RANGE=SaveA1!A1
tab.save(t=xlsx, n="", mode=update, cellfmt=preserve, strlen=256) "tabsave.xlsx" RANGE=SaveA2!A2
tab.save(t=xlsx, n="", mode=update, cellfmt=preserve, strlen=256) "tabsave.xlsx" RANGE=SaveA3!A3
'=======> Exports table, but table starts at expected row+1
* Eviews 13 Enterprise edition - Mar 1 2023 build.
* MS Office Professional Plus 2016