Topic: Export Excel data to list without excel

[Keith™]

interesting idea .. I hadn't thought of doing that ..

If my memory serves .. you can install PHP without a web server, by selecting CLI as the server ... of course this means the PHP file is executed via command line .. but it is executed none the less...

anyway .. I am off to get the PHP binaries now ... I have got to get this thing working

[fixo]

Interesting .. I wonder if it will install on 64 bit systems ...

I'm getting an error that it is unable to read the excel file

Just an idea
Open Notepad
Add this code

Code: [Select]



@echo off
copy C:\My.xls C:\My.csv
echo
pauserename both files to your suit
save as cpytocsv.bat
if the file path have a blank space then
include file name in the double quotes
i.e.
"C:\My Cool File.xls"
Then double click and you will be get a csv

~'J'~

[Chris]

it doesnt appear to work, the formatting doesnt get changed just the extension.  After you do your "conversion" try opening both files via notepad, you can see that the formatting remains identical, where as, if the formatting really was changed, the csv file would be readable and actually comma delimited.

[Chris]

Anyone have any other suggestions?

[VovKa]

Chris, I suggest installing OpenOffice

[Chris]

Chris, I suggest installing OpenOffice

I have, but get a message that says the Excel Object Library was not found.  And this method does not work on 64 bit because Jet Drivers are not available

[CAB]

Just think aloud, what if you installed the Trial version & did not use Excel?

[Chris]

Ok, how would i have to change your code to link into the 60 day trial of excel 2007 that comes on our 2 laptops we are having this issue on.

[VovKa]

I have, but get a message that says the Excel Object Library was not found.  And this method does not work on 64 bit because Jet Drivers are not available

Does OpenOffice need Excel installed to open "xls" files?

[Chris]

no it does not.  but using CAB's program, it is calling for the excel library, if excel was never installed, there would not be an excel library.  I dont know how to tell it to call for the OpenOffice Scalc library.

[VovKa]

Chris,
http://www.theswamp.org/index.php?topic=31362.msg369311#msg369311