Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: CSV to Excel Converter

by Aim9b (Monk)
on Sep 20, 2007 at 15:48 UTC ( [id://640167]=note: print w/replies, xml ) Need Help??


in reply to CSV to Excel Converter

eric256, thanks for this post. I'm having to do the same thing & I'm looking at differences between your program, using Spreadsheet::WriteExcel, and mine using Win32::OLE. So far, mine works, but could be "cooler". Yes, MS Excel will read a CVS file, but like you, my users want it "created for them", then they'll tweak it. Thanks again, it really helps with the learning curve.

Replies are listed 'Best First'.
Re^2: CSV to Excel Converter
by poolboi (Acolyte) on Feb 14, 2008 at 02:18 UTC
    hi Aim9b, i'm also doing the same thing as you i have to convert a CSV file into an excel but i would like to use win32::OLE cos it's already install in activeperl don;t wanna go through the hassle of installing the other modules anyway like to know how to start off on writing a perl script to convert a CSV file to an excel using win32::OLE
      If I can figure out this weekend how to put code in here using the "Download" feature or the scratchpad, I'll send you what I have so far. Promise not to laugh too hard.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2024-04-25 23:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found