It is a custom spreadsheet, it has a checkbox to indicate a Male or a Female and I wish I could read those values using PHP since it is a webbased app.
I only ticked this settings right now, hoping I will get notified later on.
It looks like there is no way to read the value of a checkbox in an excel sheet if it is not link to a cell. I guess I've stumbled into one of the limitations of php.
EDIT: I didn't receive any notification in my email that someone replied to my thread, is that normal? I think I've subscribed to my own thread when I created it.
I am using PhpSpreadsheet to read the values of an excel file and I have no problem reading the values of columns. What I am having problem with is reading a value of a checkbox found in the excel sheet, is it even possible to read a checkbox value in excel using PHP? Here is one of my attempts but it cannot find any checkbox though it is there.
$drawingCollection = $sheet1->getDrawingCollection();
// Check if the drawing collection is empty
if (empty($drawingCollection)) {
echo 'No drawing objects found in worksheet' . PHP_EOL;
} else {
// Loop through the drawing objects
foreach ($drawingCollection as $drawing) {
// Check if the drawing object is a Form Control
if ($drawing instanceof Drawing\FormControl) {
// Get the cell containing the Form Control
$controlCell = $drawing->getCoordinates();
// Get the value of the Form Control
$value = $sheet1->getCell($controlCell)->getValue();
// Do something with the value
echo 'Control value: ' . $value . PHP_EOL;
}
}
}
Thank you for any one who could provide help.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.