Main |
|
---|---|
Read from an Excel file or Workbook object |
|
write data to an xlsx file |
|
R6 class for a Workbook |
|
wb functions |
|
Create a new Workbook object |
|
Load an existing .xlsx file |
|
Save Workbook to file |
|
Create Dataframe from Workbook |
|
Read from an Excel file or Workbook object |
|
wb add and remove functions |
|
|
Create, write and remove comments |
Create / delete a named region |
|
add border for cell region |
|
add cell style for cell region |
|
add a chart xml to a workbook |
|
Add a chartsheet to a workbook |
|
Add conditional formatting to cells |
|
Add data to a worksheet as an Excel table |
|
Add data validation to cells |
|
add drawings to workbook |
|
add fill for cell region |
|
Add column filters |
|
add font for cell region |
|
Add form control Checkbox, Radiobuttons or Dropmenu |
|
Add a character vector as an Excel Formula |
|
Insert an image into a worksheet |
|
Add mschart object to an existing workbook |
|
add numfmt for cell region |
|
Add a page break to a worksheet |
|
Add pivot table to a worksheet |
|
Insert the current plot into a worksheet |
|
add sparklines to workbook |
|
add style to workbook |
|
Add a worksheet to a workbook |
|
|
Workbook creators |
Add data to a worksheet |
|
Remove column widths from a worksheet |
|
Remove a worksheet filter |
|
Remove custom row heights from a worksheet |
|
Remove an Excel table in a workbook |
|
Remove a worksheet from a workbook |
|
wb get and set functions |
|
get and set cell style |
|
|
get and set table of sheets and their state as selected and active |
Get/set worksheet visible state |
|
|
Workbook creators |
Return the workbook default font |
|
Get sheet name |
|
Get worksheet names for a workbook |
|
List Excel tables in a workbook |
|
Get a worksheet from a |
|
Order of worksheets in xlsx file |
|
Modify the default font |
|
Set the workbook position, size and filter |
|
Set worksheet column widths |
|
Set document headers and footers |
|
Add another author to the meta data of the file. |
|
Set worksheet row heights |
|
Set worksheet names for a workbook |
|
create functions |
|
|
Create, write and remove comments |
create border |
|
create_cell_style |
|
Create a custom formatting style |
|
create fill |
|
create font format |
|
create Excel hyperlink string |
|
create number format |
|
create sparklines used in |
|
XML functionsA curated list of XML functions used in openxlsx2. |
|
read xml file |
|
xml_node |
|
append xml child to node |
|
adds or updates attribute(s) in existing xml node |
|
create xml_node from R objects |
|
remove xml child to node |
|
loads character string to pugixml and returns an externalptr |
|
All functions |
|
Create a new hyperlink object |
|
Get create or remove named regions |
|
loads character string to pugixml and returns an externalptr |
|
get and set cell style |
|
Clean worksheet name |
|
clean sheet (remove all values) |
|
clone sheets style |
|
Convert Excel column to integer |
|
|
Create, write and remove comments |
convert back to ExcelDate |
|
Convert from excel date number to R Date type |
|
Convert from excel time number to R POSIXct type. |
|
create border |
|
create_cell_style |
|
Create a custom formatting style |
|
create fill |
|
create font format |
|
create Excel hyperlink string |
|
create number format |
|
create sparklines used in |
|
create dimensions from dataframe |
|
create dataframe from dimensions |
|
Return excel cell coordinates from (x,y) coordinates |
|
helper get_cell_style |
|
Get the date origin an xlsx file is using |
|
function to estimate the column type. 0 = character, 1 = numeric, 2 = date. |
|
Convert integer to Excel column |
|
Create / delete a named region |
|
check if numFmt is date. internal function |
|
check if numFmt is posix. internal function |
|
xlsx reading, writing and editing. |
|
print pugi_xml |
|
xml_node |
|
Get names of worksheets |
|
Read from an Excel file or Workbook object |
|
read xml file |
|
|
get and set table of sheets and their state as selected and active |
helper set_cell_style |
|
Get/set worksheet visible state |
|
check if style is date. internal function |
|
check if style is posix. internal function |
|
style manager |
|
get all styles on a sheet |
|
helper function to create temporary directory for testing purpose |
|
|
|
R6 class for a Workbook Chart Sheet |
|
Create a new wbColour object |
|
R6 class for a Workbook Comments |
|
R6 class for a Workbook Hyperlink |
|
R6 class for a Workbook Hyperlink |
|
R6 class for a Workbook |
|
R6 class for a Workbook Worksheet |
|
add border for cell region |
|
add cell style for cell region |
|
add a chart xml to a workbook |
|
Add a chartsheet to a workbook |
|
Add conditional formatting to cells |
|
Add data to a worksheet as an Excel table |
|
Add data validation to cells |
|
add drawings to workbook |
|
add fill for cell region |
|
Add column filters |
|
add font for cell region |
|
Add form control Checkbox, Radiobuttons or Dropmenu |
|
Add a character vector as an Excel Formula |
|
Insert an image into a worksheet |
|
Add mschart object to an existing workbook |
|
add numfmt for cell region |
|
Add a page break to a worksheet |
|
Add pivot table to a worksheet |
|
Insert the current plot into a worksheet |
|
add sparklines to workbook |
|
add style to workbook |
|
Add a worksheet to a workbook |
|
clone sheets style |
|
Clone a worksheet to a workbook |
|
copy cells around |
|
|
Workbook creators |
provide wb_data object as mschart input |
|
Freeze a worksheet pane |
|
Return the workbook default font |
|
Get sheet name |
|
Get worksheet names for a workbook |
|
List Excel tables in a workbook |
|
Get a worksheet from a |
|
Set worksheet gridlines to show or hide. |
|
Load an existing .xlsx file |
|
Modify the default font |
|
little worksheet opener |
|
Order of worksheets in xlsx file |
|
Protect a workbook from modifications |
|
Protect a worksheet from modifications |
|
Read from an Excel file or Workbook object |
|
Remove column widths from a worksheet |
|
Remove a worksheet filter |
|
Remove custom row heights from a worksheet |
|
Remove an Excel table in a workbook |
|
Remove a worksheet from a workbook |
|
Save Workbook to file |
|
Set the workbook position, size and filter |
|
Set worksheet column widths |
|
Set document headers and footers |
|
Add another author to the meta data of the file. |
|
Set worksheet row heights |
|
Set worksheet names for a workbook |
|
Create Dataframe from Workbook |
|
Create a new Workbook object |
|
|
Group Rows and Columns |
Add data to a worksheet |
|
Write to a worksheet as an Excel table |
|
write xml file |
|
Write a character vector as an Excel Formula |
|
write data to an xlsx file |
|
Worksheet cell merging |
|
Set page margins, orientation and print scaling |
|
Open a Microsoft Excel file (xls/xlsx) or an openxlsx2 wbWorkbook |
|
append xml child to node |
|
adds or updates attribute(s) in existing xml node |
|
create xml_node from R objects |
|
remove xml child to node |