Workbook {xlsx} | R Documentation |
Functions to manipulate Excel 2007 workbooks.
createWorkbook(type="xlsx") loadWorkbook(file, password=NULL) saveWorkbook(wb, file, password=NULL)
type |
a String, either |
file |
the path to the file you intend to read or write. Can be an xls or xlsx format. |
wb |
a workbook object as returned by |
password |
a String with the password. |
createWorkbook
creates an empty workbook object.
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.
createWorkbook
returns a java object reference pointing to an
empty workbook object.
loadWorkbook
creates a java object reference corresponding to
the file to load.
Adrian Dragulescu
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
.
wb <- createWorkbook() # see all the available java methods that you can call #.jmethods(wb) # for example wb$getNumberOfSheets() # no sheet yet! # loadWorkbook("C:/Temp/myFile.xls")