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

Description

GOModel 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

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

More Examples

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

Result/Output

By default, it exports excel file

Debug

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