Skip to content

openxlsx::read.xlsx can't read data without a header

2 messages · John, Richard M. Heiberger

John
# 
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!
cols=25,                skipEmptyRows = FALSE, na.strings = "NA")
0.12101775061124695
1          0.09613981
2          0.16259886
3          0.07914472
4          0.10195485
5          0.07700853
[1] 5


John
Richard M. Heiberger
# 
?openxlsx::read.xlsx
The fourth argument by default is TRUE
colNames: If ?TRUE?, the first row of data will be used as column
          names.

You will need to specify it explicitly
as     colNames=FALSE
The other arguments will probably also be useful to you.
On Thu, Oct 22, 2020 at 11:56 PM John <miaojpm at gmail.com> wrote: