Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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 contemplating the Monastery: (10)
As of 2014-10-01 17:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (31 votes), past polls