Eviews 7 cannot read Excel 2007 data?

[jgutman]

When i try to have eviews read data in excel 2007, i am getting no error message but the series comes back (mostly) empty and with the name "pk"
If i save the same excel spreadsheet as excel 97-2003, eviews reads the data fine
This is an "upgrade" that i made to excel 2007 that has cause me no end of grief
Can eviews 7 read data from excel 2007? or do i need to save all of my worksheets as excel 97-2003?
Thanks

[EViews Gareth]

EViews 7 can read Excel data using the Open or Import methods (not the Read method).

If you think there is something going wrong, could you post the relevant Excel 2007 file?

[jgutman]

Ok, I understand. Here is how i operate (I have been using EViews for a decade, so you may find that i am a bit "old skool" -- let me know if there is a better way to operate):
- i build data matrices in excel
- i use excel for data visualization and manipulation
- when i am read to use eviews, i wrote a program using "read" to pull in specific columns of data from excel
- the data will be found in different sheets, different tabs, and different locations -- it isnt contiguous

What is not clear in the "import" command is if i can specify a specific row/column to anchor the import -- e.g.

read(b4, s=Data_Dailyt) "L:\Temp.xls" 1

what would be the "import" analogue to the above?

Thanks

[EViews Gareth]

Try:

Code: Select all

import "L:\temp.xls" range="Data_Dailyt!b4:C100"

(Note this will read data from B4 to C100 - you might want to change the ending point to something else).