PDO Export Function - Excel Export export data into excel directly using PDOModel helper functions

Description

PDOModel export to excel functions allows to export data to excel by passing array of data. Data needs to be passed in form of array and optionally you can define name of file to be exported.
Also, You can get data from select query and export data directly using this function.

Function Defination

  
                                void function arrayToExcel($excelArray, $fileName = "file.xlsx") ;

Parameters Details

Details Type Example
$excelArray - array of data array 2-D array of data
$fileName - optional name of file to be exported string any valid file name like "xyz.excel"

Examples

  
                                $pdomodel = new PDOModel(); //create object of the PDOModel class
                                /* array to excel function */
                                $data = array( array("row1col1","row1col2","row1col3","row1col4"),array("row2col1","row2col2","row2col3","row2col4"));
                                $pdomodel->arrayToExcel($data);

More Examples

 
                                //Example 1 
                                $records = $pdomodel->select("emp"); //get data from table
                                $pdomodel->arrayToExcel($records, "emp.xlsx");//export it to excel

Result/Output

By default, it exports excel file

Debug

Option Details Example
print_r($pdomodel->error) Print errors (if any)