Loads or creates a Microsoft Excel
workbook for further manipulation.
Filename (absolute or relative) of Excel workbook to be loaded. Supported are Excel '97 (*.xls) and
OOXML (Excel 2007+, *.xlsx) file formats. Paths are expanded using
Specifies if the file should be created if it does not already exist (default is
Password to use when opening password protected files. The default
workbook object for further manipulation.
loadWorkbook is basically just a shortcut form of
new("workbook", filename, create) with some additional error checking. As such
it is the preferred way of creating
Mirai Solutions GmbH https://mirai-solutions.ch
Wikipedia: Office Open XML
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
## Not run: # Load existing demo Excel file 'mtcars.xlsx' from the XLConnect package wb.mtcars <- loadWorkbook(system.file("demoFiles/mtcars.xlsx", package = "XLConnect")) # Create new workbook wb.new <- loadWorkbook("myNewExcelFile.xlsx", create = TRUE) # NOTE: The above statement does not write the file to disk! # saveWorkbook(wb.new) would need to be called in order to write/save # the file to disk! # clean up file.remove("myNewExcelFile.xlsx") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.