PHP Import Excel file Tips _php Tutorial

Everyone to

Examples of PHP import Excel file code are as follows:

2. < ? PHP
4. Require_once '. /excel/reader.php ';
6. Excelfile ($filename, $encoding);
8. $ Data = New Spreadsheet_excel_reader ();
10. Set output Encoding. Specify Chinese code
12. $data- > setoutputencoding (' gb2312 ');
14. /***
16. * If you want your can change '
    Iconv ' to mb_convert_encoding:
18. * $data- > setutfencoder (' MB ');
20. **//***
22. * By default rows & cols indeces start with 1
24. * For change initial index use:
26. * $data- > setrowcoloffset (0);
28. **/
30. /***
32. * Some function for formatting output.
34. * $data- > Setdefaultformat ('%.2f ');
36. * Setdefaultformat-set format for
    Columns with unknown formatting
38. * $data- > Setcolumnformat (4, '%.3f ');
40. * Setcolumnformat-set format for
    Column (apply only to number fields)
42. **/
44. Specify the Excel file to read
46. $data- > read ('.. /uploads/jsxz01.xls ');
48. /*
50. $data- > sheets[0][' NumRows ']-count rows
52. $data- > sheets[0][' Numcols ')-Count columns
54. $data- > sheets[0][' cells ' [$i] [$j]-Data
    From $i-row $j-column
56. $data- > sheets[0][' Cellsinfo ' [$i] [$j]-
    Extended info about cell
58. $data- > sheets[0][' Cellsinfo ' [$i] [$j] [' type ']
    = "Date" | "Number" | "Unknown"
60. If ' type ' = = ' unknown '-use ' raw ' value,
    Because cell contain value with Format ' 0.00 ';
62. $data- > sheets[0][' Cellsinfo ' [$i] [$j] [' Raw ']
    = value if cell without format
64. $data- > sheets[0][' Cellsinfo ' [$i] [$j] [' colspan ']
66. $data- > sheets[0][' Cellsinfo ' [$i] [$j] [' rowspan ']
68. */
70. Error_reporting (e_all ^ e_notice);
72. Iterate through each cell value
74. For ($i = 1; $i < = $data-> Sheets[0]
    [' NumRows ']; $i + +) {
76. For ($J = 1; $j < = $data-> Sheets[0]
    [' Numcols ']; $j + +) {
78. echo "". $data- > sheets[0][' cells ']
    [$i] [$j]. "", ";
80. }
82. echo " < br>";
84. }
86. Print_r ($data);
88. //print_r ($data->formatrecords);
90. ?>

Hope that the above PHP import Excel file Implementation code can help us to this knowledge point has a deep understanding.

http://www.bkjia.com/PHPjc/446095.html www.bkjia.com true http://www.bkjia.com/PHPjc/446095.html techarticle Examples of PHP import Excel file code are as follows: Php require_once '. /excel/reader.php '; Excelfile ($filename, $encoding); $ data = new Spreadsheet_excel_reader (); Setoutputen ...

