Excel 2007 official download free full version PHPExcel implementation code for reading Excel files

Knowledge points involved:
php reads excel files in a loop
php performs ascii encoding and conversion of characters and converts characters into decimal numbers
php reads excel date format and performs display conversion
php performs encoding and conversion of garbled Chinese characters

Copy the code The code is as follows:

require_once 'PHPExcel.php';
/**Convert date format in excel*/
function GetData($val){
$jd = GregorianToJD(1, 1, 1970);
$gregorian = JDToGregorian($jd+intval($val)-25569);
return $gregorian;/**The display format is "month/day/year"*/
}
$filePath = 'test.xlsx';
$ PHPExcel = new PHPExcel();
/**By default, excel2007 is used to read excel. If the format is incorrect, the previous version will be used to read it.*/
$PHPReader = new PHPExcel_Reader_Excel2007();
if(!$PHPReader->canRead($filePath)){
$PHPReader = new PHPExcel_Reader_Excel5();
if(!$PHPReader->canRead($filePath)){
echo 'no Excel';
return ;
}
}
$PHPExcel = $PHPReader->load($filePath);
/**Read the first worksheet in excel file*/
$currentSheet = $PHPExcel->getSheet(0);
/**Get the largest column number*/
$allColumn = $currentSheet->getHighestColumn();
/**Get the total number of rows*/
$allRow = $currentSheet->getHighestRow();
/**Start outputting from the second row because the first row in the excel table is the column name*/
for($currentRow = 2;$currentRow <= $allRow;$currentRow++){
/**Start output from column A*/
for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){
$val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue(); /**ord() converts characters into decimal numbers*/
if($currentColumn == 'A')
{
echo GetData($val)."t";
}else{
//echo $val;
/**If the output Chinese characters are garbled, you need to use the iconv function to convert the output content. As follows, convert gb2312 encoding to utf-8 encoding for output.*/
echo iconv('utf-8','gb2312', $val)."t";
}
}
echo "
";
}
echo "n";
?> ;

The above introduces the implementation code of excel 2007 official download free full version PHPExcel to read Excel files, including the content of excel 2007 official download free full version. I hope it will be helpful to friends who are interested in PHP tutorials.