When I run the code below I get the error message "Unknown method: Excel::Writer::XLSX::Format::set_font_color". This method is listed in the docs, but does not appear to be present in the module.
I have opened a bug report on the module, but am wondering if anyone else has run into this and if there are any known workarounds.
I am running Strawberry Perl 5.24.1 on Windows 10 and using version 1.03 of Excel::Writer::XLSX.
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'test.xlsx' );
my $worksheet = $workbook->add_worksheet("Sheet1");
my $format = $workbook->add_format();
$format->set_font_color( 'red' );
$worksheet->write( 'A1', 'test' );
$workbook->close() if defined $workbook;
"It's not how hard you work, it's how much you get done."