Importing table from Excel

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Importing table from Excel

Postby tvonbrasch » Sat Mar 17, 2018 12:30 am

Hi

I want information in an excel file to be available in EViews for example as a txt object or as an EViews table. If you look at the picture below, how can this information best be made available from within EViews? Using commands, how can this best be imported?

Thomas
Attachments
table.PNG
table.PNG (238.53 KiB) Viewed 3064 times

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Importing table from Excel

Postby EViews Steve » Sat Mar 17, 2018 4:59 am

Try our IMPORTTBL command. It'll basically allow you to import an Excel, HTML, or Text file into an EViews Table object. You will lose any source formatting such as column width/font/colors/links/etc. EViews will simply keep the text.

With your workfile open, go to our File menu/Import/Table from file..., then select your Excel file. You'll be then be led thru an import wizard to select the data. Make sure you mark each column as character data so EViews doesn't try to convert anything to a number.

Once imported, check your Capture Command window for the generated command.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 21 guests