用php创建excel文件的简单方法

Nov

2006

大家都知道 phpMyAdmin 可以把数据导出为 Excel 格式，但是phpMyAdmin 只能导出 .csv 格式的文件,不算真正的excel格式. 如果你对PHP的变成感兴趣，还需要导出真正的excel格式，那就好好看一下下面的了：

导出XLS格式的文件的PHP例子

1. 创建关于创建XLS文件的函数

2. 向浏览器发出文件头以下载文件.

   // Query Database
    $result=mysql_db_query($dbname,"select id,prename,name,sname,grade from appdata where course='$courseid' and sec='$section'")

    // Send Header
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");;
    header("Content-Disposition: attachment;filename=$courseid-$sec.xls "); //这里可以指定文件名
    header("Content-Transfer-Encoding: binary ");

    // 输出XLS 数据单元

    xlsBOF();
    xlsWriteLabel(1,0,"Student Register $semester/$year");
    xlsWriteLabel(2,0,"COURSENO : ");
    xlsWriteLabel(2,1,"$courseid");
    xlsWriteLabel(3,0,"TITLE : ");
    xlsWriteLabel(3,1,"$title");
    xlsWriteLabel(4,0,"SETION : ");
    xlsWriteLabel(4,1,"$sec");
    //空一行，下面写单元格对应的标签
    xlsWriteLabel(6,0,"NO");
    xlsWriteLabel(6,1,"ID");
    xlsWriteLabel(6,2,"Gender");
    xlsWriteLabel(6,3,"Name");
    xlsWriteLabel(6,4,"Lastname");
    $xlsRow = 7;
    //输出具体数据
    while(list($id,$prename,$name,$sname,$grade)=mysql_fetch_row($result)) {
        ++$i;
              xlsWriteNumber($xlsRow,0,"$i");
              xlsWriteNumber($xlsRow,1,"$id");
              xlsWriteLabel($xlsRow,2,"$prename");
              xlsWriteLabel($xlsRow,3,"$name");
              xlsWriteLabel($xlsRow,4,"$sname");
        $xlsRow++;
        }
     xlsEOF();
     exit();

翻译：aslibra.com

原文：http://www.appservnetwork.com/modules.php?name=News&file=article&sid=8

原创内容如转载请注明：来自阿权的书房

收藏本文到网摘

cjs