importing dates with slashes into string
in
Contributed Library Questions
•
2 years ago
i'm using excel sheets that have dates in the following format: dd/mm/yyyy
i'm using the XLS library to bring that data into processing just to display them as text. i've been using the getString() function, but it gives me a float. for example, what appears in excel as 4/1/11 is stored in a string as 39172.0
what gives? what must I do to have processing just take the data, in whatever datatype, and just display 4/1/11 as it is stored in the excel document? i've tried using getFloat and getInt as well, but it would just return the same number.
i'm using the XLS library to bring that data into processing just to display them as text. i've been using the getString() function, but it gives me a float. for example, what appears in excel as 4/1/11 is stored in a string as 39172.0
what gives? what must I do to have processing just take the data, in whatever datatype, and just display 4/1/11 as it is stored in the excel document? i've tried using getFloat and getInt as well, but it would just return the same number.
1
