phpExcel导出

本文转自http://www.phpernote.com/php-function/365.html

首先从github上面下载到类库并将PHPExcel.php引入到自己的项目当中

$data=array(

06

0=>array(

07	'id'=>1001,

08	'username'=>'张飞',

09	'password'=>'123456',

10	'address'=>'三国时高老庄250巷101室'

11

),

12

1=>array(

13	'id'=>1002,

14	'username'=>'关羽',

15	'password'=>'123456',

16	'address'=>'三国时花果山'

17

),

18

2=>array(

19	'id'=>1003,

20	'username'=>'曹操',

21	'password'=>'123456',

22	'address'=>'延安西路2055弄3号'

23

),

24

3=>array(

25	'id'=>1004,

26	'username'=>'刘备',

27	'password'=>'654321',

28	'address'=>'愚园路188号3309室'

29

)

30

);

31	$objPHPExcel=new PHPExcel();

32	$objPHPExcel->getProperties()->setCreator('http://www.phpernote.com')

33	->setLastModifiedBy('http://www.phpernote.com')

34	->setTitle('Office 2007 XLSX Document')

35	->setSubject('Office 2007 XLSX Document')

36	->setDescription('Document for Office 2007 XLSX, generated using PHP classes.')

37	->setKeywords('office 2007 openxml php')

38	->setCategory('Result file');

39	$objPHPExcel->setActiveSheetIndex(0)

40	->setCellValue('A1','ID')

41	->setCellValue('B1','用户名')

42	->setCellValue('C1','密码')

43	->setCellValue('D1','地址');

44

45

$i=2;

46	foreach($data as $k=>$v){

47	$objPHPExcel->setActiveSheetIndex(0)

48	->setCellValue('A'.$i,$v['id'])

49	->setCellValue('B'.$i,$v['username'])

50	->setCellValue('C'.$i,$v['password'])

51	->setCellValue('D'.$i,$v['address']);

52

$i++;

53

}

54	$objPHPExcel->getActiveSheet()->setTitle('三年级2班');

55	$objPHPExcel->setActiveSheetIndex(0);

56	$filename=urlencode('学生信息统计表').'_'.date('Y-m-dHis');

57

58	//生成xlsx文件

59

/*

60	header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

61	header('Content-Disposition: attachment;filename="'.$filename.'.xlsx"');

62	header('Cache-Control: max-age=0');

63	$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

64

*/

65

66

//生成xls文件

67	header('Content-Type: application/vnd.ms-excel');

68	header('Content-Disposition: attachment;filename="'.$filename.'.xls"');

69	header('Cache-Control: max-age=0');

70	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

71

72	$objWriter->save('php://output');

73

exit;