Table.save to row+1

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

PetterHallberg
Posts: 1
Joined: Thu Mar 23, 2023 4:42 am

Table.save to row+1

Postby PetterHallberg » 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.

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


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

Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 6 guests