Jan
12
Posted on 12-01-2015
Filed Under (ASP.NET, C#, Excel, Import, VB.NET, WinForms) by Daniela

Import data from Excel in C# or VB.NET

EasyXLS in an Excel library for C# and VB.NET that can be used to import Excel files in C# or VB.NET applications, like ASP.NET web application (including MVC), WinForms applications or console applications.

The Excel library works without Excel installed and without OLEDB. It is not dependent on other additional software.

Great tips about importing Excel files using EasyXLS can be found on the following links:

EasyXLS allows the import of Excel data or any other information contained inside the Excel file.

This Excel library allows the importing of XLSX, XLS, XLSM or XLSB file formats for Microsoft Excel 97, 2003, 2007, 2010 and 2013.

The imported Excel files can have one sheet or multiple sheets. It also permits the import of ranges of Excel data.

EasyXLS can be used from ASP.NET applications and this code sample about how to import Excel to GridView in ASP.NET is handy.

EasyXLS can be also used from WinForms and this code sample about how to import Excel to DataGridView in C# or VB.NET is practical.

For importing Excel data to a more general data structure this code sample about how to import Excel to DataTable in C# and VB.NET is more useful.

Another common situation is related to Excel files and databases. This code sample shows how to import Excel data to SQL database in C# and VB.NET.

(0) Comments    Read More   
Post a Comment
Name:
Email:
Website:
Comments: