openxlsx21.23.1 package

Modify the state of active and selected sheets in a workbook

Format Values using OOXML (Spreadsheet) Number Format Codes

loads character string to pugixml and returns an externalptr

Set the default font in a workbook

Clean worksheet name

Modify column widths of a worksheet

Convert spreadsheet column to integer

Internal comment functions

create consecutive dims from column and row vector

consecutive range in vector

Convert from spreadsheet date, datetime or hms number to R Date type

convert back to an Excel Date

Defunct: Convert to spreadsheet data

Create border format

Create cell style

Create custom color xml schemes

Create a comment

Create a custom formatting style

Create fill pattern

Create font format

Create spreadsheet hyperlink string

Create number format

Helper to create a shape

Create sparklines object

Create custom (pivot) table styles

Modify creators of a workbook

Create dimensions from dataframe

Defunct: Delete data

Helper functions to work with dims

Create dataframe from dimensions

Add/remove column filters in a worksheet

format strings independent of the cell style.

Group rows and columns in a worksheet

Convert integer to spreadsheet column

helper to check if a string looks like a cell

Modify named regions in a worksheet

Options consulted by openxlsx2

Deprecated functions in package openxlsx2

xlsx reading, writing and editing.

Helper for adding threaded comments

print pugi_xml

Modify workbook properties

xml_node

read xml file

Modify row heights of a worksheet

Get / Set worksheet names for a workbook

Get/set worksheet visible state in a workbook

Get all styles on a sheet

helper function to create temporary directory for testing purpose

openxlsx2 waivers

Modify borders in a cell region of a worksheet

Modify the style in a cell region

Add a chart XML to a worksheet

Add a chartsheet to a workbook

Add comment to worksheet

Add conditional formatting to cells in a worksheet

Add a data table to a worksheet

Add data validation to cells in a worksheet

Add data to a worksheet

Add drawings to a worksheet

Set a dxfs styling for the workbook

Modify the background fill color in a cell region

Modify font in a cell region

Add a checkbox, radio button or drop menu to a cell in a worksheet

Add a formula to a cell range in a worksheet

wb_add_hyperlink

Ignore error types on worksheet

Insert an image into a worksheet

wb get and apply MIP section

Add mschart object to a worksheet

Apply styling to a cell region with a named style

Modify number formatting in a cell region

Add a page break to a worksheet

Add a pivot table to a worksheet

Insert the current plot into a worksheet

Add a slicer/timeline to a pivot table

Add sparklines to a worksheet

Set the default style in a workbook

Add threaded comments to a cell in a worksheet

Add a worksheet to a workbook

Set the default colors in a workbook

Apply styling to a cell region

Remove all values in a worksheet

Apply styling from a sheet to another within a workbook

Create copies of a worksheet within a workbook

Helper to create a color

Helper to create a comment object

Copy cells around within a worksheet

Add the wb_data attribute to a data frame in a worksheet

Helper to specify the dims argument

Freeze pane of a worksheet

List tables in a worksheet

Load an existing .xlsx, .xlsm or .xlsb file

Merge cells within a worksheet

Preview a workbook in a spreadsheet software

Order worksheets in a workbook

Set page margins, orientation and print scaling of a worksheet

Protect a worksheet from modifications

Protect a workbook from modifications

Remove a data table from a worksheet

Remove a worksheet from a workbook

Save a workbook to file

Get and Set the workbook position, size and filter

Modify grid lines visibility in a worksheet

Set headers and footers of a worksheet

Modify author in the metadata of a workbook

Modify the default view of a worksheet

Create a data frame from a Workbook

Update a data table position in a worksheet

Create a new Workbook object

Workbook class

Defunct: Write an object to a worksheet

Defunct: Write to a worksheet as a spreadsheet table

Defunct: Write a character vector as a spreadsheet Formula

Write data to an xlsx file

Open an xlsx file or a wbWorkbook object

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