First steps | Handling workbooks | Importing as workbook | Exporting data | Exporting data frames or vectors | Exporting a wbWorkbook | dims/ wb_dims() | A note on speed and memory usage

Add plot to workbook | Add {ggplot2} plot to workbook | Add plot via | Adding {encharter} plots | Add and fill a chartsheet | Add {mschart} plots

Styling showcase | Colors, text rotation and number formats | the quick way: using high-level functions | the long way: using bare-metal functions | Working with number formats | numfmts | numfmts2 | Modifying the column widths | wb_set_col_widths | Adding borders | add borders | styled table | the long way: creating everything from the bone | Use workbook colors and modify them | Copy cell styles | Style strings | Create custom table styles

Importing data | Basic import | col_names - first row as column name | detect_dates - convert cells to R dates | show_formula - show formulas instead of results | dims - read specific dimension | cols - read selected columns | rows - read selected rows | convert - convert input to guessed type | skip_empty_rows - remove empty rows | skip_empty_cols - remove empty columns | row_names - keep rownames from input | types - convert column to specific type | start_row - where to begin | na - define missing values

Rule applies to all each cell in range | Highlight row dependent on first cell in row | Highlight column dependent on first cell in column | Highlight cell dependent on | Highlight entire range cols X rows dependent only on cell A1 | Highlight cells in column 1 based on value in column 2 | Highlight duplicates using default style | Cells containing text | Cells not containing text | Cells begins with text | Cells ends with text | Colorscale colors cells based on cell value | Databars | Between | Top N | Bottom N | Logical Operators

Basic read and write functions | Read xlsx or xlsm files | Write xlsx files | Basic workbook functions | Loading a workbook | Styles | Conditional formatting | Data validation | Saving | Why openxlsx2? | Invitation to contribute

Simple formulas | Array formulas | Array formulas creating multiple fields | cells metadata (cm) formulas | dataTable formulas^[this example was originally provided by @zykezero for openxlsx.] | dataTable formula differences

Formatting with writeData and writeDataTable | Use of pre-defined table styles | Date Formatting | DateTime Formatting | Conditional Formatting | Numeric Formatting

Basic Examples | write.xlsx | write list of data.frames to xlsx-file | write.xlsx also accepts styling parameters | The simplest way is to set default options and set column class | Workbook styles | define a style for column headers | When writing a list, the stylings will apply to all list elements | write.xlsx returns the workbook object for further editing | Workbook creation walk-through | create workbook and set default border Colour and style | Add Sheets | write data to sheet 1 | write data to sheet 2 | add write group means | add write group variances | add style mean & variance table headers | save workbook | Gallery | Further Examples | Stock Price | Image Compression using PCA

readspss -- importing SPSS files to R | Installation | Import | Import options | Import details | Export | Package development | Thanks | Last words