Hi, I try to read 6 rows (from 5th to 10th) from Excel, but I can always get 5. The first row of the 6 becomes the header. 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]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.