PHP to Excel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ckuipers
Forum Commoner
Posts: 61
Joined: Mon Mar 24, 2003 6:10 am

PHP to Excel

Post 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.
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post 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..
ckuipers
Forum Commoner
Posts: 61
Joined: Mon Mar 24, 2003 6:10 am

Post by ckuipers »

If your server is a windows server it is possible using the COM.
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

installing and running Excel on the server, and then serve the result as a file to the client? Ugh..
ckuipers
Forum Commoner
Posts: 61
Joined: Mon Mar 24, 2003 6:10 am

Post 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...
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

..i would say client/excel side macros/vba and ODBC would be the way to go..
Post Reply