EViews.com

Posted: **Tue Jul 03, 2012 10:18 am**

Hello,

I have a question regarding importing data from excel that I'm hoping someone can help me with.

When I'm writing a program and I have an excel file with data on multiple sheets that I need to import, what should it the code be?

For example, what options should I put to ensure that I get the all data from the below file with data on sheets 1 and 2?

Code: Select all


import P:\Eviews\Data\Price.xls

Posted: **Tue Jul 03, 2012 10:36 am**

You have to do it in two statements, one for each sheet. You cannot import multiple sheets at the same time. The import command lets you specify an Excel Range for what part of the Excel file you want to import. If my memory serves correctly, the Excel syntax for a sheet is simply sheetname!, so it would be something like:

Code: Select all


import P:\Eviews\Data\Price.xls range="sheet1!"
import P:\Eviews\Data\Price.xls range="sheet2!"

EViews.com

Importing Data from Excel

Importing Data from Excel

Re: Importing Data from Excel