Query

[hoogeebear]

Hi,

My friend is an accountant and he was wondering about the following query:

He wants to set up a system that takes user input (wages, employee number etc) and add the entries to the relevant excel sheets. They sheets are then to be automatically updated. Is this possible? And does any one have any suggestions on the best way to begin?

Tanx and hope to hear from someone soon....

[NogDog]

Yes, it is possible. The simplest solution would be to take the data and write it to a CSV (comma-separated values) file (see the [man]fputcsv/man function). CSV files are easily read into Excel. If that is not adequate and you instead need to create an Excel .xls file, then you will need to look into any of a number of Excel file PHP classes or functions that are out there, and adapt them to your needs. (See the PEAR Spreadsheet_Excel_Writer class for one possibility.)