J
Josh
hi all
anybody knows a script to save an excel in csv?
i need it for a php script
tnx
anybody knows a script to save an excel in csv?
i need it for a php script
tnx
J
J. Gleixner
Then why ask in a perl newsgroup? If you want a PHP answer, try a PHPJosh said:
newsgroup.
J
Josh
J. Gleixner said:
i need a perl script to save an excel in csv
J
James Willmore
If you need this for a PHP script, then wht not post to a PHP group?
Why are you mixing languages? This is an annoying pet peeve I have.
My suggestion is pick one and stick with it's functionality. I
believe this has been done successfully in both languages - pick one.
If you still have a burning desire or some company restriction that
requires you to write in Perl for this task, have a look at the
Spreadsheet::WriteExcel module. This should do what you're asking to
do.
HTH
Jim
J
James Willmore
If you need this for a PHP script, then wht not post to a PHP group?
Why are you mixing languages? This is an annoying pet peeve I have.
My suggestion is pick one and stick with it's functionality. I
believe this has been done successfully in both languages - pick one.
If you still have a burning desire or some company restriction that
requires you to write in Perl for this task, have a look at the
Spreadsheet::WriteExcel module. This should do what you're asking to
do.
HTH
Jim
E
Eric J. Roode
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Perhaps Visual Basic, or VBA, would be a better tool for doing this? Why
do you have your heart set on Perl?
- --
Eric
$_ = reverse sort $ /. r , qw p ekca lre uJ reh
ts p , map $ _. $ " , qw e p h tona e and print
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBP0E9LmPeouIeTNHoEQKqRgCfanTcjHrwN0Slmef16m63YN5TL/8An2II
jIJqdJCdyjJwzHp57FzMjcnq
=nRhz
-----END PGP SIGNATURE-----
Hash: SHA1
Perhaps Visual Basic, or VBA, would be a better tool for doing this? Why
do you have your heart set on Perl?
- --
Eric
$_ = reverse sort $ /. r , qw p ekca lre uJ reh
ts p , map $ _. $ " , qw e p h tona e and print
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBP0E9LmPeouIeTNHoEQKqRgCfanTcjHrwN0Slmef16m63YN5TL/8An2II
jIJqdJCdyjJwzHp57FzMjcnq
=nRhz
-----END PGP SIGNATURE-----
M
Matt Garrish
James Willmore said:
You're going in the wrong direction. The OP wants excel -> csv not csv ->
excel. The Spreadsheet::WriteExcel module won't help for the latter.
Assuming you're on a Windows machine and you have Excel installed, you might
be able to use the Win32::OLE module to open the file in Excel and then use
Excel itself to save the file to csv (from a simple macro:
ActiveWorkbook.SaveAs FileName:="C:\test.csv", FileFormat:=xlCSV).
Matt
Matt
C
ctcgag
Josh said:
perldoc Spreadsheet:
arseExcelgives a script on the first page that should be readily adaptable
to your need.
What difference does it make what script you need it for?
Xho
J
James Willmore
Matt Garrish said:
Spreadsheet:
arseExcel is what I meant I agree that, if on a WIN32 platform, Win32::OLE is more the way to go.
I just wanted to suggest a portable option.
Both should work fine.
Half asleep.
Jim
J
Josh
Matt Garrish said:
i'm sorry... i'm working on a linux server
J
Josh
perldoc Spreadsheet:
gives a script on the first page that should be readily adaptable
to your need.
very good this is ok
in my php script i download the zipped excel from a server...
then i extract the excel and save it on the server... now i can't read the
excel... i need some tool that convert excel in csv
P
Peter Hickman
Josh said:
Staroffice perhaps?
G
Garry Short
Josh said:
Josh,
*PLEASE* try reading the posting guidelines. It would have suggested (among
other things) doing a search on something like Google Groups ... if you
had, you'd have found the following thread:
http://groups.google.com/groups?hl=...9CBD9408Easu1cornelledu%40132.236.56.8&rnum=5
where I provided a sample script to do just this for Sara.
Regards,
Garry
J
Josh
Garry Short said:
tnx but unfortunately i'm working on a linux server...
J
Josh
Eric J. Roode said:
ok... i need to parse an excel file that i downloaded automatically from a
remote server
i'm working on a linux server so i can't use some php's objects that run
only on windows systems
i can't use an odbc connection because my server don't support this
so i would convert this excel in a csv file to parse it with php... i can do
this calling a perl script (that convert a xls in csv) by my php script and
then parse the csv with php...
G
Garry Short
Josh wrote:
So what? So am I.
This script was written on my laptop, which runs SuSE 8.1. One of the main
ideas behind Perl is that it's supposed to be *PORTABLE!*
In fact, I just went back and read the link I posted - it specifically says
I'm running Linux, and the OP specifically said in response that she was
running RedHat 8.
If you're going to ask for help, how about at least reading the information
you're pointed at?
Regards,
Garry
So what? So am I.
This script was written on my laptop, which runs SuSE 8.1. One of the main
ideas behind Perl is that it's supposed to be *PORTABLE!*
In fact, I just went back and read the link I posted - it specifically says
I'm running Linux, and the OP specifically said in response that she was
running RedHat 8.
If you're going to ask for help, how about at least reading the information
you're pointed at?
Regards,
Garry