Re: Getting the background color of a cell in an existing Excel spreadsheet

<shameless plug>Use Spreadsheet::Read. In this example I also use Data::Peek</shameless plug>

$ perl -MSpreadsheet::Read -MDP -wE'DDumper (ReadData("attr.xls",attr=
+>1)->[1]{attr}[4][3])'
{   bgcolor          => '#0000ff',
    bold             => 0,
    enc              => undef,
    fgcolor          => '#008000',
    font             => 'Arial',
    format           => undef,
    formula          => undef,
    halign           => undef,
    hidden           => 0,
    italic           => 0,
    locked           => 1,
    merged           => 0,
    size             => 10,
    type             => 'text',
    uline            => 0,
    valign           => 'bottom',
    wrap             => 0
    }
[download]

Enjoy, Have FUN! H.Merijn

Comment on Re: Getting the background color of a cell in an existing Excel spreadsheet Download Code