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.
removing blank columns from excel files
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
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
Use the range statement to explicitly say which block of data you want from the Excel file.
No, there is no unzip
No, there is no unzip
Re: removing blank columns from excel files
Thanks. Are there any thoughts about unzip for EViews?
Who is online
Users browsing this forum: No registered users and 2 guests
