Examples
See these examples for better understanding of this library:- Writing data
- Reading data
- Placing pictures
- Extracting pictures
- Writing formulas
- Reading and writing date/time values
- Access to sheet by name
- Merging cells
- Grouping rows and columns
- Inserting rows and columns
- Using number formats
- Aligning, colors and borders
- Customizing fonts
- Reading from memory buffer
- Writing to memory buffer
- Copying cells with formats to other workbook
- Sheet protection
- Replacing characters in all sheets
- Writing rich strings with multiple fonts in one cell
AutoFilter
- Top N number of items to filter by
- Sorting
- String custom filter
- Number custom filter
- Filter by values
Conditional formatting