Click to See Complete Forum and Search --> : converting files


java-lover
05-01-2005, 09:25 AM
is there any command that will help
to convert the excel(*.xsl) file to csv( comma saperated values)file
do any one knows a special command that would help..
thanks alot..:D

NogDog
05-01-2005, 09:50 AM
Open the .xls file in Excel then select the "Save As" option and then under "Save As Type" select the CSV option.

java-lover
05-01-2005, 09:58 AM
ok you miss understand me
i wrote a php script that uploads a .csv file
and reads the data from it....is every thing ok till now:D
if so then can i upload .xsl file and then within the
php script is there any command that will help to
convert it automaticly to .csv file

thanks a lot

clairec666
05-02-2005, 12:45 PM
i think you can use the fopen() and fread() functions to read the text from the file, then create a new file using touch() and put in the data using fwrite()