|
activeSheet() `activeSheet<-`()
|
Get/set active sheet of the workbook |
|
addCreator()
|
Add another author to the meta data of the file. |
|
addFilter()
|
Add column filters |
|
addStyle()
|
Add a style to a set of cells |
|
addWorksheet()
|
Add a worksheet to a workbook |
|
all.equal(<Workbook>)
|
Check equality of workbooks |
|
cloneWorksheet()
|
Clone a worksheet to a workbook |
|
conditionalFormat()
|
Add conditional formatting to cells |
|
conditionalFormatting()
|
Add conditional formatting to cells |
|
convertFromExcelRef()
|
Convert excel column name to integer index |
|
convertToDate()
|
Convert from excel date number to R Date type |
|
convertToDateTime()
|
Convert from excel time number to R POSIXct type. |
|
copyWorkbook()
|
Copy a Workbook object. |
|
createComment()
|
create a Comment object |
|
createNamedRegion()
|
Create a named region. |
|
createStyle()
|
Create a cell style |
|
createWorkbook()
|
Create a new Workbook object |
|
dataValidation()
|
Add data validation to cells |
|
deleteData()
|
Delete cell data |
|
freezePane()
|
Freeze a worksheet pane |
|
getBaseFont()
|
Return the workbook default font |
|
getCellRefs()
|
Return excel cell coordinates from (x,y) coordinates |
|
getCreators()
|
Add another author to the meta data of the file. |
|
getDateOrigin()
|
Get the date origin an xlsx file is using |
|
getNamedRegions()
|
Get named regions |
|
getSheetNames()
|
Get names of worksheets |
|
getStyles()
|
Returns a list of all styles in the workbook |
|
getTables()
|
List Excel tables in a workbook |
|
groupColumns()
|
Group columns |
|
groupRows()
|
Group Rows |
|
insertImage()
|
Insert an image into a worksheet |
|
insertPlot()
|
Insert the current plot into a worksheet |
|
int2col()
|
Convert integer to Excel column |
|
loadWorkbook()
|
Load an existing .xlsx file |
|
makeHyperlinkString()
|
create Excel hyperlink string |
|
mergeCells()
|
Merge cells within a worksheet |
|
modifyBaseFont()
|
Modify the default font |
|
names(<Workbook>) `names<-`(<Workbook>)
|
get or set worksheet names |
|
openXL()
|
Open a Microsoft Excel file (xls/xlsx) or an openxlsx Workbook |
|
openxlsx
|
xlsx reading, writing and editing. |
|
pageBreak()
|
add a page break to a worksheet |
|
pageSetup()
|
Set page margins, orientation and print scaling |
|
protectWorkbook()
|
Protect a workbook from modifications |
|
protectWorksheet()
|
Protect a worksheet from modifications |
|
read.xlsx()
|
Read from an Excel file or Workbook object |
|
readWorkbook()
|
Read from an Excel file or Workbook object |
|
removeCellMerge()
|
Create a new Workbook object |
|
removeColWidths()
|
Remove column widths from a worksheet |
|
removeComment()
|
Remove a comment from a cell |
|
removeFilter()
|
Remove a worksheet filter |
|
removeRowHeights()
|
Remove custom row heights from a worksheet |
|
removeTable()
|
Remove an Excel table in a workbook |
|
removeWorksheet()
|
Remove a worksheet from a workbook |
|
renameWorksheet()
|
Rename a worksheet |
|
replaceStyle()
|
Replace an existing cell style |
|
saveWorkbook()
|
save Workbook to file |
|
setColWidths()
|
Set worksheet column widths |
|
setFooter()
|
Set footer for all worksheets |
|
setHeader()
|
Set header for all worksheets |
|
setHeaderFooter()
|
Set document headers and footers |
|
setLastModifiedBy()
|
Add another author to the meta data of the file. |
|
setRowHeights()
|
Set worksheet row heights |
|
sheetVisibility() `sheetVisibility<-`()
|
Get/set worksheet visible state |
|
sheetVisible() `sheetVisible<-`()
|
Get worksheet visible state. |
|
sheets()
|
Returns names of worksheets. |
|
showGridLines()
|
Set worksheet gridlines to show or hide. |
|
ungroupColumns()
|
Ungroup Columns |
|
ungroupRows()
|
Ungroup Rows |
|
worksheetOrder() `worksheetOrder<-`()
|
Order of worksheets in xlsx file |
|
write.xlsx()
|
write data to an xlsx file |
|
writeComment()
|
write a cell comment |
|
writeData()
|
Write an object to a worksheet |
|
writeDataTable()
|
Write to a worksheet as an Excel table |
|
writeFormula()
|
Write a character vector as an Excel Formula |