Overview of Xceed Data Grid for WPF Welcome to the getting started guide for Xceed Data Grid for Windows Presentation Foundation (WPF). Xceed Data Grid is a powerful, feature-rich, and highly customizable control that allows you to display, edit, and manage data in a tabular format. Designed specifically for WPF, it takes full advantage of […]

Xceed Workbooks for .NET: The Ultimate Excel .Net Library Excel is a popular tool for working with data, but its functionality can be limited when it comes to large data sets and complex calculations. This is where Xceed Workbooks for .NET comes in. Xceed Workbooks is a powerful Excel .NET library that provides developers with […]

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. Let’s look at a quick example : To Open an existing xlsx : using( var doc = Workbook.Load( “test.xlsx”) ) // Loads an existing Workbook named “test.xlsx”.{var worksheet = […]

Learn more about Xceed DataGrid for WPF Today let’s look at the Searching options and Cell Error Styles that the datagrid offers. SearchControl The DataGrid for WPF offers a built-in search option through the use of the SearchControl. The SearchControl makes it possible to search text throughout the entire data source, to search for occurrences of a […]

Learn more about Xceed DataGrid for WPF The last time we looked at the DataGrid for WPF we had looked at Grouping and Sorting. Today let’s look at the Filtering options that the datagrid offers. Filtering Options The DataGrid for WPF offers 3 ways to set a filter: Native CollectionView Filtering The data items that are […]

Learn more about Xeed Workbooks for .NET We conclude our overview of the changes in Workbooks for .NET v1.2. Merging and unmerging cells The ability to merge and unmerge cells was added. It can either be done by using the Add() and RemoveAt() methods on the Worksheet’s MergedCells property, or with the MergeCells() and UnmergeCells() methods on the CellRange to merge/unmerge The MergedCells property on a Worksheet is […]

Learn more about Xeed Workbooks for .NET We continue our overview of the changes in Workbooks for .NET v1.2. ThemeColor Class A ThemeColor class was added, which is used to represent a Theme‘s color. The ThemeColor class has the following properties: The available types for ThemeColor currently include: Note: properties that cover the same element are mutually exclusive. For […]

Learn more about Xeed Workbooks for .NET We continue our overview of the changes in Workbooks for .NET v1.2. Setting the Width on ColumnRange A Width property was added to the ColumnRange class to set the width of the columns covered by the ColumnRange. Using a ColumnRange allows us to define a range of consecutive Columns. The ColumnRange class has the following […]

Learn more about Xeed Workbooks for .NET 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. Inserting a Worksheet In our first article we covered how to add […]

Learn more about Xeed Workbooks for .NET Today we will look into adding another new element to our xlsx document: Hyperlinks. What is a Hyperlink? A hyperlink is an item like a word, sentence or object that points to another location. When you click on a link, it will take you to that link’s target. In […]