Page 1 of 1

Excel Add-in "Get Data" Function

Posted: Fri Jul 15, 2016 7:31 am
by kszynkar
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

Re: Excel Add-in "Get Data" Function

Posted: Fri Jul 15, 2016 12:38 pm
by EViews Steve
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