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
Copying matrix to excel
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
Copying matrix to excel
Last edited by alvarezcc on Tue Apr 24, 2018 9:12 am, edited 1 time in total.
-
- EViews Developer
- Posts: 798
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Copying matrix to excel
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.
Select your workfile.
Next to Types, select "Vector/Matrix".
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
In the Excel menu, click the Add-Ins tab.
In the ribbon, look for the EViews group and click the Get Data button.
Select your workfile.
Next to Types, select "Vector/Matrix".
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
Re: Copying matrix to excel
Thank you very much Steve. I think that can work for me.
Regards
Regards
Who is online
Users browsing this forum: No registered users and 21 guests