in reply to How to Modify and Rewrite Excel Files in perl

Have you read what the Spreadsheet::WriteExcel documentation has to say about Modifying and Rewriting Excel Files? What parts of it do you have problems with?

  • Comment on Re: How to Modify and Rewrite Excel Files in perl

Replies are listed 'Best First'.
Re^2: How to Modify and Rewrite Excel Files in perl
by bimleshsharma (Beadle) on May 23, 2012 at 06:37 UTC
    I am getting format of cell but i am unknown about the actual properties. Because i have to use same format for other cell if bg_color=red. I am using code below to get format..
    # Get the format from the cell my $format = $template->{Worksheet}[$sheet] ->{Cells}[$row][$col] ->{FormatNo};