Open raffaem opened 3 weeks ago
readxl::read_excel guesses column types based on the value of the first guess_max (an argument of the function) of its cells (reference)
readxl::read_excel
guess_max
This causes problems in importing when a numeric cell way down in my Excel file is silently converted into a boolean, without any warning of any sort.
This problem doesn't happen with openxlsx.
Can you specify in the documentation how openxlsx guesses column types?
My understanding is that Excel only provides cell types, not column types.
readxl::read_excel
guesses column types based on the value of the firstguess_max
(an argument of the function) of its cells (reference)This causes problems in importing when a numeric cell way down in my Excel file is silently converted into a boolean, without any warning of any sort.
This problem doesn't happen with openxlsx.
Can you specify in the documentation how openxlsx guesses column types?
My understanding is that Excel only provides cell types, not column types.