EasyXLS

Import CSV file in .NET, Java and other programming languages

EasyXLS™ library allows you to import data from CSV file format.

EasyXLS can be successfully used inclusively to import large CSV files having big volume of data with fast importing time.

Source code sample

The below example is a common code about how to import a CSV file.

C#.NET
VB.NET
C++
Java
PHP
ASP
VB6
VBS
Coldfusion
Python

The screen shot below represents the imported CSV file in the above code sample.

Import CSV file

Import CSV file with encoding

EasyXLS allows you to import CSV files with specific encoding using System.IO.StreamReader class in .NET and java.io.InputStreamReader class in Java with ExcelDocument.easy_LoadCSVFile, ExcelDocument.easy_ReadCSVFile_AsDataSet or ExcelDocument.easy_ReadCSVFile_AsList methods.

Read CSV file into DataTable in C# and VB.NET

EasyXLS library can be used to import CSV file into DataTable. The DataTable can be the used as data source of a GridView, DataGridView, DataGrid or for any other purposes.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsDataSet method and then the DataTable can be obtained from the imported DataSet.

Read CSV file into GridView in C# and VB.NET from ASP.NET

EasyXLS library can be used to import CSV data into GridView from ASP.NET web applications.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsDataSet method and then the DataTable for the GridView can be obtained from the imported DataSet.

Read CSV file into DataGridView in C# and VB.NET

EasyXLS library can be used to import CSV data into DataGridView from windows applications and windows forms.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsDataSet method and then the DataTable for the DataGridView can be obtained from the imported DataSet.

Read CSV file into DataSet in C# and VB.NET

EasyXLS library can be used to import CSV file into DataSet from windows applications, ASP.NET pages or console applications.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsDataSet method.

Read CSV file into ResultSet in Java

EasyXLS library can be used to import CSV file into ResultSet from Java applications.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsResultSet method.

Read CSV file into list

EasyXLS library can be used to import CSV file into lists of data.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsList method.

Read CSV file into DataGrid in C# and VB.NET

EasyXLS library can be used to import CSV data into DataGrid from windows applications and windows forms.

The data from the CSV file can be read using ExcelDocument.easy_ReadCSVFile_AsDataSet method and then the DataTable for the DataGrid can be obtained from the imported DataSet.

Import TXT files

EasyXLS allows you to import data from TXT files that use different separators than comma-separated values for data in rows and columns.

Getting started with EasyXLS Excel library

To download the trial version of EasyXLS Excel Library, press the below button:

Download EasyXLS™ Excel Library for .NET and Java

If you already own a license key, you may login and download EasyXLS from your account.



Available for: Professional, Excel Reader

Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files
Java Excel Reader
Java version to read and import Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT