Workbook

0th

Percentile

Functions to manipulate Excel 2007 workbooks.

createWorkbook creates an empty workbook object.

Usage
createWorkbook(type = "xlsx")

loadWorkbook(file, password = NULL)

saveWorkbook(wb, file, password = NULL)

Arguments
type

a String, either xlsx for Excel 2007 OOXML format, or xls for Excel 95 binary format.

file

the path to the file you intend to read or write. Can be an xls or xlsx format.

password

a String with the password.

wb

a workbook object as returned by createWorkbook or loadWorkbook.

Details

loadWorkbook loads a workbook from a file.

saveWorkbook saves an existing workook to an Excel 2007 file.

Reading or writing of password protected workbooks is supported for Excel 2007 OOXML format only. Note that in Linux, LibreOffice is not able to read password protected spreadsheets.

Value

createWorkbook returns a java object reference pointing to an empty workbook object.

loadWorkbook creates a java object reference corresponding to the file to load.

See Also

write.xlsx for writing a data.frame to an xlsx file. read.xlsx for reading the content of a xlsx worksheet into a data.frame. To extract worksheets and manipulate them, see Worksheet.

Aliases
  • Workbook
  • createWorkbook
  • loadWorkbook
  • saveWorkbook
Examples
# NOT RUN {

wb <- createWorkbook()

# see all the available java methods that you can call
rJava::.jmethods(wb)

# for example
wb$getNumberOfSheets()   # no sheet yet!

# loadWorkbook("C:/Temp/myFile.xls")

# }
Documentation reproduced from package xlsx, version 0.6.3, License: GPL-3

Community examples

Looks like there are no examples yet.