PHP读取Excel文件类的具体应用_PHP教程

PHP读取Excel文件类代码示例：

1. < ?php
2. require_once '../Excel/reader.php';
3. // ExcelFile($filename, $encoding);
4. $data = new Spreadsheet_Excel_Reader();
5. // Set output Encoding.指定中文码
6. $data->setOutputEncoding('gb2312');
7. /***
8. * if you want you can change 'iconv'
   to mb_convert_encoding:
9. * $data->setUTFEncoder('mb');
10. *
11. **/
12. /***
13. * By default rows & cols indeces start with 1
14. * For change initial index use:
15. * $data->setRowColOffset(0);
16. *
17. **/
18. /***
19. * Some function for formatting output.
20. * $data->setDefaultFormat('%.2f');
21. * setDefaultFormat - set format for
    columns with unknown formatting
22. *
23. * $data->setColumnFormat(4, '%.3f');
24. * setColumnFormat - set format for
    column (apply only to number fields)
25. *
26. **/
27. // 指定读取的excel文件
28. $data->read('../uploads/jsxz01.xls');
29. /*
30. $data->sheets[0]['numRows'] - count rows
31. $data->sheets[0]['numCols'] - count columns
32. $data->sheets[0]['cells'][$i][$j] -
    data from $i-row $j-column
33. $data->sheets[0]['cellsInfo'][$i][$j] -
    extended info about cell
34. $data->sheets[0]['cellsInfo'][$i][$j]
    ['type'] = "date" | "number" | "unknown"
35. if 'type' == "unknown" - use 'raw'
    value, because cell contain value with
    format '0.00';
36. $data->sheets[0]['cellsInfo'][$i][$j]
    ['raw'] = value if cell without format
37. $data->sheets[0]['cellsInfo'][$i][$j]
    ['colspan']
38. $data->sheets[0]['cellsInfo'][$i][$j]
    ['rowspan']
39. */
40. error_reporting(E_ALL ^ E_NOTICE);
41. // 循环读取每一个单元值
42. for ($i = 1; $i <= $data->sheets[0]
    ['numRows']; $i++) {
43. for ($j = 1; $j <= $data->sheets[0]
    ['numCols']; $j++) {
44. echo """.$data->sheets[0]['cells']
    [$i][$j]."",";
45. }
46. echo "<br>";
47. }
48. //print_r($data);
49. //print_r($data->formatRecords);
50. ?>

以上就是PHP读取Excel文件类的全部用法，作为一个参考对象。

http://www.bkjia.com/PHPjc/446091.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/446091.htmlTechArticle我们在这篇文章中为大家详细介绍了一些有关 PHP读取Excel文件类代码示例： ?php require_once'../Excel/reader.php'; //ExcelFile($filename,$encoding); $ data...