Xlsx library

Empty worksheet

With statement

Simple data in worksheet

Alternative addressing

Fill in table

Column widths specification

Styles in worksheet

More styles in worksheet

Alternative styles

Format defined for row

Format set for column

Write proper types

Numeric format

Numeric format

Alternative numeric format

Font size specification

Named colors

Html colors

Named bg colors

Html background colors

Comments in cells

Comments shown by default

Comments, alternative addressing

More worksheets in workbook

More worksheets in workbook, with names

More worksheets in workbook, same names

Merged cells

Merged already merged cells

Merged cells across more columns and rows

Merged cells, alternative addressing

Conditional formatting

Conditional formatting, alternative addressing

Conditional formatting, ‘between’ clause

Conditional formatting, ‘not between’ clause

Conditional formatting, ‘average’ clause

Autofilters

Autofilters, alternative approach

Autofilters, data specification

Autofilters, text

Locked cells in protected workbook

Validator for cell entries