phpexcel生成与读取excel文件的例子

2. require_once 'classes/phpexcel/reader/excel2007.php';
3. require_once 'classes/phpexcel/reader/excel5.php';
4. include 'classes/phpexcel/iofactory.php';
6. function arraytoexcel($data){
7. $objphpexcel = new phpexcel();
8. $objphpexcel->setactivesheetindex(0);
9. $objphpexcel->getactivesheet()->settitle('firstsheet');
10. $objphpexcel->getdefaultstyle()->getfont()->setname('arial');
11. $objphpexcel->getdefaultstyle()->getfont()->setsize(10);
12. //add data
14. $i = 2;
15. foreach ($data as $line){
16. $objphpexcel->getactivesheet()->setcellvalue('a'.$i, $line['from']);
17. $objphpexcel->getactivesheet()->getcell('a'.$i)->setdatatype('n');
18. $objphpexcel->getactivesheet()->setcellvalue('b'.$i, $line['to']);
19. $objphpexcel->getactivesheet()->getcell('b'.$i)->setdatatype('n');
20. $i++;
21. }
22. $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel5');
23. $file = 'excel.xls';
24. $objwriter->save($file);
25. }

>>> 更多php教程内容，请关注本站php编程栏目。

如果不希望保存在服务器上，希望生成以后直接下载到客户端，可以在输出文件时添加以下代码，而不使用 $objwriter->save($file);

2. header("pragma: public");
3. header("expires: 0");
4. header("cache-control:must-revalidate, post-check=0, pre-check=0");
5. header("content-type:application/force-download");
6. header("content-type:application/vnd.ms-execl");
7. header("content-type:application/octet-stream");
8. header("content-type:application/download");
9. header('content-disposition:attachment;filename="excel.xls"');
10. header("content-transfer-encoding:binary");
11. $objwriter->save('php://output');

下面来看一个读取excel文件内容的实例： 以下代码函数exceltoarray的功能是把一个excel里的内容重新整理放到一个数组了。

2. require_once 'classes/phpexcel.php';
3. require_once 'classes/phpexcel/iofactory.php';
4. function exceltoarray($file){
5. $objreader = phpexcel_iofactory::createreader('excel5');
6. $objreader->setreaddataonly(true);
7. $objphpexcel = $objreader->load($file);
8. $objworksheet = $objphpexcel->getactivesheet();
9. $highestrow = $objworksheet->gethighestrow();
10. $highestcolumn = $objworksheet->gethighestcolumn();
11. $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);
12. $exceldata = array();
13. for ($row = 2; $row <= $highestrow; ++$row) {
14. for ($col = 0; $col <= $highestcolumnindex; ++$col) {
15. $exceldata[$row][] = $objworksheet->getcellbycolumnandrow($col, $row)->getvalue();
16. }
17. }
18. return $exceldata;
19. }