本文介紹了php spreadsheet_excel_writer與如何生成excel文件.

第一步,安裝spreadsheet_excel_writer 由于這包使用ole包,您可能需要安裝它,執(zhí)行以下命令來執(zhí)行更新:更新pear.php.net ole - 0.5 spreadsheet_excel_writer - 0.9.1

看一個實例,myfile.xls是文件名,包括路徑,工作簿包含一個具有學生名單表,PHP實例代碼如下:

1. <?php 
2. require_once 'spreadsheet/excel/writer.php'; 
3. // creating workbook 
4. $workbook = new spreadsheet_excel_writer('myfile.xls'); 
5. // adding worksheet 
6. $worksheet =& $workbook->addworksheet('students'); 
7. // data input 
8. $worksheet->write(0, 0, 'name'); 
9. $worksheet->write(0, 1, 'grade'); 
10. $worksheet->write(1, 0, 'ivancho'); 
11. $worksheet->write(1, 1, 7); 
12. $worksheet->write(2, 0, 'mariika'); 
13. $worksheet->write(2, 1, 7); 
14. $worksheet->write(3, 0, 'stoyancho'); 
15. $worksheet->write(3, 1, 8); 
16. // saving file 
17. $workbook->close(); 
18. ?> 

下面來看一款把數(shù)據(jù)導出給用戶保存吧,代碼如下:

1. <?php 
2. require_once 'spreadsheet/excel/writer.php'; 
3. // creating workbook 
4. $workbook = new spreadsheet_excel_writer(); 
5. // sending headers to browser 
6. $workbook->send('students.xls'); 
7. // adding worksheet 
8. $worksheet =& $workbook->addworksheet('students'); 
9. // data input 
10. $worksheet->write(0, 0, 'name'); 
11. $worksheet->write(0, 1, 'grade'); 
12. $worksheet->write(1, 0, 'ivancho'); 
13. $worksheet->write(1, 1, 7); 
14. $worksheet->write(2, 0, 'mariika'); 
15. $worksheet->write(2, 1, 7); 
16. //開源代碼Vevb.com 
17. $worksheet->write(3, 0, 'stoyancho'); 
18. $worksheet->write(3, 1, 8); 
19. // sending the file 
20. $workbook->close(); 
21. ?>