loadWorkbook {XLConnect} | R Documentation |
Loads or creates a Microsoft Excel workbook
for further manipulation.
loadWorkbook(filename, create = FALSE)
filename |
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 |
create |
Specifies if the file should be created if it does not already exist (default is |
Returns a 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 workbook
instances.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
Wikipedia: Office Open XML
http://en.wikipedia.org/wiki/Office_Open_XML
# 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!