Open salterping opened 6 years ago
$PHPReader = new \PHPExcel_Reader_Excel2007(); $newFile = "520.xlsx"; $PHPExcel = $PHPReader->load($newFile); $currentSheet = $PHPExcel->getSheet(0); for ($rowIndex = 1; $rowIndex <= 100; $rowIndex ++) { $buyerNick = 'A' . $rowIndex; $buyerNickCell = $currentSheet->getCell($buyerNick)->getValue(); exit(var_dump($buyerNickCell)); } 520.xlsx
$PHPReader = new \PHPExcel_Reader_Excel2007(); $newFile = "520.xlsx"; $PHPExcel = $PHPReader->load($newFile); $currentSheet = $PHPExcel->getSheet(0); for ($rowIndex = 1; $rowIndex <= 100; $rowIndex ++) { $buyerNick = 'A' . $rowIndex; $buyerNickCell = $currentSheet->getCell($buyerNick)->getValue(); exit(var_dump($buyerNickCell)); }
A1 is 84.4, the echo is 84.40000000000001
// Check for numeric values if (is_numeric($value) && $cellDataType != 's') { if ($value == (int)$value) $value = (int)$value; elseif ($value == (float)$value) $value = (float)$value; elseif ($value == (double)$value) $value = (double)$value; } this code is convert string to float so 84.4 => 84.40000000000001
// Check for numeric values if (is_numeric($value) && $cellDataType != 's') { if ($value == (int)$value) $value = (int)$value; elseif ($value == (float)$value) $value = (float)$value; elseif ($value == (double)$value) $value = (double)$value; }
$PHPReader = new \PHPExcel_Reader_Excel2007(); $newFile = "520.xlsx"; $PHPExcel = $PHPReader->load($newFile); $currentSheet = $PHPExcel->getSheet(0); for ($rowIndex = 1; $rowIndex <= 100; $rowIndex ++) { $buyerNick = 'A' . $rowIndex; $buyerNickCell = $currentSheet->getCell($buyerNick)->getValue(); exit(var_dump($buyerNickCell)); }520.xlsxA1 is 84.4, the echo is 84.40000000000001
// Check for numeric values if (is_numeric($value) && $cellDataType != 's') { if ($value == (int)$value) $value = (int)$value; elseif ($value == (float)$value) $value = (float)$value; elseif ($value == (double)$value) $value = (double)$value; }this code is convert string to float so 84.4 => 84.40000000000001