Specific application of PHP reading Excel file class_PHP tutorial

In this article, we introduce in detail some code examples for

PHP to read Excel files:

1. < ?php
2. require_once '../Excel/reader.php';
3. // ExcelFile($filename, $encoding);
data
4. = new Spreadsheet_Excel_Reader(); // Set output Encoding. Specify Chinese code
5. $data-
6. >setOutputEncoding('gb2312'); /***   
7. * if you want you can change 'iconv'  to mb_convert_encoding:   
8. * $data-
   
9. >setUTFEncoder('mb');    *   
10. **/ 🎜>
/***   
* By default rows & cols indeces start with 1   
* For change initial index use:   
* $data-
>
15. setRowColOffset(0);    *   
**/
// Specify the excel file to be read
$data-
>
read('../uploads/jsxz01.xls');
20. /*  $data-
>
21. 
    sheets [0]['numRows'] - count rows
22. $data-
23. >sheets[0]['numCols'] - count columns $data-
24. 
    >
25. sheets[0]['cells'][$i][$j] - data from $i-row $j-column
26. $data -
27. >
28. sheets[0]['cellsInfo'][$i][$j] - extended info about cell $data-
>
sheets[0]['cellsInfo '][$i][$j]
30. ['type'] = "date" | "number" | "unknown" if 'type' == "unknown " - use 'raw' value, because cell contains value with format '0.00'; $data-
31. >sheets[0]['cellsInfo'][$i][$j] ['raw'] = value if cell without format
$data-
32. >sheets[0]['cellsInfo'][$i] [$j]['colspan']
33. $data->sheets[0] ['cellsInfo'][$i][$j]
    ['rowspan']
34. */
35. error_reporting(E_ALL ^ E_NOTICE);
36. // Loop to read each unit value
37. for ($i = 1; $i <= $data->sheets[0]
    ['numRows'] ; $i++) {
38. for ($j = 1 ; $j <= $data->sheets[0]
    ['numCols']; $j++) {
39. echo "" ".$data->sheets[0]['cells']
    [$i][$j ]."",";
40. }
41. echo "<br>"; 🎜>//print_r($data); 🎜>formatRecords);
43. ?> The above is all the usage of PHP to read Excel file class, as a reference object.
44. http://www.bkjia.com/PHPjc/446091.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446091.html
TechArticle
45. In this article we introduce in detail some code examples for PHP to read Excel files: ?php require_once'../Excel/reader.php'; //ExcelFile($filename,$encoding); $ data...