How I can write the record of whole array into .xlsx file using phpExcel library
However i have seen the basing xample but they are using column name and rowsnumber i.e
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Hello')
->setCellValue('B2', 'world!')
->setCellValue('C1', 'Hello')
->setCellValue('D2', 'world!');
but I want to write with the array
and my array would beee something like that
Array
(
[0] => Array
(
[SR.NO] => 15
[MONTH] => Oct-11
[CLIENT] => xxxxxL
[OPERATOR] => xxxxx
}
[1] => Array
(
[SR.NO] => 15
[MONTH] => Oct-11
[CLIENT] => xxxxx
[OPERATOR] => xxxxx
}
the row can be any number below 90000
so how we can do this ?
I am really not getting any idea how to begin