Description Usage Arguments See Also Examples
Return a vector of named regions in a xlsx file or Workbook object
1 |
x |
An xlsx file or Workbook object |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | ## create named regions
wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
## specify region
writeData(wb, sheet = 1, x = iris, startCol = 1, startRow = 1)
createNamedRegion(wb = wb,
sheet = 1,
name = "iris",
rows = 1:(nrow(iris)+1),
cols = 1:ncol(iris))
## using writeData 'name' argument to create a named region
writeData(wb, sheet = 1, x = iris, name = "iris2", startCol = 10)
out_file <- tempfile(fileext = ".xlsx")
saveWorkbook(wb, out_file, overwrite = TRUE)
## see named regions
getNamedRegions(wb) ## From Workbook object
getNamedRegions(out_file) ## From xlsx file
## read named regions
df <- read.xlsx(wb, namedRegion = "iris")
head(df)
df <- read.xlsx(out_file, namedRegion = "iris2")
head(df)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.