Hi All,
attempting to use this pm to import large xml file directly into excel and getting some errors.
Using the generic example:
Code:
#!/usr/bin/perl -w
use strict;
use warnings;
use Spreadsheet::WriteExcel::FromXML;
my $fromxml = Spreadsheet::WriteExcel::FromXML->new( "test.xml" );
$fromxml->parse;
$fromxml->buildSpreadsheet;
$fromxml->writeFile("file.xls");
I can't seem to find any examples that fit what I am trying to do - any have a link to some examples?
Thanks!
Last edited by Franklin52; 05-31-2012 at 09:59 AM..
Reason: Please use code tags
I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day.
Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc.
Inside the file it would like the following... (7 Replies)
Any one having idea that,How to copy merged cell from existing excel file to new excel file?
Note : Is there any bug in module(Spreadsheet::WriteExcel or Spreadsheet::ParseExcel) itself ?
Thanks,
kavi (0 Replies)
Hi to all,
I want to convert xml file to binary Excel file, after googling for a while, I found cpan tool "Spreadsheet::WriteExcel::FromXML". I installed both,
Spreadsheet::WriteExcel and Spreadsheet::WriteExcel::FromXML.
To test Spreadsheet::WriteExcel I executed a example script that... (8 Replies)
I may have posted in the wrong section, either way I need some help.
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
#... (1 Reply)
