Use phpexcel to read xls documents

Phpexcel provides many methods to read xls files. I am using the phpexcel class, and I am also wondering that the downloaded files are quite large, even if [img] [/img] is what netizens say, the size is 18 MB. let's see how phpexcel reads xls files. Php code? Re phpexcel reads xls files
There are many ways to read xls files. we can master one of them. I am using the phpexcel class, and I am also wondering that the downloaded files are quite large, even if [img] [/img] is what netizens say, the size is 18 MB. let's see how phpexcel reads xls files.
Php code?

1. Require? 'Excel/PHPExcel. php ';? // Load the file ??
2. ?? $ Filename = "D:/wamp/www/test/sysoa.xls ";??
3. ? // Read the xls files of Version 2003 and earlier versions ??
4. $ Phpreader =New? PHPExcel_Reader_Excel5 ();??
5. If($ Phpreader-> canRead ($ filename )){??
6. ??
7. ???? $ Excel = $ phpreader-> load ($ filename );??
8. ???? // Get the current worksheet ??
9. ?? ??
10. ???? $ Cursheet = $ excel-> getSheet (0 );??
11. ???? // How many columns are obtained. if this static method is not used, the obtained $ col is the maximum uppercase letter of the file column ??
12. ???? $ Col = PHPExcel_Cell: columnIndexFromString ($ cursheet-> getHighestColumn ());??
13. ???? ??
14. ???? // How many rows are obtained ??
15. ???? $ Row = $ cursheet-> getHighestRow ();??
16. ??
17. ???? // Obtain data cyclically. The xls file is expressed in B2 ??
18. ??
19. ????For($ Currow = 1; $ currow <= $ row; $ currow ++ ){??
20. ??????For($ Curcol = 1; $ curcol <= $ col; $ curcol ++ ){??
21. ??????????? $ Result = $ cursheet-> getCellByColumnAndRow ($ curcol, $ currow)-> getValue ();??
22. ???????????If($ Result ){??
23. ??????????? Echo? 'Column '. $ currow.' Row '. $ curcol.': '. $ result .'';??
24. ???????????} ??
25. ??????} ??
26. ?????? Echo? '
    ';??
27. ????} ??
28. ????? ??
29. }??

Require 'Excel/PHPExcel. php '; // load the file $ filename = "D:/wamp/www/test/sysoa.xls "; // read the xls files of Version 2003 and earlier $ phpreader = new PHPExcel_Reader_Excel5 (); if ($ phpreader-> canRead ($ filename )) {$ excel = $ phpreader-> load ($ filename); // Obtain the current worksheet $ cursheet = $ excel-> getSheet (0); // obtain the total number of columns, if you do not use this static method, the obtained $ col is the largest capital letter in the file column $ col = PHPExcel_Cell: columnIndexFromString ($ cursheet-> getHighestColumn ()); // obtain the total number of rows $ row = $ cursheet-> getHighestRow (); // Obtain data cyclically. The xls file is a column after it is placed forward, such as the second column in the first row, in fact, xls is expressed in B2. for ($ currow = 1; $ currow <= $ row; $ currow ++) {for ($ curcol = 1; $ curcol <= $ col; $ curcol ++) {$ result = $ cursheet-> getCellByColumnAndRow ($ curcol, $ currow)-> getValue (); if ($ result) {echo 'did '. $ currow. 'row name '. $ curcol. 'column :'. $ result. '';} echo'
';}}

? But there are still some problems that have not been solved. when I read another xls file, $ row = $ cursheet-> getHighestRow (); actually got 65522, which is really confusing, but another one is better. The first floor pz9042 2012-06-06... This is what I wrote ..