Re^2: Excel Formatting

[PerlSufi]

Hi Count, thanks so much for the input! However, I am still getting the column J and not getting my currency format when I try that..?

[CountOrlok]

You are applying the currency format at the end, after you have written all the data? (before closing the file, of course).

[PerlSufi]

Yes. I have tried declaring

my $trans_format = $workbook->add_format();
$trans_format->set_num_format('$0.00');

where I set my other formats and after the while loop. I have also done $worksheet->set_column('I:I', undef, $trans_format); after the while loop. I can't figure it out..

[PerlSufi]

UPDATE:Actually replacing that while statement with my previous one worked to remove J column, but I still don't have the currency format.