save matrix into an existing file

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

superjocker
Posts: 27
Joined: Mon Mar 30, 2020 5:45 pm

save matrix into an existing file

Postby superjocker » Thu Jun 25, 2020 8:24 am

Hi, my question, is it possible to save a matrix into an existing excel file?, this would mean to update the file. I have a bunch of matrices that I want to save into the same excel file and the only code that I know is ".write(t=xls,b4)". I would like to save the matrices in different cells like ".write(t=xls,b4)", ".write(t=xls,b5)", ".write(t=xls,b6)".

Thanks

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13319
Joined: Tue Sep 16, 2008 5:38 pm

Re: save matrix into an existing file

Postby EViews Gareth » Thu Jun 25, 2020 10:21 am

Unfortunately not. Only series/groups can be written to existing Excel files.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: judejeh and 9 guests