php生成excel文件并输出到浏览器
本文介绍了php spreadsheet_excel_writer与如何生成excel文件.
看一个实例,myfile.xls是文件名,包括路径,工作簿包含一个具有学生名单表,PHP实例代码如下:
<?php require_once 'spreadsheet/excel/writer.php' ; // creating workbook $workbook = new spreadsheet_excel_writer( 'myfile.xls' ); // adding worksheet $worksheet =& $workbook ->addworksheet( 'students' ); // data input $worksheet ->write(0, 0, 'name' ); $worksheet ->write(0, 1, 'grade' ); $worksheet ->write(1, 0, 'ivancho' ); $worksheet ->write(1, 1, 7); $worksheet ->write(2, 0, 'mariika' ); $worksheet ->write(2, 1, 7); $worksheet ->write(3, 0, 'stoyancho' ); $worksheet ->write(3, 1, 8); // saving file $workbook ->close(); ?>下面来看一款把数据导出给用户保存吧,代码如下:
<?php require_once 'spreadsheet/excel/writer.php' ; // creating workbook $workbook = new spreadsheet_excel_writer(); // sending headers to browser $workbook ->send( 'students.xls' ); // adding worksheet $worksheet =& $workbook ->addworksheet( 'students' ); // data input $worksheet ->write(0, 0, 'name' ); $worksheet ->write(0, 1, 'grade' ); $worksheet ->write(1, 0, 'ivancho' ); $worksheet ->write(1, 1, 7); $worksheet ->write(2, 0, 'mariika' ); $worksheet ->write(2, 1, 7); //开源代码phpfensi测试数据 $worksheet ->write(3, 0, 'stoyancho' ); $worksheet ->write(3, 1, 8); // sending the file $workbook ->close(); ?>查看更多关于php生成excel文件并输出到浏览器 - php高级应用的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did30419