PHP Spreadsheet - Get Underline effect

Asked Aug 18 '21 at 06:32

Active Aug 18 '21 at 06:44

Viewed 215 times

I need to check a cell with the effect underline or not.

I'm trying this code:

$reader1 = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
$workbook1 = $reader1->load($file1);

$worksheet1 = $workbook1->getSheet(0);
                        
$cellunderline = $worksheet1->getCellByColumnAndRow(1, 1)->getStyle()->getFont()->getUnderline();

if($cellunderline){
   // The cell is underline true
}

I have testing with the $cellunderline with the value:

And also I have testing with the $cellundeline value:

The problem is always the $cellunderline is true. I have tried to set the result of $cellunderline in a new cell to see the value but it's empty in the document.

I'm not sure what is happen and why is not working.

Please Could you help me with this issue?

I use the php library phpspreadsheet. The documentation here.

edited Aug 18 '21 at 06:40

asked Aug 18 '21 at 06:32

ruzD

What `$cellunderline` containe? – Simone Rossaini Aug 18 '21 at 06:34
Sorry @SimoneRossaini. I have edited the post. I have testing with underline = true and underline = false. – ruzD Aug 18 '21 at 06:41
if you do `print_r($cellunderline)`, what that print? – Simone Rossaini Aug 18 '21 at 06:43
Shows 'none' word – ruzD Aug 18 '21 at 06:50
Look my answer. – Simone Rossaini Aug 18 '21 at 06:52
It's not correct but always shows none result. With the underline effect and without underline effect in the cell :( – ruzD Aug 18 '21 at 06:53
1

Take a look [here](https://stackoverflow.com/questions/54877074/getunderline-of-excel-cellcontent-using-phpspreadsheet) – Simone Rossaini Aug 18 '21 at 06:58

PHP Spreadsheet - Get Underline effect

0 Answers0