Import Excel file to DataTable in C# and VB.NET. The entire sheet data or only data from a range of cells can be imported.
http://www.easyxls.com/manual/FAQ/import-excel-to-datatable.html
Import Excel data to DataGrid from Excel sheet or from ranges of cells!
http://www.easyxls.com/manual/FAQ/import-excel-to-datagrid.html
Import Excel data to GridView in C# and VB.NET! The entire sheet data or only data from a range of cells can be imported.
http://www.easyxls.com/manual/FAQ/import-excel-to-gridview.html
Import Excel data to DataGridView, in C# and VB.NET, from an Excel sheet or from the active Excel sheet.
http://www.easyxls.com/manual/FAQ/import-excel-to-datagridview.html
Import Excel file to DataSet in C# or VB.NET! Learn how to do it and save valuable time with EasyXLS!
http://www.easyxls.com/manual/basics/import-excel-to-dataset.html
Export DataGrid to Excel file in C# and VB.NET quick and effortless!
http://www.easyxls.com/manual/FAQ/export-datagrid-to-excel.html
EasyXLS & EU Outsourcing teams won the 1st and 2nd place on the Inter-Company Cross! Great team spirit! Congratulations!
Encoding for CSV, TXT and HTML files
EasyXLS will allow setting a custom character encoding like Unicode, ASCII, UFT-8 and UTF-32 when reading or writing CSV, TXT or HTML files.
The feature was already available for XLS, XLSX, XLSM and XLSB file formats and now was extended to text file formats.
The countries that use Greek alphabet, Cyrillic alphabet, Han script or special Latin characters will be able now to use the full functionality of our Excel library.
Format data labels for charts
EasyXLS will allow setting the data labels properties like:
- label position
- number format
- fill settings (no fill, solid fill, gradient fill, picture or texture fill, automatic)
- border color (no line, solid line, gradient line, automatic)
- border style (width, compound type, dash type, cap type, join type)
- shadow settings (presets, color, transparency)
- font settings (font name, font size, foreground, alignment)
- 3-D format settings(bevel, surface, lighting)