xlsx: Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files

Excelファイルの読み書き

> library(xlsx)
Loading required package: rJava

Attaching package: 'rJava'
The following object is masked from 'package:git2r':

    clone
Loading required package: xlsxjars
Error: package or namespace load failed for 'xlsx'

バージョン: 0.5.7


関数名 概略
+.CellStyle CellStyle construction.
Alignment Create an Alignment object.
Border Create an Border object.
Cell Functions to manipulate cells.
CellBlock Create and style a block of cells.
CellProtection Create a CellProtection object.
CellStyle Functions to manipulate cells.
Comment Functions to manipulate cell comments.
DataFormat Create an DataFormat object.
Fill Create an Fill object.
Font Create a Font object.
NamedRanges Functions to manipulate named ranges.
OtherEffects Functions to do various spreadsheets effects.
POI_constants Constants used in the project.
Picture Functions to manipulate images in a spreadsheet.
PrintSetup Function to manipulate print setup.
Row Functions to manipulate rows of a worksheet.
Sheet Functions to manipulate worksheets.
Workbook Functions to manipulate Excel 2007 workbooks.
addDataFrame Add a 'data.frame' to a sheet.
addHyperlink Add a hyperlink to a cell.
read.xlsx Read the contents of a worksheet into an R data.frame
readColumns Read a contiguous set of columns from sheet into an R data.frame
readRows Read a contiguous set of rows into an R matrix
write.xlsx Write a data.frame to an Excel workbook.
xlsx-package Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files

read.xlsx / read.xlsx2

Excelシートの読み込み

> path <- system.file("tests", "test_import.xlsx", package = "xlsx")
> 
> df_xls <- read.xlsx(file       = path,
+                     sheetIndex = 1)
Error in eval(expr, envir, enclos): could not find function "read.xlsx"
> df_xls %>% {
+   print(class(.))
+   dplyr::tbl_df(.)
+ }
Error in eval(expr, envir, enclos): object 'df_xls' not found