Learn R Programming

openxlsx (version 4.2.7)

get_worksheet_entries: Get entries from workbook worksheet

Description

Get all entries from workbook worksheet without xml tags

Usage

get_worksheet_entries(wb, sheet)

Value

vector of strings

Arguments

wb

workbook

sheet

worksheet

Author

David Breuer

Examples

Run this code
## Create new workbook
wb <- createWorkbook()
addWorksheet(wb, "Sheet")
sheet <- 1

## Write dummy data
writeData(wb, sheet, c("A", "BB", "CCC"), startCol = 2, startRow = 3)
writeData(wb, sheet, c(4, 5), startCol = 4, startRow = 3)

## Get text entries
get_worksheet_entries(wb, sheet)

Run the code above in your browser using DataLab