cgrand
Wrong datetime conversion from xls
Hi,
i'm reading a .xlsx file that has some date cells (excel format is "date") but i had a wrong conversion.
If my A1 cell is 01-01-2000 (1st January 2000) the result of (get (spreadmap filename) "A1") is #inst "1995-12-30T23:00:00.000-00:00" , 1 hour, 1day and 4 year before the correct date.
I tried to read from an old .xls file or change date format (e.g. dd/mm/yyyy hh:mm) but the result is the same.
I can upload an example file if needed, but i think is very simply to reproduce.
PS: i'm using the last spreadmap, the 0.1.4
Excel and it's two epochs... Are you using Office for Mac?
On Tue, Aug 19, 2014 at 6:20 PM, paologf [email protected] wrote:
Hi, i'm reading a .xlsx file that has some date cells (excel format is "date") but i had a wrong conversion. If my A1 cell is 01-01-2000 (1st January 2000) the result of (get (spreadmap filename) "A1") is #inst "1995-12-30T23:00:00.000-00:00" , 1 hour, 1day and 4 year before the correct date. I tried to read from an old .xls file or change date format (e.g. dd/mm/yyyy hh:mm) but the result is the same.
I can upload an example file if needed, but i think is very simply to reproduce.
PS: i'm using the last spreadmap, the 0.1.4
— Reply to this email directly or view it on GitHub https://github.com/cgrand/spreadmap/issues/5.
On Clojure http://clj-me.cgrand.net/ Clojure Programming http://clojurebook.com Training, Consulting & Contracting http://lambdanext.eu/
Yes, i'm using office for mac. I created a new document with open office and i had only 1 hour gap (is it normal?).
The open office issue also explains why you were off by 4 years, 1 day and 1 hour. I'm going to fix it asap.
On Wed, Aug 20, 2014 at 9:21 AM, paologf [email protected] wrote:
Yes, i'm using office for mac. I created a new document with open office and i had only 1 hour gap (is it normal?).
— Reply to this email directly or view it on GitHub https://github.com/cgrand/spreadmap/issues/5#issuecomment-52742075.
On Clojure http://clj-me.cgrand.net/ Clojure Programming http://clojurebook.com Training, Consulting & Contracting http://lambdanext.eu/
Could you provide me with an excel-created spreadsheet? (I don't have Office for Mac) Also: do you use spreadmap on a different computer than the one used to create the spreadsheet (I'm still fuzzy about the root cause of the 1 hour difference, a timezone problem but where...).
Thanks
On Wed, Aug 20, 2014 at 9:30 AM, paologf [email protected] wrote:
Ok, thanks.
— Reply to this email directly or view it on GitHub https://github.com/cgrand/spreadmap/issues/5#issuecomment-52742779.
On Clojure http://clj-me.cgrand.net/ Clojure Programming http://clojurebook.com Training, Consulting & Contracting http://lambdanext.eu/
The foo.xlsx file https://dl.dropboxusercontent.com/u/23365785/foo.xlsx done with office for mac, cell "A1" with 01/01/2000 00:00. From mac i had the "1 hour" issue reading file done with open office or microsoft office (windows). From linux i had the "1hour, 1day and 4 year" issue reading office for mac file.
Let me know if you need something more, thanks.
Paolo