| Workbook {xlsx} | R Documentation |
Functions to manipulate Excel 2007 workbooks.
createWorkbook(type="xlsx") loadWorkbook(file) saveWorkbook(wb, file)
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 |
createWorkbook creates an empty workbook object.
loadWorkbook loads a workbook from a file.
saveWorkbook saves an existing workook to an Excel 2007 file.
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")