[QUESTION] How to retrieve text with bold and other style like italic?

[cod3rshotout]

Hi,
sorry to disturb you, but I don't understand how to read the text and get also the html tags to preserve bold and italics, could you please show me a little example?
Thanks in advance.

[shuchkin]

inline rich text unsupported

[Jim537]

A bit late getting to this thread - but this may be of interest to others with the same question.

Bold and italics can be applied to the CELL - or - to the TEXT within a CELL.
This is stored and recovered in different ways. CELL formatting can be recoverd with the code below which adds HTML tags to the cell contents. IN-CELL TEXT format recovery would need changes to the 'parseRichText' function.

$xlsx = SimpleXLSX::parse('test.xlsx')
$data = $xlsx->rows();
$r = -1;
foreach ($xlsx->sheets[0]->sheetData->row as $row) {      
    $r++;
    $c = -1;
    foreach ($row->c as $col) {
       $c++; 
       if(isset($col['s'])){ 
            $s = (int) $col['s']; 
            $cellXfs = $xlsx->styles->cellXfs->xf[$s];
            $fontID = (int) $cellXfs['fontId'];
            $b = $xlsx->styles->fonts->font[$fontID];
            if ( isset($b->b)){
                $data[$r][$c] = '<b>' . $data[$r][$c] . '</b>';
            } 
            if (isset($b->i)){
                $data[$r][$c] = '<i>' . $data[$r][$c] . '</i>';
            }
            if (isset($b->u)){
                $data[$r][$c] = '<u>' . $data[$r][$c] . '</u>';
            }
        }
    }
}

[shuchkin]

see rowsEx