Selecting cell values with XLSX package

Hi samarvir,
Your attachment didn't make it through the list filter. From your
example, you seem to want something like this:

# assume you are using the readxl package to read the data in
mydf<-read_excel("mydata.xlsx",col_types=rep("character",11))
mydatavector<-as.vector(as.matrix(mydf))

This is probably not what you need, as each spreadsheet file will be
turned into a long vector of character (string) values. What you
probably should think of is reading in the spreadsheets:

mydf1<-read_excel("mydata1.xlsx")
mydf2...

and merging the resulting data frames. With that many data files, you
will probably have to do this in stages.

Jim

Selecting cell values with XLSX package

Thread (2 messages)