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


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"


                                $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"));

More Examples

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



By default, it exports excel file


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