Copying matrix to excel

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

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

alvarezcc
Posts: 9
Joined: Thu Apr 23, 2009 8:33 pm

Copying matrix to excel

Postby alvarezcc » Mon Apr 23, 2018 3:52 pm

Hello everybody. I'm looking to copy a series of matrix objects into specific cells in a single excel spreadsheet so I don't have to copy and paste each matrix every time my data changes, which can be very time consuming. I' don't want to create a different spredsheet every time I copy a matrix. I want all the matrices in a single sheet. Does anyone knows how to do this?

Thanks
Last edited by alvarezcc on Tue Apr 24, 2018 9:12 am, edited 1 time in total.

EViews Steve
EViews Developer
Posts: 520
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Copying matrix to excel

Postby EViews Steve » Tue Apr 24, 2018 8:06 am

Use our Excel Add-In to import and link your matrices into a specific cell range.


In the Excel menu, click the Add-Ins tab.
In the ribbon, look for the EViews group and click the Get Data button.
example3.png
example3.png (19.42 KiB) Viewed 206 times

Select your workfile.

Next to Types, select "Vector/Matrix".
example4.png
example4.png (12.18 KiB) Viewed 206 times

Select one of your matrices from the list.
Click the Import & Link button.
Select the cell range in your spreadsheet to place the matrix.

Repeat this process for your other matrices.

This process simply creates an Excel OLEDB data connection in your spreadsheet. You can manage this connection by clicking the Manage button in our add-in, or you can go to the Data tab and click "Connections" to view the spreadsheet's data connections.

Now the next time your matrix data changes, simply save the workfile, then open the Excel spreadsheet, click on the Data tab, then click the "Refresh All" button to refresh all the values.

Steve

alvarezcc
Posts: 9
Joined: Thu Apr 23, 2009 8:33 pm

Re: Copying matrix to excel

Postby alvarezcc » Tue Apr 24, 2018 8:59 am

Thank you very much Steve. I think that can work for me.

Regards


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests