Hi,
I'm using the "Get Data" function to export data out of EViews into an Excel sheet. The data comes out with the dates and series in columns (ie. A1:B100), but I would like for the data to be imported into Excel transposed (ie. A1:AV2). Is there a way to do this directly rather than transposing the data in the sheet?
thx
Excel Add-in "Get Data" Function
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Steve
- EViews Developer
- Posts: 844
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Excel Add-in "Get Data" Function
It's not controlled by our addin.
Our addin is actually just a wrapper to our OLEDB provider which provides data to Excel. The actual import and placement of the data is controlled by Excel so you should look in their support documents to see if there's any way to import OLEDB data as transposed.
Steve
Sent from my iPhone using Tapatalk
Our addin is actually just a wrapper to our OLEDB provider which provides data to Excel. The actual import and placement of the data is controlled by Excel so you should look in their support documents to see if there's any way to import OLEDB data as transposed.
Steve
Sent from my iPhone using Tapatalk
Who is online
Users browsing this forum: No registered users and 2 guests