Reading an Excel file in PHP [closed]

by

You have 2 choices as far as I know:

  1. Spreadsheet_Excel_Reader, which knows the Office 2003 binary format
  2. PHPExcel, which knows both Office 2003 as well as Excel 2007 (XML). (Follow the link, and you’ll see they upgraded this library to PHPSpreadSheet)

PHPExcel uses Spreadsheet_Excel_Reader for the Office 2003 format.

Update: I once had to read some Excel files but I used the Office 2003 XML format in order to read them and told the people that were using the application to save and upload only that type of Excel file.

More Related Contents:

  1. Excel date conversion using PHP Excel
  2. Convert the FULL Excel date serial format to Unix timestamp
  3. Something wrong with PHP
  4. How to echo something outside of function?
  5. Undefined index $_POST
  6. How do I explode() these variables?
  7. PHP Sort a multidimensional array by element containing Y-m-d H:i:s date
  8. Does PHP allow named parameters so that optional arguments can be omitted from function calls?
  9. Fatal error: Call to undefined function mysql_connect()
  10. How can I use a JavaScript variable as a PHP variable? [duplicate]
  11. Convert string to binary then back again using PHP
  12. Using Default Arguments in a Function
  13. Insert query on page load, inserts twice?
  14. Get all variables sent with POST?
  15. Not equal to != and !== in PHP
  16. Xampp Access Forbidden php
  17. line breaks in a textarea
  18. How to output JavaScript with PHP
  19. Set timezone in PHP and MySQL
  20. Continue processing after closing connection [duplicate]
  21. Guzzle: handle 400 bad request
  22. PHP on Windows with XAMPP running 100 times too slow
  23. How to Convert Boolean to String
  24. Getting PEAR to work on XAMPP (Apache/MySQL stack on Windows)
  25. PHP form token usage and handling
  26. Getting a list of files by folder on Drive SDK
  27. TCPDF ERROR: Some data has already been output, can’t send PDF file
  28. PHP E-mail Form Sender Name Instead Of E-mail?
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. PHP: Escape RegEx pattern to prevent being applied?

Leave a Comment