[Gretl-users] Unable to import excel file

[Bulent Erdemir]

Hi,

Can't read date column into gretl. I've read the manual, formatted the
column as gretl would expect (file is attached). But when I want to read
the file I receive and error message saying "can't make sense of the extra
bit".
It seems, gretl sees the internal excel date value which is a number
representing the date value as the number of days since 1/1/1900 (A serial
number 1 represents 1/1/1900 internally in Excel).
Tried many variations with no luck.

Assuming this might be due to local regional settings (which were Turkish)
having different date formats, I switched to English (USA) settings and
tried, but did not work.

Any ideas ?

Thanks,
Bulent Erdemir

Hi,

Can't read date column into gretl. I've read the manual, formatted the column as gretl would expect (file is attached). But when I want to read the file I receive and error message saying "can't make sense of the extra bit". 

It seems, gretl sees the internal excel date value which is a number representing the date value as the number of days since 1/1/1900 (A serial number 1 represents 1/1/1900 internally in Excel). 

Tried many variations with no luck.

Assuming this might be due to local regional settings (which were Turkish) having different date formats, I switched to English (USA) settings and tried, but did not work. 

Any ideas ? 

Thanks,

Bulent Erdemir

02.KulceAltinSatis.xls
Description: MS-Excel spreadsheet