removing blank columns from excel files
Posted: 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.
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.