Xceed Workbooks for .NET is a .NET library that provides a comprehensive set of features for working with Excel files in .NET applications. With Xceed Workbooks, you can read, write, and modify Excel files programmatically, without requiring Microsoft Excel to be installed on the system.

Manipulating xlsx files in .NET can appear complicated and tedious however, doing so only requires a few lines of codes while using Xceed Workbooks for .NET.

The SearchControl makes it possible to search text throughout the entire data source, to search for occurrences of a specific text value within the DataGrid.

The DataGrid for WPF offers 3 ways to set a filter: Native CollectionView Filtering (using the Filter parameter on the CollectionViewSource), Automatic Filtering (using the AutoFilterControl) and Advanced Filtering (using the FilterRow)

In part four of this tutorial series, we conclude our overview of the changes in Workbooks for .NET v1.2 by examining the following features: "Merging and unmerging cells", "Wraping the content of a cell" and "Modifying more properties on Picture"

In part three of this tutorial series, we continue our overview of the changes in Workbooks for .NET v1.2 by examining the ThemeColor class" and how to modify Border and Fill on Style

In part two of this tutorial series, we continue our overview of the changes in Workbooks for .NET v1.2 by examining different examples for ColumnRange, RowRange, RowHeight and CellRange

Version 1.2 of Workbooks for .NET was released recently, and with it comes new things we can do to customize our xlsx documents. We will go over some of them over this and the next few articles.

In the context of Workbooks for .NET, a hyperlink will be a word or sentence in a given cell or range of cells. The Hyperlink class encapsulates the object that represents a hyperlink

Now that we know the basics to making and editing our Workbook, including the use of Tables, Styles and SheetViews, let's look into adding a new element: Pictures