How to export data in multiple sheets in php

how to export multiple sheets in excel using php
how to create multiple sheets in csv using php
phpexcel read multiple sheets example
how to create multiple sheets in excel using codeigniter
phpspreadsheet multiple sheets
laravel excel import multiple sheets
excel php
phpexcel_iofactory php

I have used PHPExcel class in php to export data but PHPExcel version 1.8 is deprecated in 2015.

Can I get any alternative solution for exporting multiple sheets.

You can use PHPSpreadhsheet. This is what the currently deprecated PHPExcel library has been continued as.

According to the docs. You will need to use the Composer package manager to install this library on your machine, by running the following command at the location of installation -

composer require phpoffice/phpspreadsheet

Include the library in your .php file in the following way -


    // load the classes provided by PHPSpreadSheet
    require 'vendor/autoload.php';

    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

    $spreadsheet = new Spreadsheet();

    // code to create and use worksheet goes here

To create/add new worksheets you can use this function -


You can create multiple worksheets by using the above command in a for() or while() loop.

To get the worksheet and edit it, you can fetch it by index in the following way -


The above command will fetch the second sheet from the workbook (since the worksheets are always indexed from "0").

Exporting Data into Multiple Excel sheets in PHP, php For export table data. database.php. <?php $url='localhost'; $username = "​root  There are number of ways we can export database using PHP script can be done number of ways. But here we will export data into multiple excel file, and that file will be store under folder. By click on link, we can download multiple file one by one.

I would recommande using Box/Spout : if you have to deal with huge data ! (NB : I have no affiliation with this project)

May depend on which PHPExcel functionnalities you're looking for...

Export Excel document with multiple worksheets in PHP, Tutorial 28 | | This tutorial shows how to export data to XLS file (1) that has | multiple sheets (2) in PHP. The first sheet is filled with data (3). I am trying to export data to Excel using this PHP Class, so far things are working fine and the export is being generated. But now I have a new requirement of generating multiple sheets inside a single excel file. For example if i have two arrays, i want both to be on separate sheets.

Export data to Excel XLS file in PHP, Read Split Data via jQuery AJAX. First, the data are requested from the database and split into several HTML tables. This process is done with a  Export MySQL data to excel sheet complete source code with screen shot and example. PHP total Month and Year PHP Multiple jQuery table Data Insert PHP HTML

Split and Export into Multiple Excel Sheet Files using PHP, I can put my query like this,i have 3 different tables and want each table records to get exported to 3 different worksheets of one excel file. Aug 2 '  you can easily access or export data using php to excel from multiple tables using joins. for more you can visit:Export Data To Excel In PHP.

How to Export Mysql Data into Multiple Excel File using PHP , I have been working on some PHP code to take some SQL data and put it into a Excel workbook with multiple sheets. The data example is  When you need a PHP script, that can export database data (records) to an excel file, then this article will help you. It has detailed step by step description with example code. It is compact and lightweight code that can be integrated in your PHP web applications.

How to export data to multiple excel worksheets using php, I have used PHPExcel class in php to export data but PHPExcel version 1.8 is deprecated in 2015. Can I get any alternative solution for exporting multiple  Overloaded methods For methods with same name but different parameters, only the first method overload retains the original name. Subsequent overloads are uniquely renamed by appending to the method name '_2', '_3', etc (method, method_2, method_3), an integer that corresponds to the order of declaration that can be found in EasyXLS.h, a file that comes with EasyXLS installation.

  • you have the answer right where you read that it is deprecated... what is wrong with that?