removing blank columns from excel files

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

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

terrya
Posts: 107
Joined: Wed Aug 26, 2009 2:37 pm

removing blank columns from excel files

Postby terrya » Thu Jul 10, 2014 4:20 pm

I want to download directly excel files from a website. For some reason, the files have blank columns between the variable columns (I assume that the authors believe that this makes it easier to read them). There's no problem with saving the files to disc, deleting the blank columns and reading the resulting file into Eviews. I just want sidestep this if I can.

Both wfopen and import pick out the first variable but none of the others. Is it possible to delete the blank columns?

Also: Can Eviews unzip a file? I haven't been able to identify a command to do this if, in fact, it can.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: removing blank columns from excel files

Postby EViews Gareth » Thu Jul 10, 2014 4:25 pm

Use the range statement to explicitly say which block of data you want from the Excel file.

No, there is no unzip

terrya
Posts: 107
Joined: Wed Aug 26, 2009 2:37 pm

Re: removing blank columns from excel files

Postby terrya » Thu Jul 10, 2014 6:11 pm

Thanks. Are there any thoughts about unzip for EViews?


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests