2

Is there any way to prevent coercion of dates when reading data from Excel? I'm using either the readxl package or the tidyxl package. The tidyxl package is terrific, but it automatically moves the data into the date column.

Also, I was intrigued by this sentence from the Help page for the xlsx_cells() function: " xlsx_cells() attempts to infer the correct data type of each cell, returning its value in the appropriate column (error, logical, numeric, date, character). In case this cleverness is unhelpful, the unparsed value and type information is available in the 'content' and 'type' columns." It's this unparsed value that I'm looking for.

Alternatively, I'm looking for something similar to TextReader, except for XLSX files.

Any suggestions?

Phil
  • 7,287
  • 3
  • 36
  • 66
hackR
  • 1,459
  • 17
  • 26
  • This has just been fixed in tidyxl as of https://github.com/nacnudus/tidyxl/pull/80. Sorry that I didn't notice this post two years ago! – nacnudus Apr 08 '22 at 20:52

0 Answers0