in reply to Color highlighting in Excel

Suggestions on your original code:

The example code below creates a spreadsheet with two rows, "Harry James Potter" and "Amelia Susan Bones", highlighting "James" and "Amelia".

Working, tested code:

use strict; use warnings; use Spreadsheet::WriteExcel; my $out_file = 'result.xls'; my $search_string = 'me'; my $search_pattern = quotemeta($search_string); my $workbook = Spreadsheet::WriteExcel->new($out_file) or die "Can't create new workbook '$out_file': $!"; my $worksheet = $workbook->add_worksheet() or die; my $highlight = $workbook->add_format(); $highlight->set_bg_color('yellow'); my $row = 0; while (<DATA>) { chomp; next unless /$search_pattern/o; my $col = 0; my @fields = split; foreach my $field (@fields) { if ( $field =~ /$search_pattern/o ) { $worksheet->write_string($row, $col, $field, $highlight); } else { $worksheet->write_string($row, $col, $field); } $col++; } $row++; } $workbook->close() or warn "Error closing file '$out_file': $!"; __END__ Harry James Potter Albus Percival Wulfric Brian Dumbledore Cornelius Oswald Fudge Amelia Susan Bones Dolores Jane Umbridge Percy Ignatius Weasley

Replies are listed 'Best First'.
Re^2: Color highlighting in Excel
by imperl (Novice) on Sep 19, 2005 at 05:14 UTC
    Thank you all so much. Well, Im not sure how it works but when I say result.xls, there is an excel worksheet created with the output in it. However, I must say that I started it out with a .txt extension and just experimented with a .xls extension. Im quite a novice in Perl, simply because I havent really been dedicating my time for it, but let me try the suggestions and see if it helps. Thanks again