用<em>php</em>excel怎么导出excel文件-excel导入导出 php,exce

下载phpexcel类库 代码e68a84e799bee5baa6364如下：
<?php
require_once('PHPExcel.php');
require_once('PHPExcel/IOFactory.php');
$objPHPExcel=new PHPExcel();
$iofactory=new IOFactory();
//获得数据 ---一般是从数据库中获得数据
$data=array(
0=>array('id'=>2013,'name'=>'张某某','age'=>21),
1=>array('id'=>201,'name'=>'EVA','age'=>21)
);
//设置excel列名
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1','编号');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1','姓名');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1','年龄');
//把数据循环写入excel中
foreach($data as $key => $value){
$key+=2;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$key,$value['id']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$key,$value['name']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$key,$value['age']);
}
//excel保存在根目录下 如要导出文件，以下改为注释代码
$objPHPExcel->getActiveSheet() -> setTitle('SetExcelName');
$objPHPExcel-> setActiveSheetIndex(0);
$objWriter = $iofactory -> createWriter($objPHPExcel, 'Excel2007');
$objWriter -> save('SetExcelName.xlsx');
//导出代码
// $objPHPExcel->getActiveSheet() -> setTitle('SetExcelName');
// $objPHPExcel-> setActiveSheetIndex(0);
// $objWriter = $iofactory -> createWriter($objPHPExcel, 'Excel2007');
// $filename = 'SetExcelName.xlsx';
// header('Content-Type: application/vnd.ms-excel');
// header('Content-Type: application/octet-stream');
// header('Content-Disposition: attachment; filename="' . $filename . '"');
// header('Cache-Control: max-age=0');
// $objWriter -> save('php://output');
?>

下载phpexcel类库 代码如下：
<?php
require_once('PHPExcel.php');
require_once('PHPExcel/IOFactory.php');
$objPHPExcel=new PHPExcel();
$iofactory=new IOFactory();
//获得数据636f7079e799bee5baa6e997aee7ad94336 ---一般是从数据库中获得数据
$data=array(
0=>array('id'=>2013,'name'=>'张某某','age'=>21),
1=>array('id'=>201,'name'=>'EVA','age'=>21)
);
//设置excel列名
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1','编号');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1','姓名');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1','年龄');
//把数据循环写入excel中
foreach($data as $key => $value){
$key+=2;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$key,$value['id']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$key,$value['name']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$key,$value['age']);
}
//excel保存在根目录下 如要导出文件，以下改为注释代码
$objPHPExcel->getActiveSheet() -> setTitle('SetExcelName');
$objPHPExcel-> setActiveSheetIndex(0);
$objWriter = $iofactory -> createWriter($objPHPExcel, 'Excel2007');
$objWriter -> save('SetExcelName.xlsx');
//导出代码
// $objPHPExcel->getActiveSheet() -> setTitle('SetExcelName');
// $objPHPExcel-> setActiveSheetIndex(0);
// $objWriter = $iofactory -> createWriter($objPHPExcel, 'Excel2007');
// $filename = 'SetExcelName.xlsx';
// header('Content-Type: application/vnd.ms-excel');
// header('Content-Type: application/octet-stream');
// header('Content-Disposition: attachment; filename="' . $filename . '"');
// header('Cache-Control: max-age=0');
// $objWriter -> save('php://output');
?>
给你一段我用过的程序，你调试一下
三个文件，希望能帮上点忙
1. <?php
2. //加载EXCEL操作类
3. require_once './excel_class.php';
4.
5. //加载EXCEL文件Sheet1名
6. $file_sheet = "Sheet1";
7. Read_Excel_File("test.xls",$return);
8.
9. //$return[$file_sheet]返回EXCEL行数
10. for ($i=0;$i<count($return[$file_sheet]);$i++)
11. {
12. echo "<tr>";
13. for ($j=0;$j<count($return[$file_sheet][$i]);$j++)
14. {
15. echo "<td>".$return[$file_sheet][$i][$j]."</td>";
16. }
17. echo "</tr>";
18. }
19. ?>

1. <?php
2. //这里的7a64e78988e69d83364$i=0是指定读取起始行数
3. for ($i=0;$i<count($return[$file_sheet]);$i++)
4. {
5. echo "<tr>";
6. for ($j=0;$j<count($return[$file_sheet][$i]);$j++)
7. {
8. echo "<td>".$ascii->decode($return[$file_sheet][$i][$j])."</td>";
9. }
10. echo "</tr>";
11. }
12. ?>

1. class ascii
2. {
3. function decode($str) {
4. $flag = "&#";
5. $pos = strpos($str, $findme);
6. if($pos === FALSE) {
7. return $str;
8. }else{
9. preg_match_all("/([0-9]{2,5})/", $str,$a);
10. $a = $a[0];
11. foreach ($a as $dec){
12. if ($dec < 128) {
13. $utf .= chr($dec);
14. } else if ($dec < 2048) {
15. $utf .= chr(192 + (($dec - ($dec % 64)) / 64));
16. $utf .= chr(128 + ($dec % 64));
17. } else {
18. $utf .= chr(224 + (($dec - ($dec % 4096)) / 4096));
19. $utf .= chr(128 + ((($dec % 4096) - ($dec % 64)) / 64));
20. $utf .= chr(128 + ($dec % 64));
21. }
22. }
23. return $utf;
24. }
25. }
26. }

下载e69da5e887aa7a64364phpexcel
require '/api/PHPExcel.php';//加载phpexcel
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getDefaultStyle()->getFont()->setName( '微软雅黑');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(14);
$objPHPExcel->getActiveSheet()->getStyle("A1:L1")->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle("A1:L1")->getFont()->setBold(TRUE);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->getStartColor()->setARGB('FF6FA0EC');

$ths=array('A1','B1');
$objPHPExcel->getActiveSheet()->setCellValue('A1', '用户名');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '密码');

$objPHPExcel->getActiveSheet()->getColumnDimension( 'A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension( 'B')->setWidth(12);
$size=count($passwords);
if($passwords){
for($i=0;$i<$size;$i++){
$objPHPExcel->getActiveSheet()->setCellValue("A".($i+2), $lists[$i]['username']);
$objPHPExcel->getActiveSheet()->setCellValue("B".($i+2), $lists[$i]['mima']);
}
}
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('Excel表');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$outputFileName = "fileaname";//文件名字
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.iconv('UTF-8','GB18030',$outputFileName).'.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0
//$objWriter->save(DT_ROOT.'file/cache/');
$objWriter->save('php://output');