openxlsx v4.1.0
Monthly downloads
Read, Write and Edit XLSX Files
Simplifies the creation of Excel .xlsx files by providing a high
level interface to writing, styling and editing worksheets. Through the use of
'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages
with the added benefit of removing the dependency on Java.
Readme
openxlsx
This R package simplifies the
creation of .xlsx
files by providing
a high level interface to writing, styling and editing
worksheets. Through the use of
Rcpp
,
read/write times are comparable to the
xlsx
and
XLConnect
packages with the added benefit of removing the dependency on
Java.
Installation
Stable version
Current stable version is available on CRAN via
install.packages("openxlsx", dependencies = TRUE)
Development version
install.packages(c("Rcpp", "devtools"), dependencies = TRUE)
require(devtools)
install_github("awalker89/openxlsx")
Bug/feature request
Please let me know which version of openxlsx you are using when posting bug reports.
packageVersion("openxlsx")
Thanks, here.
News
Here.
Authors and Contributors
A list is automagically maintained here.
Functions in openxlsx
Name | Description | |
getBaseFont | Return the workbook default font | |
makeHyperlinkString | create Excel hyperlink string | |
removeCellMerge | Create a new Workbook object | |
int2col | Convert integer to Excel column | |
getSheetNames | Get names of worksheets | |
removeColWidths | Remove column widths from a worksheet | |
removeWorksheet | Remove a worksheet from a workbook | |
getNamedRegions | Get named regions | |
removeComment | Remove a comment from a cell | |
renameWorksheet | Rename a worksheet | |
setHeader | Set header for all worksheets | |
setRowHeights | Set worksheet row heights | |
pageBreak | add a page break to a worksheet | |
removeFilter | Remove a worksheet filter | |
pageSetup | Set page margins, orientation and print scaling | |
setFooter | Set footer for all worksheets | |
setColWidths | Set worksheet column widths | |
mergeCells | Merge cells within a worksheet | |
loadWorkbook | Load an existing .xlsx file | |
read.xlsx | Read from an Excel file or Workbook object | |
sheetVisibility | Get/set worksheet visible state | |
writeFormula | Write a character vector as an Excel Formula | |
getStyles | Returns a list of all styles in the workbook | |
setHeaderFooter | Set document headers and footers | |
names | get or set worksheet names | |
modifyBaseFont | Modify the default font | |
getTables | List Excel tables in a workbook | |
write.xlsx | write data to an xlsx file | |
getDateOrigin | Get the date origin an xlsx file is using | |
readWorkbook | Read from an Excel file or Workbook object | |
insertPlot | Insert the current plot into a worksheet | |
insertImage | Insert an image into a worksheet | |
openXL | Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook | |
openxlsx | xlsx reading, writing and editing. | |
writeComment | write a cell comment | |
removeRowHeights | Remove custom row heights from a worksheet | |
saveWorkbook | save Workbook to file | |
replaceStyle | Replace an existing cell style | |
removeTable | Remove an Excel table in a workbook | |
sheetVisible | Get worksheet visible state. | |
showGridLines | Set worksheet gridlines to show or hide. | |
worksheetOrder | Order of worksheets in xlsx file | |
sheets | Returns names of worksheets. | |
writeData | Write an object to a worksheet | |
writeDataTable | Write to a worksheet as an Excel table | |
addFilter | Add column filters | |
addStyle | Add a style to a set of cells | |
addWorksheet | Add a worksheet to a workbook | |
all.equal | Check equality of workbooks | |
conditionalFormat | Add conditional formatting to cells | |
getCellRefs | Return excel cell coordinates from (x,y) coordinates | |
freezePane | Freeze a worksheet pane | |
conditionalFormatting | Add conditional formatting to cells | |
convertToDate | Convert from excel date number to R Date type | |
convertFromExcelRef | Convert excel column name to integer index | |
createStyle | Create a cell style | |
createWorkbook | Create a new Workbook object | |
convertToDateTime | Convert from excel time number to R POSIXct type. | |
copyWorkbook | Copy a Workbook object. | |
dataValidation | Add data validation to cells | |
deleteData | Delete cell data | |
createComment | create a Comment object | |
createNamedRegion | Create a named region. | |
No Results! |
Vignettes of openxlsx
Name | ||
Introduction.Rnw | ||
formatting.Rnw | ||
tableStyles.PNG | ||
No Results! |
Last month downloads
Details
Type | Package |
Date | 2018-05-26 |
URL | https://github.com/awalker89/openxlsx |
BugReports | https://github.com/awalker89/openxlsx/issues |
License | MIT + file LICENSE |
LinkingTo | Rcpp |
Encoding | UTF-8 |
VignetteBuilder | knitr |
RoxygenNote | 6.0.1.9000 |
Collate | 'CommentClass.R' 'HyperlinkClass.R' 'RcppExports.R' 'class_definitions.R' 'StyleClass.R' 'WorkbookClass.R' 'baseXML.R' 'borderFunctions.R' 'chartsheet_class.R' 'conditional_formatting.R' 'helperFunctions.R' 'loadWorkbook.R' 'onUnload.R' 'openXL.R' 'openxlsx.R' 'openxlsxCoerce.R' 'readWorkbook.R' 'sheet_data_class.R' 'workbook_column_widths.R' 'workbook_read_workbook.R' 'workbook_write_data.R' 'worksheet_class.R' 'wrappers.R' 'writeData.R' 'writeDataTable.R' 'writexlsx.R' |
NeedsCompilation | yes |
Packaged | 2018-05-26 13:55:02 UTC; Alex |
Repository | CRAN |
Date/Publication | 2018-05-26 15:20:49 UTC |
imports | grDevices , methods , Rcpp , stats , utils , zip |
suggests | knitr , testthat |
depends | R (>= 3.3.0) |
Contributors | Luca Braglia |
Include our badge in your README
[](http://www.rdocumentation.org/packages/openxlsx)