"One Click" export to Excel?

[Guest]

Not sure if this is the correct forum so please excuse me if I got it wrong.

I am wondering if there is a way to download the contents of a table (mysql/php) by placing a link or button on a webpage?
Currently I am able to export the table from within phpMyAdmin as a .xls file but it is a rather circuitous process and I was wondering if there is a way to set this up to work from a link or button within a DW8 page?

Again sorry if this is not the right place to ask such a question.
thanks for any help that may be forthcoming,
Graham

[Adeel_Shahid]

Hi Graham,

You can export the table in a csv format and then open up Excel and Import that CSV file inside excel that is about it for the solution part.

If you want an application created (PHP FILE) which will just have a button when you click that the file gets exported into excel I can do that for you (just private message me).

Let me know if it helps.

[JuanCVegaPR]

HI,

I don't know PHP, but, in VBScript, you can add the following:

<% Response.ContentType = "application/vnd.ms-excel" %>

at the top of a page, then, simply lay out a table with headers, plainly, the way the Excel columns would look...and, this will prompt you for a filename to save, and will generate an excel spreadsheet for you from the data you display in the table layout.

Hope this helps!

Juan C. Vega
Intelligentsia

[MikeL7]

I like the answer provided by JuanCVegaPR, But i would like to be able to create a excel file and have the name be generated by a variable like this, Report_MonthValue_for_PersonName.xls where MonthValue is the current month and PersonNAme is the name selected from a menu. I can do all of it except save the excel file, any suggestions. Using ASP at my day job.

[Guest · Accepted solution]

Hi folks,
Thanks for the replies, I have managed to solve this by using a php class that generates a csv file.
Appreciate the suggestions. 🙂