13 Tips to import Excel file in PHP or Classic ASP

How to import Excel file in PHP and Classic ASP

EasyXLS™ library allows you to import data from an Excel file or other sheet elements like cell formatting, charts, pivot tables, comments, images and others.

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

EasyXLS permits you to import Excel files without Excel installed, without OLEDB, without Interop or any other additional software installed.

Import data from Excel file
Import data from Excel file having one sheet
Import data from Excel file having multiple sheets
Import data from range of Excel cells
Import all Excel file structures
Import Excel file to MySQL, SQL Server in PHP and Classic ASP
Import Excel file to list in PHP and Classic ASP
Import Excel to XML in PHP and Classic ASP
Import data from XLSX file in PHP and Classic ASP
Import data from XLS file in PHP and Classic ASP
Import data from XLSM file in PHP and Classic ASP
Import data from XLSB file in PHP and Classic ASP
Import password protected Excel file in PHP and Classic ASP

Find more about Getting Started with EasyXLS

Step 1: Download and install EasyXLS Excel Library for .NET/COM+

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

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

Step 2: Verify if EasyXLS is registered

Check if EasyXLS component is present in Component Services.

Step 3: Run PHP/ASP code that imports data from Excel file

The below example shows how to import data from Excel file in PHP and Classic ASP. After that, the best techniques about importing the entire Excel file structures or importing Excel data to MySQL, SQL Server, Oracle or any other database are shown.

1. Import data from Excel file

EasyXLS allows you to import data from an Excel sheet or from the active Excel sheet. The entire sheet data or only data from ranges of cells can be imported.

PHP

ASP

2. Import data from Excel file having one sheet

Importing data from an Excel file, if the Excel file has only one sheet, is the easiest approach. The Excel data can be imported with one single line of code using:
- ExcelDocument.easy_ReadXLSXActiveSheet_AsList method for XLSX file
- ExcelDocument.easy_ReadXLSBActiveSheet_AsList method for XLSB file
- ExcelDocument.easy_ReadXLSActiveSheet_AsList method for XLS file

The above code sample shows how to achieve this goal.

3. Import data from Excel file having multiple sheets

There are three approaches for importing data from an Excel file with multiple sheets.

I. Usually the first sheet is the active sheet inside an Excel file. If this is your case or if you are importing data from another active sheet use:
- ExcelDocument.easy_ReadXLSXActiveSheet_AsList method for XLSX file
- ExcelDocument.easy_ReadXLSBActiveSheet_AsList method for XLSB file
- ExcelDocument.easy_ReadXLSActiveSheet_AsList method for XLS file

II. For importing data from an Excel sheet and the name of the sheet is known, EasyXLS recommends the use of:
- ExcelDocument.easy_ReadXLSXSheet_AsList method for XLSX file
- ExcelDocument.easy_ReadXLSBSheet_AsList method for XLSB file
- ExcelDocument.easy_ReadXLSSheet_AsList method for XLS file

III. For importing data from an Excel sheet and the name of the sheet is not known, the first step is to find the sheet name using:
- ExcelDocument.easy_ReadXLSXFile_SheetNames method for XLSX file
- ExcelDocument.easy_ReadXLSBFile_SheetNames method for XLSB file
- ExcelDocument.easy_ReadXLSFile_SheetNames method for XLS file

Then, import the sheet data in DataSet using:
- ExcelDocument.easy_ReadXLSXSheet_AsList method for XLSX file
- ExcelDocument.easy_ReadXLSBSheet_AsList method for XLSB file
- ExcelDocument.easy_ReadXLSSheet_AsList method for XLS file

4. Import data from range of Excel cells

EasyXLS enables you to import Excel data either from the entire sheet or from a range of cells. Importing only a range of cells is a very useful option especially for large Excel files because it reduces the speed of the import process.

In order to import multiple cell ranges at once from Excel sheet, the range parameter must be passed to the method as union of ranges (multiple ranges separated by comma).

All the methods that allow importing Excel to List have parameters that permit importing only ranges of cells.

5. Import all Excel file structures

EasyXLS allows you to import the whole Excel file with sheets, data inside sheets, formulas, cell formatting, comments, hyperlinks, images, data validation, page setup, macros, groups, filters, charts, pivot tables and pivot charts.

PHP

ASP

6. Import Excel file to MySQL, SQL Server in PHP and Classic ASP

EasyXLS library can be used to import Excel data to database like MySQL, SQL Server, Oracle, MS Access or any other database.

7. Import Excel file to list in PHP and Classic ASP

EasyXLS library can be used to import Excel sheets into lists of data.

8. Import Excel to XML in PHP and Classic ASP

EasyXLS library can be used to import Excel data into XML. The entire sheet data can be added to XML or only a range of cells.

9. Import data from XLSX file in PHP and Classic ASP

EasyXLS allows importing data from XLSX file from PHP web applications or Classic ASP web pages. Similarly, as shown in the above code samples, you can import data from XLSX file using ExcelDocument.easy_ReadXLSXActiveSheet_AsList, ExcelDocument.easy_ReadXLSXSheet_AsList or ExcelDocument.easy_LoadXLSXFile methods.

10. Import data from XLS file in PHP and Classic ASP

EasyXLS allows importing data from XLS file from PHP web applications or Classic ASP pages. Similarly, as shown in the above code samples, you can import data from XLS file using ExcelDocument.easy_ReadXLSActiveSheet_AsList, ExcelDocument.easy_ReadXLSSheet_AsList or ExcelDocument.easy_LoadXLSFile methods.

11. Import data from XLSM file in PHP and Classic ASP

EasyXLS allows importing data from XLSM file from PHP web applications or Classic ASP web pages. Similarly, as shown in the above code samples, you can import data from XLSM file using ExcelDocument.easy_ReadXLSXActiveSheet_AsList, ExcelDocument.easy_ReadXLSXSheet_AsList or ExcelDocument.easy_LoadXLSXFile methods.

12. Import data from XLSB file in PHP and Classic ASP

EasyXLS allows importing data from XLSB file from PHP web applications or Classic ASP web pages. Similarly, as shown in the above code samples, you can import data from XLSB file using ExcelDocument.easy_ReadXLSBActiveSheet_AsList, ExcelDocument.easy_ReadXLSBSheet_AsList or ExcelDocument.easy_LoadXLSBFile methods.

13. Import password protected Excel file in PHP and Classic ASP

EasyXLS allows importing encrypted Excel file. The Excel file can be password protected.

Getting started with EasyXLS Excel library