dee-u

The web app needs to import the excel file and read its values.

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.