Message-ID: <CABcx46CWTOcZbrLQOr+f0WCJ5L5xO+MXf8CfRU_7w7onJuLkkg@mail.gmail.com>
Date: 2020-10-23T04:04:39Z
From: John
Subject: openxlsx::read.xlsx can't read data without a header
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]]