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
- Highlighting cells that begin with the given text
- Creating a gradated color scale on the cells
- Highlighting cells that more than the specified value
- Highlighting alternating rows
Would you like to share your own code example? Please click here.