Apr
06
Posted on 06-04-2015
Filed Under (Uncategorized) by Oana

Import Excel data to MySQL, SQL Server in PHP or ASP classic


Import Excel data to MySQL, SQL Server in PHP or ASP classic! The data can be imported from an Excel sheet or from the active Excel sheet. The entire sheet data or only data from a range of cells can be imported.

http://www.easyxls.com/manual/FAQ/import-excel-to-mysql.html

(0) Comments    Read More   
Feb
16
Posted on 16-02-2015
Filed Under (Uncategorized) by Oana

Import data from XLSM file in C#, VB.NET, Java, PHP, C++

EasyXLS is an Excel component that facilitates the import of XLSM files in applications written in C#, VB.NET, Java, C++, PHP or ASP classic.

The XLSM file format is the Microsoft Excel 2007-2013 file format for Excel files with macros included.

Using EasyXLS, you can import Excel data into GridView, DataGridView, DataGrid, DataTable, DataSet, List, JTable or ResultSet data structures with one single line of code.

Also, the imported Excel data can be inserted in databases like SQL Server, MySQL, Oracle or MS Access.

The data can be imported from specific sheets or from ranges of Excel cells inside a sheet.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be imported with less memory consumption and at a reasonable speed.

Besides the data inside the XLSM file, other information from the Excel file can be imported including cell formatting, hyperlinks, images, formulas, charts or pivot tables.

EasyXLS can be integrated in .NET applications like ASP.NET web application (inclusive MVC), WinForms or console applications.

EasyXLS can also be incorporated in Java applications or servlets, C++ applications (MFC), PHP or ASP classic web pages.

Check code samples about how to import data from xlsm file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Feb
09
Posted on 09-02-2015
Filed Under (Uncategorized) by Oana

Import data from XLSB file in C#, VB.NET, Java, PHP, C++

EasyXLS is an Excel component that facilitates the import of XLSB files in applications written in C#, VB.NET, Java, C++, PHP or ASP classic.

The XLSB file format is the new binary format used by Microsoft Excel 2007-2013.

Using EasyXLS, you can import Excel data into GridView, DataGridView, DataGrid, DataTable, DataSet, List, JTable or ResultSet data structures with one single line of code.

Also, the imported Excel data can be inserted in databases like SQL Server, MySQL, Oracle or MS Access.

The data can be imported from specific sheets or from ranges of Excel cells inside a sheet.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be imported with less memory consumption and at a reasonable speed.

Besides the data inside the XLSB file, other information from the Excel file can be imported including cell formatting, hyperlinks, images, formulas, charts or pivot tables.

EasyXLS can be integrated in .NET applications like ASP.NET web application (inclusive MVC), WinForms or console applications.

EasyXLS can also be incorporated in Java applications or servlets, C++ applications (MFC), PHP or ASP classic web pages.

Check code samples about how to import data from xlsb file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Jan
26
Posted on 26-01-2015
Filed Under (Uncategorized) by Oana

Import data from XLSX file in C#, VB.NET, Java, PHP, C++

EasyXLS is an Excel component that facilitates the import of XLSX files in applications written in C#, VB.NET, Java, C++, PHP or ASP classic.

The XLSX file format is the OpenXML format used by Microsoft Excel 2007-2013.

Using EasyXLS, you can import Excel data into GridView, DataGridView, DataGrid, DataTable, DataSet, List, JTable or ResultSet data structures with one single line of code.

Also, the imported Excel data can be inserted in databases like SQL Server, MySQL, Oracle or MS Access.

The data can be imported from specific sheets or from ranges of Excel cells inside a sheet.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be imported with less memory consumption and at a reasonable speed.

Besides the data inside the XLSX file, other information from the Excel file can be imported including cell formatting, hyperlinks, images, formulas, charts or pivot tables.

EasyXLS can be integrated in .NET applications like ASP.NET web application (inclusive MVC), WinForms or console applications.

EasyXLS can also be incorporated in Java applications or servlets, C++ applications (MFC), PHP or ASP classic web pages.

Check code samples about how to import data from xlsx file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Jan
19
Posted on 19-01-2015
Filed Under (Uncategorized) by Daniela

Import data from XLS file in C#, VB.NET, Java, PHP, C++

EasyXLS is an Excel component that facilitates the import of XLS files in applications written in C#, VB.NET, Java, C++, PHP or ASP classic.

The XLS file format is the old binary format used by Microsoft Excel 97-2003.

Using EasyXLS, you can import Excel data into GridView, DataGridView, DataGrid, DataTable, DataSet, List, JTable or ResultSet data structures with one single line of code.

Also, the imported Excel data can be inserted in databases like SQL Server, MySQL, Oracle or MS Access.

The data can be imported from specific sheets or from ranges of Excel cells inside a sheet.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be imported with less memory consumption and at a reasonable speed.

Besides the data inside the XLS file, other information from the Excel file can be imported including cell formatting, hyperlinks, images, formulas, charts or pivot tables.

EasyXLS can be integrated in .NET applications like ASP.NET web application (inclusive MVC), WinForms or console applications.

EasyXLS can also be incorporated in Java applications or servlets, C++ applications (MFC), PHP or ASP classic web pages.

Check code samples about how to import data from xls file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Dec
09
Posted on 09-12-2014
Filed Under (Uncategorized) by Daniela

import Excel to SQL databaseEasyXLS Excel library makes possible the import of Excel file into SQL tables without OLEDB engine.

The Excel library can be used from WinForms or ASP.NET web applications that uses MS SQL Server, MySQL, MS Access, Oracle or any other database.

The data that can be imported from Excel file might be from XLSX, XLS, XLSM or XLSB files.

EasyXLS permits the import of data from entire Excel sheet or only from a range of cells.

See source code samples and more details about how to import Excel to SQL table in C# or VB.NET.

(0) Comments    Read More   
Jun
27
Posted on 27-06-2014
Filed Under (Uncategorized) by Oana

export ResultSet to Excel in JavaEasyXLS is a Java Excel library that offers direct methods that allow exporting a ResultSet to Excel file in Java.
The export methods are easy to use and the task can be performed even in one single line of code.


Export SQL data to Excel using Java
EasyXLS makes it simple to extract data from database and export data to Excel in XLS, XLSX, XLSM or XLSB file formats. The data can be exported to nice formatted Excel reports. EasyXLS component allows you to export data from any database, including MS SQL Server or MySQL.

Export ResultSet to Open XML file format
EasyXLS supports Open XML file format and allows the export of XLSX files. It also supports XLSM and XLSB files.

Export ResultSet to Excel 97, Excel 2013, Excel 2007, Excel 2010, Excel 2013
EasyXLS supports all MS Excel 97-2013 file formats: XLS, XLSX, XLSM and XLSB. It also supports text file formats like XML Spreadsheet, CSV, TXT and HTML.

EasyXLS Java Excel library integration
EasyXLS Excel library can be integrated in any Java applications, applets, servlets or JSP pages or programming languages that permit Java development like ColdFusion.

Check out this code sample on how to easily export ResultSet to Excel in Java!

(0) Comments    Read More   
Jun
10
Posted on 10-06-2014
Filed Under (Uncategorized) by Oana

It’s never been easier. EasyXLS Excel library provides methods for exporting the DataSet to Excel with one single line of code.
See more details and code samples about how to export DataSet to Excel in C# and VB.NET.

Export SQL data to Excel using C# or VB.NET
EasyXLS makes it easy to take out data from database and export data to Excel in XLS and XLSX file formats. The data can be arranged in nice formatted reports. The component allows you to export data from any database, including MS SQL Server or MySQL.

Export to Excel in ASP.NET from DataSet
EasyXLS component can be used from ASP.NET web applications. If the data is displayed in a GridView, see export GridView to Excel in ASP.NET.

Export data from DataSet to Excel in C# and VB.NET from windows application
EasyXLS component can also be used from WinForms and windows applications. If data is displayed in a DataGridView, see how to export DataGridView to Excel in C#.

Export DataSet to Excel Open XML
EasyXLS supports Open XML file format and allows the export of XLSX files. It also supports XLSM and XLSB files.

Export DataSet to Excel 2003
EasyXLS supports Excel 2003 file format and allows the export of XLS files. It also supports XML Spreadsheet, CSV, TXT and HTML files.

ALL WITHOUT MS Excel installed, WITHOUT Interop!

(0) Comments    Read More   
May
20
Posted on 20-05-2014
Filed Under (Uncategorized) by Oana

EasyXLS Excel library is your key!

The DataTable can be the result of a SQL query or the data source for a GridView, DataGridView and DataGrid.

Export SQL query to Excel file
The result of a SQL query can be instantly exported to Excel with one line of code using EasyXLS Excel library. See more details about how to export DataSet to Excel.

Export GridView to Excel file
If the data source of the GridView is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the GridView formatting to Excel, check how to export GridView to Excel.

Export DataGridView to Excel file
If the data source of the DataGridView is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the DataGridView formatting to Excel, check how to export DataGridView to Excel.

Export DataGrid to Excel file
If the data source of the DataGrid is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the DataGrid formatting to Excel, check how to export DataGrid to Excel.

(0) Comments    Read More