in reply to Re: Creating an excel document from hashes
in thread Creating an excel document from hashes

Here is what the hash produces THE OUTPUT IS 

$VAR1 = {
          'w' => [
                   '0',
                   '0',
                   '0.00',
                   '5.50',
                   '0.00',
                   '2.50',
                   '0.00',
                   '489.50',
                   '0.00',
                   '0.00',
                   '0.00',
                   '0.00',
                   '0.00',
                   '242.00',
                   '0.00',
                   '0.00',
                   '0.00',
                   '5.50',
                   '0.00',
                   '4.00',

[download]
I need to convert the hash where one key has multiple values into an excel sheet

Replies are listed 'Best First'.
Re^3: Creating an excel document from hashes
by roboticus (Chancellor) on Sep 11, 2013 at 10:29 UTC

    rahulruns:

    You should be able to do it with something like:

    use Spreadsheet::WriteExcel;

. . . . code to build hash . . . .

my $XL = Spreadsheet::WriteExcel->new('output_file.xls');
my $WS = $XL->add_worksheet('my data');

my ($ROW, $COL) = (0, 0);
for my $colname (keys %graph_point_hash) {
    # Add column header
    $WS->write_string($ROW, $COL, $colname);

    # Add column
    $WS->write_col($ROW+1, $COL, $graph_point_hash{$colname});

    # Move on to next column
    ++$COL;
}

    [download]

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]

In Section Seekers of Perl Wisdom