Last chance! 50% off unlimited learning
Sale ends in
createWorkbook()loadWorkbook(file)
saveWorkbook(wb, file)
createWorkbook or
loadWorkbook.createWorkbook returns a java object reference pointing to an
empty workbook object.
loadWorkbook creates a java object reference corresponding to
the file to load.createWorkbook creates an empty workbook object. loadWorkbook loads a workbook from a file.
saveWorkbook saves an existing workook to an Excel 2007 file.
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!Run the code above in your browser using DataLab