Data Manipulation

Essential XlsIO has advanced support for working with Data in a worksheet. Here are some key functionalities that enables working with data easier.

Named ranges is a powerful feature in excel which makes it possible to assign a name to a group of cells. XlsIO has APIs for inserting new named ranges into workbooks and also to read existing named ranges. Named ranges can also be used in formulas.

Essential XlsIO also has some helper methods that make working with ADO.NET datasources very easy. It only takes one line of code to import an ADO.NET datatable into a worksheet. You could also export the data as well. There are similar methods for working with other data sources like DataView, DataColumn, Arrays etc.

In Essential XlsIO IRange interface is used to represent a single cell or a group of cells in a worksheet. XlsIO also has several useful methods for manipulating the data and formatting in the ranges. You can move, copy and insert the ranges as well.

Autofilters can be used to filter records that meet a specific criteria. Essential XlsIO has API to insert an autofilter into a worksheet and specify the range that needs to be filtered.

Data Validation is an essential feature of Excel, that enables you to dynamically validate the data that is entered in a cell. XlsIO provides numerous properties to specify the data validation settings. Essential XlsIO has support for reading as well as writing data validation rules for a cell.

Essential XlsIO provides rich APIs to carry out the search and replace operation with workbooks. You can find a number or text or date with the specified format, extract it and get it replaced with a given value.