load($_FILES['file']['tmp_name']);
//$lastRow = $spreadsheet->getHighestDataRow();
//echo $lastRow;
$worksheet = $spreadsheet->getActiveSheet(2);
// Get the highest row and column numbers referenced in the worksheet
$highestRow = $worksheet->getHighestRow(); // e.g. 10
$highestColumn = $worksheet->getHighestColumn(); // e.g 'F'//$highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); // e.g. 5
echo 'hrow='.$highestRow.' hcol'.$highestColumn ;
$col='K';
$row=6;
echo '| ' .
$worksheet->getCell($col . $row)
->getValue() .
' | ' . PHP_EOL;
//$cellValue = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(1, 4)->getCalculatedValue();
//echo $cellValue;
//$cellValue = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(6, 5)->getValue();
//echo $cellValue;
// $cellValue = $spreadsheet->getActiveSheet()->getCell('A11')->getValue();
// echo 'my cell value='.$cellValue.'===';
$sheetData = $spreadsheet->getActiveSheet()->toArray();
if (!empty($sheetData)) {
for ($i=1; $iquery("UPDATE tbl_pay_employee_payscheme set STATUS=0 WHERE ID=$dn");
// $db->query("INSERT INTO USERS(name, email, company) VALUES('$name', '$email', '$company')");
}
}
$sll=0;
if (!empty($sheetData)) {
for ($i=1; $iquery("UPDATE tbl_pay_employee_payscheme set STATUS=1 WHERE ID=$dn");
$sll=$sll+1;
}
// $db->query("INSERT INTO USERS(name, email, company) VALUES('$name', '$email', '$company')");
}
}
echo "Records inserted successfully.";
} else {
echo "Upload only CSV or Excel file.";
}
}
?>