I'm completely new to this
I'm using phpexcel 1.7.5 and want to achieve the following.
I'm pulling data down from a mysql database using a form which then displays the total of the results on my site, but I want to be able to offer an xls download of the data.
The problem I've got is the form can display a range of data rows, with a fixed number of columns, depending on the date range selected.
I'll try and show in an example of how my data is stored on the database.
Date: Column 1: Column 2: Column 3: Column 4: Notes:
20/01/10 123.45 432.45 1234.23 4321.34 test notes
23/02/10 432.54 876.76 9834.23 1980.93
28/02/10 457.32 9867.23 1239.23 7653.23 notes test
08/03/10 4321.56 654.34 5654.54 2345.23 I'm a teapot
And the select is either 1 or a range of dates.
I want the xls to display it pretty much as above, but clueless how to achieve it using a variable number of rows.
If someone could point me in the right direction, I'll figure the formatting out etc after, just need the basics of how to do it please.