Gareth,
Are you able to provide any further detail about what exactly was incorrect about the format of the Excel file?
It would be nice to be able to let the organisation whose file it is know the details.
Cheers
Nairn
Search found 3 matches
- Tue Jun 06, 2017 8:26 pm
- Forum: Data Manipulation
- Topic: Importing Excel spreadsheet from the Web
- Replies: 4
- Views: 10386
- Mon Jun 05, 2017 8:51 pm
- Forum: Data Manipulation
- Topic: Importing Excel spreadsheet from the Web
- Replies: 4
- Views: 10386
Importing Excel spreadsheet from the Web
I have a program that is trying to import a spreadsheet from a webpage, but I am getting an error (screenshot of the error dialog attached) saying: File 'C:\Users\MACGIB~1\AppData\ev_temp\hc5.xls' does not match expected format in "IMPORT HTTP://WWW.RBNZ.GOVT.NZ/-/MEDIA/RESERVEBANK/FILES/STATIS...
- Mon May 22, 2017 10:53 pm
- Forum: Data Manipulation
- Topic: Importing csv file - series coming trough as alphas
- Replies: 1
- Views: 2352
Importing csv file - series coming trough as alphas
I am using Eviews 9.5 (32-bit version on an Enterprise licence) I am importing a csv file (attached) of time series numeric data which contains occasional missing values as ".." The simple import code I am using is: import M:\ExportDirect.csv colhead=1 @freq Q 1986q1 Four (4) of the 152 se...