get_worksheet_entries: Get entries from workbook worksheet

In openxlsx: Read, Write and Edit xlsx Files

Get entries from workbook worksheet

Description

Get all entries from workbook worksheet without xml tags

Usage

get_worksheet_entries(wb, sheet)

Arguments

wb	workbook
sheet	worksheet

Value

vector of strings

Author(s)

David Breuer

Examples

## 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)

openxlsx documentation built on Sept. 20, 2024, 5:08 p.m.