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 :
FORMAT OF THE CELL
$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.
Hello,
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 : FORMAT OF THE CELL $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.