What are the main differences between PHPExcel and PhpSpreadsheet?

PHPExcel has been maintained as a library for working with spreadsheet files for many years now, and has been shackled by retaining support for older versions of PHP (>= 5.2) making it very difficult to move forward and improve it. It is a stable library, but will not be developed any further.

PHPSpreadsheet is the newest version of PHPExcel, and large parts of it have been rewritten to take advantage of the newer features of PHP. While retaining all the functionality of PHPExcel, it requires a minimum PHP version of 5.5 (and soon that will be dropped to require a minimum of 5.6).

The change in library name was to reflect the fact that it isn’t limited to Excel spreadsheets; but supports a wider range of spreadsheet file formats.

EDIT 2020:

PHP Excel was officially deprecated in 2017 and permanently archived in 2019.

PHP Excel has not be maintained for years and must not be used anymore. All users must migrate to its direct successor PhpSpreadsheet, or another alternative.

Related Posts:

  1. Google Calendar API event update always return 404 “not found” error
  2. How to avoid Request Entity Too Large 413 error
  3. Array to String PHP?
  4. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  5. currently unable to handle this request HTTP ERROR 500
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Get the full URL in PHP
  8. How to force file download with PHP
  9. How to Set Category Page as Home Page in Prestashop
  10. XAMPP Port 80 in use by “Unable to open process” with PID 4
  11. PHP random string generator
  12. What are the differences in die() and exit() in PHP?
  13. Expected status code 200 but received 500
  14. Regex to check for new line
  15. Elegant way to search for UTF-8 files with BOM?
  16. Is SAJAX dead? What to replace with?
  17. break out of if and foreach
  18. Redirect vs RedirectMatch
  19. what does a .php?id=&value=value means?
  20. Setting up a PHP interpreter in PhpStorm
  21. Can curl make a connection to any TCP ports, not just HTTP/HTTPS?
  22. Get Current URL in Magento and show something
  23. Error 330 (net::ERR_CONTENT_DECODING_FAILED):
  24. What does __FILE__ mean?
  25. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  26. Weird PHP error: ‘Can’t use function return value in write context’
  27. How do I fix “Undefined variable” error in PHP?
  28. How do you parse and process HTML/XML in PHP?
  29. Is there a difference between the UTC and Etc/UTC time zones?
  30. Fatal error: Call to a member function prepare() on null
  31. PHP mail not working for some reason
  32. move_uploaded_file gives “failed to open stream: Permission denied” error
  33. PHP convert XML to JSON
  34. PHP if not statements
  35. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  36. WordPress Error : Upload folder is not writable. Export and file upload features will not be functional
  37. How to call function of one php file from another php file and pass parameters to it?
  38. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  39. Is it possible to run .php files on my local computer?
  40. how to get id from URL using php
  41. Fatal error: Cannot use object of type mysqli_result
  42. mysql_field_name to the new mysqli
  43. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  44. mysqli_select_db() expects parameter 1 to be mysqli, string given
  45. Php include not working? function not being included
  46. PHP mail function doesn’t complete sending of e-mail
  47. Remove all special characters from a string
  48. Convert php array to Javascript
  49. how to convert object into string in php
  50. PHP Fatal error: Call to undefined function mssql_connect()
  51. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  52. Call to a member function on null?
  53. how to ping ip addresses in php and give results
  54. do_shortcode not working
  55. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  56. Only variable references should be returned by reference – Codeigniter
  57. PHP Unset Session Variable
  58. “Fatal error: Cannot redeclare function”
  59. php get all url variables
  60. How to remove unused dependencies from composer?
  61. how to get date of yesterday using php?
  62. phpinfo() is not working on my CentOS server
  63. How can I fetch all items from a DynamoDB table without specifying the primary key?
  64. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  65. How to extract and access data from JSON with PHP?
  66. How to convert array to SimpleXML
  67. What does double question mark (??) operator mean in PHP
  68. How can I find the php.ini file used by the command line?
  69. WordPress query single post by slug
  70. TCPDF ERROR: Some data has already been output, can’t send PDF file
  71. Check if a PHP cookie exists and if not set its value
  72. Deprecated: mysql_query() [duplicate]
  73. Limit String Length
  74. Call to undefined function mysql_query() with Login [duplicate]
  75. Is there a function to make a copy of a PHP array to another?
  76. How to run PHP locally on MacOS
  77. Call PHP function from jQuery?
  78. PhpMailer SMTP NOTICE: EOF caught while checking if connected
  79. Facebook – Error parsing input URL, no data was cached, or no data was scraped
  80. What is the meaning of sprintf(): Too few arguments
  81. How to use $_SERVER[‘HTTP_REFERER’] correctly in php?
  82. what is $_SERVER[‘QUERY_STRING’] ? how it works?
  83. PHP Error : Fatal error: Constant expression contains invalid operations
  84. JavaScript equivalent of PHP’s in_array()
  85. Paypal IPN Verification Postback with HTTPS
  86. Create a folder if it doesn’t already exist
  87. Implement linked list in php
  88. Using PHP 7 with WAMP
  89. Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0
  90. PHP: date function to get month of the current date
  91. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 
  92. How to make PDF file downloadable in HTML link?
  93. PHP: bootstrap.php
  94. Display array values in PHP
  95. Php create a file if not exists
  96. What is a templating language?
  97. Page redirect after certain time PHP
  98. Check if $_POST exists
  99. PHP Header redirect not working [duplicate]
  100. PHP – Fatal error: Unsupported operand types

Leave a Comment