search for: skipemptyrow

Displaying 1 result from an estimated 1 matches for "skipemptyrow".

Did you mean: skipemptyrows
2020 Oct 23
1
openxlsx::read.xlsx can't read data without a header
...der. How can I add something like "header = FALSE" in the formula, so that the resulting data would be all the 6 rows? A similar problem occurs in readxl::read_xlsx. Thank you! > temp <- openxlsx::read.xlsx(fl_trilem_sgko, sheet="Korea", rows=5:10, cols=25, skipEmptyRows = FALSE, na.strings = "NA") > temp 0.12101775061124695 1 0.09613981 2 0.16259886 3 0.07914472 4 0.10195485 5 0.07700853 > nrow(temp) [1] 5 John [[alternative HTML version deleted]]