XLConnect-package: Excel Connector for R

Description Details Author(s) References Examples

Description

Provides comprehensive functionality to read, write and format Excel data.

Details

Package: XLConnect
Type: Package
Version: 0.2-15
Date: 2018-04-05
URL: http://www.mirai-solutions.com
https://github.com/miraisolutions/xlconnect
BugReports: https://github.com/miraisolutions/xlconnect/issues
SystemRequirements: Java (>= 6)
Depends: R (>= 2.10.0), XLConnectJars (== 0.2-15)
Imports: methods, rJava
Suggests: RUnit, lattice, ggplot2 (>= 0.9.3), zoo
License: GPL-3
Copyright: See file COPYRIGHTS
LazyData: yes

For an overview over the package please refer to the available demos:
demo(package = "XLConnect")

Author(s)

Mirai Solutions GmbH, [email protected]

References

Mirai Solutions GmbH: http://www.mirai-solutions.com
XLConnect on GitHub: https://github.com/miraisolutions/xlconnect Mirai Solutions on GitHub: https://github.com/miraisolutions
Apache POI: http://poi.apache.org

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
# Load workbook; create if not existing
wb <- loadWorkbook("XLConnect.xlsx", create = TRUE)

# Create a worksheet
createSheet(wb, name = "mtcars")

# Create a name reference
createName(wb, name = "mtcars", formula = "mtcars!$C$5")

# Write built-in data.frame 'mtcars' to the specified named region
writeNamedRegion(wb, mtcars, name = "mtcars")

# Save workbook
saveWorkbook(wb)

Example output

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 

XLConnect documentation built on April 6, 2018, 1:03 a.m.