waivers |
'openxlsx2' waivers |
wbWorkbook |
Workbook class |
wb_add_border |
Modify borders in a cell region of a worksheet |
wb_add_cell_style |
Modify the style in a cell region |
wb_add_chartsheet |
Add a chartsheet to a workbook |
wb_add_chart_xml |
Add a chart XML to a worksheet |
wb_add_comment |
Add comment to worksheet |
wb_add_conditional_formatting |
Add conditional formatting to cells in a worksheet |
wb_add_creators |
Modify creators of a workbook |
wb_add_data |
Add data to a worksheet |
wb_add_data_table |
Add a data table to a worksheet |
wb_add_data_validation |
Add data validation to cells in a worksheet |
wb_add_drawing |
Add drawings to a worksheet |
wb_add_dxfs_style |
Set a dxfs styling for the workbook |
wb_add_fill |
Modify the background fill color in a cell region |
wb_add_filter |
Add/remove column filters in a worksheet |
wb_add_font |
Modify font in a cell region |
wb_add_formula |
Add a formula to a cell range in a worksheet |
wb_add_form_control |
Add a checkbox, radio button or drop menu to a cell in a worksheet |
wb_add_ignore_error |
Ignore error types on worksheet |
wb_add_image |
Insert an image into a worksheet |
wb_add_mips |
wb get and apply MIP section |
wb_add_mschart |
Add mschart object to a worksheet |
wb_add_named_region |
Modify named regions in a worksheet |
wb_add_named_style |
Apply styling to a cell region with a named style |
wb_add_numfmt |
Modify number formatting in a cell region |
wb_add_page_break |
Add a page break to a worksheet |
wb_add_person |
Helper for adding threaded comments |
wb_add_pivot_table |
Add a pivot table to a worksheet |
wb_add_plot |
Insert the current plot into a worksheet |
wb_add_slicer |
Add a slicer/timeline to a pivot table |
wb_add_sparklines |
Add sparklines to a worksheet |
wb_add_style |
Set the default style in a workbook |
wb_add_thread |
Add threaded comments to a cell in a worksheet |
wb_add_timeline |
Add a slicer/timeline to a pivot table |
wb_add_worksheet |
Add a worksheet to a workbook |
wb_base_colors |
Set the default colors in a workbook |
wb_cell_style |
Apply styling to a cell region |
wb_clean_sheet |
Remove all values in a worksheet |
wb_clone_sheet_style |
Apply styling from a sheet to another within a workbook |
wb_clone_worksheet |
Create copies of a worksheet within a workbook |
wb_color |
Helper to create a color |
wb_colour |
Helper to create a color |
wb_comment |
Helper to create a comment object |
wb_copy_cells |
Copy cells around within a worksheet |
wb_data |
Add the 'wb_data' attribute to a data frame in a worksheet |
wb_dims |
Helper to specify the 'dims' argument |
wb_freeze_pane |
Freeze pane of a worksheet |
wb_get_active_sheet |
Modify the state of active and selected sheets in a workbook |
wb_get_base_colors |
Set the default colors in a workbook |
wb_get_base_colours |
Set the default colors in a workbook |
wb_get_base_font |
Set the default font in a workbook |
wb_get_cell_style |
Apply styling to a cell region |
wb_get_comment |
Add comment to worksheet |
wb_get_creators |
Modify creators of a workbook |
wb_get_mips |
wb get and apply MIP section |
wb_get_named_regions |
Modify named regions in a worksheet |
wb_get_order |
Order worksheets in a workbook |
wb_get_person |
Helper for adding threaded comments |
wb_get_properties |
Modify workbook properties |
wb_get_selected |
Modify the state of active and selected sheets in a workbook |
wb_get_sheet_names |
Get / Set worksheet names for a workbook |
wb_get_sheet_visibility |
Get/set worksheet visible state in a workbook |
wb_get_tables |
List Excel tables in a worksheet |
wb_get_thread |
Add threaded comments to a cell in a worksheet |
wb_grid_lines |
Modify grid lines visibility in a worksheet |
wb_group_cols |
Group rows and columns in a worksheet |
wb_group_rows |
Group rows and columns in a worksheet |
wb_load |
Load an existing .xlsx, .xlsm or .xlsb file |
wb_merge_cells |
Merge cells within a worksheet |
wb_open |
Preview a workbook in a spreadsheet software |
wb_order |
Order worksheets in a workbook |
wb_page_setup |
Set page margins, orientation and print scaling of a worksheet |
wb_protect |
Protect a workbook from modifications |
wb_protect_worksheet |
Protect a worksheet from modifications |
wb_read |
Create a data frame from a Workbook |
wb_remove_col_widths |
Modify column widths of a worksheet |
wb_remove_comment |
Add comment to worksheet |
wb_remove_conditional_formatting |
Add conditional formatting to cells in a worksheet |
wb_remove_creators |
Modify creators of a workbook |
wb_remove_filter |
Add/remove column filters in a worksheet |
wb_remove_named_region |
Modify named regions in a worksheet |
wb_remove_row_heights |
Modify row heights of a worksheet |
wb_remove_slicer |
Add a slicer/timeline to a pivot table |
wb_remove_tables |
Remove a data table from a worksheet |
wb_remove_timeline |
Add a slicer/timeline to a pivot table |
wb_remove_worksheet |
Remove a worksheet from a workbook |
wb_save |
Save a workbook to file |
wb_set_active_sheet |
Modify the state of active and selected sheets in a workbook |
wb_set_base_colors |
Set the default colors in a workbook |
wb_set_base_colours |
Set the default colors in a workbook |
wb_set_base_font |
Set the default font in a workbook |
wb_set_bookview |
Set the workbook position, size and filter |
wb_set_cell_style |
Apply styling to a cell region |
wb_set_cell_style_across |
Apply styling to a cell region |
wb_set_col_widths |
Modify column widths of a worksheet |
wb_set_creators |
Modify creators of a workbook |
wb_set_grid_lines |
Modify grid lines visibility in a worksheet |
wb_set_header_footer |
Set headers and footers of a worksheet |
wb_set_last_modified_by |
Modify author in the metadata of a workbook |
wb_set_order |
Order worksheets in a workbook |
wb_set_properties |
Modify workbook properties |
wb_set_row_heights |
Modify row heights of a worksheet |
wb_set_selected |
Modify the state of active and selected sheets in a workbook |
wb_set_sheetview |
Modify the default view of a worksheet |
wb_set_sheet_names |
Get / Set worksheet names for a workbook |
wb_set_sheet_visibility |
Get/set worksheet visible state in a workbook |
wb_to_df |
Create a data frame from a Workbook |
wb_ungroup_cols |
Group rows and columns in a worksheet |
wb_ungroup_rows |
Group rows and columns in a worksheet |
wb_unmerge_cells |
Merge cells within a worksheet |
wb_update_table |
Update a data table position in a worksheet |
wb_workbook |
Create a new Workbook object |
write_xlsx |
Write data to an xlsx file |