PHP怎么读取Excel里面的数据？

phpExcelReader

楼主 明早到公司就发代码给你 不急。

楼主试试吧
<?phpfunction readExcel() { date_default_timezone_set ( 'UTC' ); //header("Content-type:application/vnd.ms-excel;charset=Shift_JIS");
$ex = new COM ( "Excel.sheet" ); $ms_excel = new COM ( "excel.application" ) or die ( "You can not open the Excel application. " ); $workbook = "C:/xampp/htdocs/uploadExcel/test.xls"; //open workbook $book = $ex->application->Workbooks->Open ( $workbook ); //select worksheet index $sheets = $book->Worksheets ( 1 ); $sheets->activate; //Loop read the value $cell = $sheets->Cells ( 1, 1 ); $cell->activate; echo "excelValue: " . $cell->value; //closeExcel $ex->Application->ActiveWorkbook->Close ( "False" ); unset ( $ex );}
?>

这个 是什么意思 ？
是不是需要引入别的东西？
还请指导一下怎么使用

在C盘下新建文件a.xlsx，然后再（A,1）单元格中，写入测试值"abc",复制php文件，运行代码，就可以在页面中，输出"abc"

<?php header("Content-type:application/vnd.ms-excel;charset=utf-8");readExcel();function readExcel() { date_default_timezone_set ( 'UTC' ); $ex = new COM ( "Excel.sheet" ); $ms_excel = new COM ( "excel.application" ) or die ( "You can not open the Excel application. " ); $workbook = "C:\a.xlsx"; $book = $ex->application->Workbooks->Open ( $workbook ); $sheets = $book->Worksheets ( 1 ); $sheets->activate; // Loop read the value $cell = $sheets->Cells ( 1, 1 ); $cell->activate; echo "excelValue: " . $cell->value; // closeExcel $ex->Application->ActiveWorkbook->Close ( "False" ); unset ( $ex );}
?>