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 provides a simple API that makes 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. Using this object you can perform operations on a range of cells instead of on individual cells.

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 a feature in MS Excel which makes it possible to dynamically validate data entered in a cell. The validation rules are specified in the Data Validation settings. Essential XlsIO has support for writing data validation rules in 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.