Page 1 of 1
PHP to Excel
Posted: Tue Jul 08, 2003 9:58 am
by ckuipers
Hi,
I'm trying to automatically fill out an xls-sheet from PHP. I've been succesful till the point where I have to work the forms (it's a sheet we use in the office and is a standard so no way I can tamper with it).
Does any one out here know how to manipulate the buttons and dropdownlists from PHP?
Thx.
Posted: Tue Jul 08, 2003 12:48 pm
by Stoker
PHP is a serverside language, so if you are trying to make a web page do some macroing magic in Excel, PHP is not the tool.. For that it may work with a Bill Gates compromised web browser and vbscript, and som security-lowered settings for your windows system..
If your question is about creating spreadsheet documents with PHP, I dont know much about it, the easiest way would be creating simple CSV, commaseparated files..
Posted: Wed Jul 09, 2003 1:53 am
by ckuipers
If your server is a windows server it is possible using the COM.
Posted: Wed Jul 09, 2003 8:24 am
by Stoker
installing and running Excel on the server, and then serve the result as a file to the client? Ugh..
Posted: Thu Jul 10, 2003 2:10 am
by ckuipers
Well, that's to streamline things a bit. The department that needs the Excel sheets want to continue working the excel sheets while we track everything in a database.
Like this, it would keep us from having to fill out the information twice, once in the database and then in the excel sheet...
If it were up to me, I'd get rid of the excel sheets as well, but it's a different dpt...
Posted: Thu Jul 10, 2003 7:47 am
by Stoker
..i would say client/excel side macros/vba and ODBC would be the way to go..