LibXL - direct reading and writing Excel files
LibXL
excel library for developers
  • Home
  • Download
  • Documentation
  • Examples
  • Setup
  • FAQ
  • Purchase
  • Contact

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
Home Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat Examples 
© 2008 - 2023 XLware. All rights reserved.