|
|
|
|
|
Data Manipulation
Essential XlsIO has advanced support for working with data in a spreadsheet. Here are some key functionalities that enable data manipulation:
|
|
|
|
Named Range is a powerful feature in MS Excel which makes it possible to assign a name to a group of cells. Essential XlsIO has APIs to insert new named ranges into a spreadsheet and also read existing named ranges. Named ranges can also be used in formulae.
Named Range Feature in MS Excel
|
|
|
|
Essential XlsIO also provides a simple API that makes working with ADO.NET datasources very easy. It just takes one line of code to import an ADO.NET datatable into a spreadsheet. You can export the data as well. There are similar methods to work with other datasources like DataView, DataColumn and Arrays.
Export Data-Sample Code
|
|
|
|
In Essential XlsIO, IRange interface is used to represent a single cell or a group of cells in a spreadsheet. Using this object you can perform operations on a range of cells instead of an individual cells.
Range Manipulation in MS Excel
|
|
|
|
The Auto-filter feature can be used to filter records that meet specific criteria. Essential XlsIO has API to insert an auto-filter in a spreadsheet and specify the range to be filtered.
Sample Code-Set Up Auto-filter
Table Filtered by Category 'Dairy Products'
|
|
|
|
Data Validation is an MS Excel feature which dynamically validates data entered in a cell. The validation rules are specified in the Data Validation settings. Essential XlsIO also supports writing of data validation rules in a cell.
Data validation in MS Excel
|
|
|
|
Essential XlsIO provides rich APIs to carry out the search-and-replace operation in spreadsheets. You can find a number, text or date of specified format, extract it, and replace it with a given value.
Sample Code-Find and Replace Operation
|
|
|
|
|
|
|
|
