Posted by NC on 01/09/08 00:58

On Jan 8, 7:36 am, donh <donhar...@gmail.com> wrote:
>
> I normally use excel and have no knowledge as yet of php. I have an
> excel spreadsheet which is used for monitoring staff levels and
> availability. Dates (per month) along top, Workers at site in rows
> down left, their availability at intersections of rows and columns.
> The sheet works well until you try to share over a corporate network,
> and I think it would be better off in a database, ie mysql. I know a
> little about access and have been able to get a similar look using
> Pivot tables in Access but would like to get the database web based
> using a mix of php mysql if I can.
>
> Can php make mysql look like a spreadsheet table as described above?

Yes, but it may be too much work for your situation. I would
recommend that you simply save your Excel spreadsheet as an HTML file
and upload it onto your corporate network. If you are the only one
making changes to the source spreadsheet, it should work. There's no
need to build a DB-driven application out of it, unless there are
multiple users that have to make changes...

Cheers,
NC

[Back to original message]