first of all, the imported table is calculated with the formula (the values of many columns are calculated by the formula). There is no problem, but after import, it is found that the value of some columns is-sharpVALUE! (not all the columns calculated by the formula). The reason is that the value of an item in the formula is empty (not 0), which will lead to phpexcel unable to read the value.

here is the read method:

$objPHPExcel = $PHPReader- > load ($file);
$data=$objPHPExcel- > getActiveSheet ($sheet)-> toArray ();

here $data has been read out and is a two-dimensional array.

excuse me:

1. Through the above method, how to avoid not reading the value because of the null value in the formula?
2. If the above method cannot be modified, do you want to change the read method? Ask for recommendation! -sharp-sharp-sharp topic description