how to convert CSV file to EXCEL file

[poolboi]

hi guys,

i've read a lot of thread of converting excel data into CSV files.
however, i need a perl script to convert CSV file into excel file now, if required modules is needed, it would be preferable if win32::OLE is used..

currently what i know is when i change my extension as .csv file mannually, it get changed to an excel file through Microsoft Excel CSV file

so if i were to use a perl script and convert
the perl script has to open this csv file and transfer it into excel?
hm..i'm not too sure but is it like that?
hope there could be certain place where i can look up info on these

[eWish]

I would suggest that you search CPAN. You will be able to find a module to create your files in the proper format rather than doing it manually.

--Kevin

[poolboi]

hm..ook i found somewhat a module to help me
but i'm totally confused with the installation part

i'm running on windows and activeperl
read website saying to install i have to

1. perl MAKEFILE.pl
2.make
3.make test

i really dunno what this means and i;ve tried like

$ perl -MCPAN -e shell

and nothing works..i'm really very confused about the modules thingy
can anyone help?

[nithinpes]

If you trying to install manually, extract all the .gz files. In the command prompt go to the folder containing extracted files and run the following commands,

>perl makefile.pl

>nmake makefile

>nmake install makefile

If you don't have nmake installed in your system, download NMake from Microsoft Knowledge Base, article 132084 .Run the downloaded executable to extract the files to <drive>:\Perl\b in.

[nithinpes]

If you are using Active state Perl, it's always good to use PPM.
Run ppm in your command window.
If your version of Perl supports GUI-based ppm, select the module and install it from the PPM window.
If it doesn't support GUI-based, then you will get a ppm> prompt.

To search for a module:
ppm> search Win32-ole

To install:

ppm> i win32-ole

Note: ppm is not case-sensitive. Also, look out for '-' used instead of '::'

Regards,
nithin

[poolboi]

so after i type the nmake install
the files that appear in the directory

i just transfer it to <drive>:\Perl\b in?

[nithinpes]

so after i type the nmake install
the files that appear in the directory

i just transfer it to <drive>:\Perl\b in?

The last paragraph in my posting was about procedure to follow if nmake.exe is not available in your machine. It's not after typing nmake install makefile, but before you start running install commands.
From the link provided, you would have downloaded Nmake15.exe. Double-click and run Nmake15.exe, it would extract nmake.exe and few other files. Now, transfer all the extracted files(nmake.exe ,Nmake15.exe etc.) to your perl directory (inside bin folder).
After this procedure, go to the path where you have extracted .gz file of module in command prompt and run the three installation commands.

I still suggest you to use PPM, it is easy and also dependent modules will be installed automatically.

[poolboi]

ok so how do i go about using ppm?

like how i run it and stuff like dat?

[nithinpes]

ok so how do i go about using ppm?

like how i run it and stuff like dat?

I have mentioned in detail about that in my previous posting. Just type ppm
in your command window and go ahead.

[poolboi]

hm..i've installed the package
but i'm aren't sure if the package i need is install
it seems it isn't..

[KevinADC]

hm..i've installed the package
but i'm aren't sure if the package i need is install
it seems it isn't..

If you have activestate perl installed, all the documentation is included. Open the activestate folder and then open the documentation folder. There is a ton of information that comes with it, all the perl documentation, all the module documentation, and then a lot of activeperl specfic documentation, it is to your benefit to start reading that documentation.

[poolboi]

hm..all i see are pm files
no sort of documentation files
:)

[KevinADC]

start>>programs >>activestate>> documentation

or however it is for your version of windows

[poolboi]

ok thanks for yr help
but ultimately i'm still trying to figure out how to create a perl program where i can put data from my csv file into an excel sheet so that it's used for reasy referencing
any ideas pls help out? thanks
i'm really stuck on this

[KevinADC]

ok thanks for yr help
but ultimately i'm still trying to figure out how to create a perl program where i can put data from my csv file into an excel sheet so that it's used for reasy referencing
any ideas pls help out? thanks
i'm really stuck on this

Sorry, I don't know.