How to import and export Excel files with PHP

This article introduces how to import and export excel files in php, use phpexcel or Spreadsheet_Excel_Writer class to export excel files, and introduces three methods of exporting csv files.

1. Export Excel file with PHP 1. Recommend phpexcel, official website: http://www.codeplex.com/PHPExcel Import and export are successful, you can export office 2007 format, and it is compatible with 2003

2. Use pear’s Spreadsheet_Excel_Writer class Download address: http://pear.php.net/package/Spreadsheet_Excel_Writer This class depends on OLE, download address: http://pear.php.net/package/OLE Note that the format of the exported Excel file is relatively old. When you save it after modification, you will be prompted whether to convert it to a newer format. But you can set the format, which is very powerful. 3. Use smarty to generate XML or HTML files that comply with Excel specifications. Supported formats, perfect export solution. However, the exported file is essentially an XML file. If it is used for import, it needs to be processed separately.

Note, if the number of rows in the exported table is uncertain, it is best to delete things like “ss:ExpandedColumnCount=”5″ ss:ExpandedRowCount=”21″” in the template. 4. Use the pack function to print out the sentence break symbols that simulate the Excel format. This is closer to the Excel standard format. After modification and saving in office 2003, no prompt will pop up. This method is recommended. The disadvantage is that it has no format.

5. How to use tab characters and line breaks The tab character "t" separates columns in the same row, and the newline character "tn" opens the next row.

6. Use com If PHP can open the com module, you can use it to export Excel files

2. PHP import excel file 1. Read in .csv format Convert .xls to .csv text format, and then use PHP to analyze the file, which is no different from PHP analyzing text. Advantages: cross-platform, relatively high efficiency, and can read and write. Disadvantages: You can only use .csv files directly. If you often accept .xls binary files, you need to convert them manually and cannot be automated. There is only one SHEET for a file. PHP has its own analysis.csv function: fgetcsv

2, ODBC link data source Advantages: Supports multiple formats, cvs, xls, etc. Supports reading and writing, uses standard SQL language, and is almost identical to SQLSERVER and mysql database. Disadvantages: Support windows server

3, PHP custom class Advantages: cross-platform. Some classes support write operations. Support for .xls binaries Commonly used classes include phpExcelReader and PHPExcel. The latter supports reading and writing, but requires php5.2 or above. phpExcelReader is specially used to read files. Returns an array containing all contents of the table.

>>>>Articles you may be interested in: Comprehensive example of php exporting excel table Example code for phpExcel to export excel and add hyperlinks Solution to solve the problem of numbers changing to scientific notation when exporting excel with PHP Simple example of PHP exporting EXCEL Use phpexcel class library to export excel Classic example of phpexcel exporting excel Example of php exporting excel format file Example code of php exporting excel Example code of php exporting excel (continuously refreshing the buffer)