can't get all font properties #14

matrot opened this Issue Nov 29, 2013 · 2 comments


None yet
2 participants

matrot commented Nov 29, 2013


I try to get the font properties of a cell of an xlsx file, but it seems that the font properties returned aren't the same than for a xls file.
I would like to know if the font of my cell is Strikeout. The only font properties I can get are 'Bold', 'Height', 'Italic', 'Name' and 'Color'

her is my program to get the format of the first cell of the file :

use Spreadsheet::ParseXLSX;
use Data::Dumper;

my $parser=Spreadsheet::ParseXLSX->new();
my $xlsx_file = $parser->parse($ARGV[0]);
my $format=$xlsx_file->worksheet(0)->get_cell(0, 0)->get_format();
print "\nFORMAT OF THE CELL\n", Data::Dumper::Dumper( $format ), "\n";

And the result is :
$VAR1 = bless( {
'Font' => bless( {
'Bold' => 0,
'Height' => 12,
'Italic' => 1,
'Name' => 'Calibri',
'Color' => '#FF0000'
}, 'Spreadsheet::ParseExcel::Font' ),

How can I get the Strikeout property ?
Thanks in advance for your help.

@doy doy added a commit that referenced this issue Dec 9, 2013

@doy doy support more font properties (#14) 176c2e7

doy commented Dec 9, 2013

Fixed in 0.12, thanks!

doy closed this Dec 9, 2013

matrot commented Dec 11, 2013

It works !
Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment