1

Currently I'm using PHPOffice library for importing my data from a excel spreadsheet. My excel spreadsheet is a little special, there is a cell having multiple styles.

I can get styles like font-size, font-weight, etc. But can't get color.

When I import .xlsx file, all color values would be #000000. When I import .xls file, all color values would be different color values. For example, #FF0000 -> #00FF00, #00FF00 -> #0000FF, #0000FF -> #000000

Heres my code

$inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($inputFileName);
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
$spreadsheet = $reader->load($inputFileName);
$cellValue = $spreadsheet->getActiveSheet()->getCell('A1')->getValue();

if ($cellValue instanceof \PhpOffice\PhpSpreadsheet\RichText\RichText) {
    foreach ($cellValue->getRichTextElements() as $richTextElement) {
        var_dump($richTextElement->getText());
        if ($richTextElement->getFont()) {
            var_dump($richTextElement->getFont()->getColor()->getRGB());
            var_dump($richTextElement->getFont()->getBold());
        }
    }
}
Yoshida J
  • 11
  • 1

0 Answers0