PHPExcel implementation code for reading Excel files_PHP tutorial

Knowledge points involved:

php reads excel files in a loop

php converts characters into ascii encoding and converts characters into decimal numbers

php reads excel date format Get and perform display conversion

php encodes and converts 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 is 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 output 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";
?>

http://www.bkjia.com/PHPjc/324678.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/324678.htmlTechArticleInvolved knowledge points: php loops to read the excel file, php performs ascii encoding conversion of the characters, and converts the characters into Decimal number php reads excel date format, and displays and converts php to Chinese...