CODEWITHSUNDEEP
ropenxls
MLEN
MLEN

Reputation: 2561

openxlsx: Where is the data located in the workbook object

library(openxlsx)

wb <- createWorkbook()
addWorksheet(wb, "iris")
writeData(wb, "iris", iris)

Where can I find the data/tab data for iris in wb?

EDIT:

I would like to see the data in a R session and export it back as a R object to see what it contains. Reason is, I have a function (that I cant change) that returns a workbook object with data and I would like to explore the data in R additionally before saving it.

Upvotes: 3

Views: 662

Answers (2)

Mikko
Mikko

Reputation: 7755

The readWorkbook() function reads Workbook objects as data frames.

openxlsx::readWorkbook(wb)

#     Sepal.Length Sepal.Width Petal.Length Petal.Width    Species
# 1            5.1         3.5          1.4         0.2     setosa
# 2            4.9         3.0          1.4         0.2     setosa

Upvotes: 3

Joe Christian
Joe Christian

Reputation: 11

I'm not sure I understand your question. but have you tried openxlsx::openXL(wb) ?

Upvotes: 0

Related Questions