Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Text file to Excel with perl

by fishmonger (Pilgrim)
on Feb 28, 2014 at 16:25 UTC ( #1076559=note: print w/ replies, xml ) Need Help??


in reply to Text file to Excel with perl

Your posted code doesn't indicate that you're doing any manipulation of the data. Is that correct, or did you leave out that portion of your code?

Excel knows how to import csv (or pipe delimited) files. Have you tried opening the file directly in excel? If so, will it load properly?

How big is the file? If the resulting excel file is over 7MB, Spreadsheet::WriteExcel will require the use of the OLE::Storage_Lite module. Do you have that module installed?


Comment on Re: Text file to Excel with perl

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1076559]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2014-10-25 00:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (138 votes), past polls