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 |