How to get cell location in case of an error and print in catch block

[saginadav]

Hey All I am new to phpoffice.
I created a csv with data I get from the server.
I used loops to enter the data.
this is how I enter the data

try {
                                $sheet->setCellValueExplicit($cell,$innervalue, $dataType[0]);
                                //If the exception is thrown, this text will not be shown
                                
                              }

My question is if in one cell the data can not be entered, and get exception. is their a way to display what is the problematic data? and what is the cell position?
since if I create very bid xls, and get this exception I can not know which data is problematic. I just want to know the cell position?
How I can print the $cell and $innervalue? if I get exception?

[2022-03-01 09:18:36] local.ERROR: Invalid numeric value for datatype Numeric {"exception":"[object] (PhpOffice\\PhpSpreadsheet\\Exception(code: 0): Invalid numeric value for datatype Numeric at C:\\xampp\\htdocs\\vendor\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Cell\\Cell.php:215)
[stacktrace]

how in the catch I can add this additional data?

[MarkBaker]

Basic PHP:

try {
    $sheet->setCellValueExplicit($cell,$innervalue, $dataType[0]);
    //If the exception is thrown, this text will not be shown
} catch (Exception $e) {
    echo "Failed to add cell {$cell} with value {$innervalue} with Exception ', $e->getMessage();
}

[saginadav]

this is what finally worked

try {                      
                              $sheet->setCellValueExplicit($cell,$innervalue, $dataType[0]);
                              }
                              catch (\Exception $e) {
                                $errorMsg = 'the value of:\' '  .$innervalue . '\' in cell ' .  $cell .  ' in header: ' . $headerArray[$headerIndex] . 'problematic'  ;
                                \Log::error($errorMsg);
                                \Log::error($e->getMessage()); 
                                \Log::error($e->getTraceAsString());  
                                throw new Exception($e->getMessage());
                              
                              }