- I recently discovered a big problem when trying to read some data into R from an .xlsx file. The dates looked right when I opened the Excel file, but when I read them into R they magically shifted by several years.
- Cue Hadley Wickham to the rescue:
- ...and then my head exploded.
- — Ben Bond-Lamberty (@BenBondLamberty)Mon, Apr 07 2014 19:18:31
- (Stronger gifs were needed.)
- — Barry Rowlingson (@geospacedman)Mon, Apr 07 2014 19:49:06
- — Kara Woo (@kara_woo)Mon, Apr 07 2014 20:02:57"Dates in Excel: In reality, there are no such things. What you have are floating point numbers & pious hope." LOLSOB http://www.lexicon.net/sjmachin/xlrd.html …
- — Noam Ross (@noamross)Mon, Apr 07 2014 20:04:46
- — Kevin Ringelman (@KevinRingelman)Mon, Apr 07 2014 20:07:17
- — Dave Harris (@davidjayharris)Mon, Apr 07 2014 20:19:05
- So yeah, all of my biases against Excel are now officially justified. It is the WORST.
Excel Date System Fiasco
byKara Woo1 Like1,114 Views