Hi,
If you want to show a simple spreadsheet like a table in excel you
can make a html table with your records and you can change de header to
transform that html table in a excel file.
Sorry about the english, I don't know how to write very well
regards,
Em 14/06/2011 12:20, Tony Jones escreveu:
>
> Is this a one time thing or do need to create a php script to allows
> users to export a file and save it as an Excel file? You can easily
> send the output of a mysql statement to an outfile and save it with
> the extension .csv and then import or open it in Excel, or you can
> save or return the output in html format. See the mysql command on how
> to this.
>
> Tony
> --- On Tue, 6/14/11, anandh Kumar <hawkeranandh@xxxxxxxxx
> <mailto:hawkeranandh%40yahoo.com>> wrote:
>
> From: anandh Kumar <hawkeranandh@xxxxxxxxx
> <mailto:hawkeranandh%40yahoo.com>>
> Subject: MYSQL TO EXCEL
> To: php-objects@xxxxxxxxxxxxxxx
> <mailto:php-objects%40yahoogroups.com>, vijayalakshmi6jun@xxxxxxxxx
> <mailto:vijayalakshmi6jun%40gmail.com>
> Date: Tuesday, June 14, 2011, 10:40 AM
>
>
>
> Hi To All....
>
> can any one guide me...
>
> i need a code for mysql table record export to excel file using php
> and mysql
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
