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 http://www.mirai-solutions.com
Wikipedia: Office Open XML
1 2 3 4 5 6 7 8 9 10
# 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!
Loading required package: XLConnectJars OpenJDK 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed XLConnect 0.2-12 by Mirai Solutions GmbH [aut], Martin Studer [cre], The Apache Software Foundation [ctb, cph] (Apache POI, Apache Commons Codec), Stephen Colebourne [ctb, cph] (Joda-Time Java library), Graph Builder [ctb, cph] (Curvesapi Java library) http://www.mirai-solutions.com , http://miraisolutions.wordpress.com ZoneInfo: /usr/share/javazi/ZoneInfoMappings (Permission denied) Warning message: system call failed: Cannot allocate memory
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.