【PHP】メモ
833 ワード
include 'PHPExcel-1.7.7/PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($_FILES["file"]["tmp_name"]);
$sheets = $objPHPExcel->getAllSheets();
foreach ($sheets as $sheet) {
$data = $sheet->toArray();
unset($data[0]);
unset($data[1]);
foreach ($data as $s) {
for ($i = count($s) - 1; $i >= 0; $i--)
$s[$i] = addslashes($s[$i]);
$damagerate = sprintf('%.2f', floatval($s[9]));
}
}