Jump to content


Photo

MySQL - Excel


  • Please log in to reply
2 replies to this topic

#1 gerkintrigg

gerkintrigg
  • Members
  • PipPipPip
  • Magician
  • 828 posts
  • LocationBristol, UK
  • Age:37

Posted 25 April 2006 - 11:29 AM

I've posted this in PHP Tutorial Help, but there has been no reply (does anyone use it any more - other than me?)

I'm trying to import/export to/from mySQL & Excel. I have followed the tutorial to do this, but am still coming up blanks on why the reader file is exporting the whole PHP page to the excel file, rather than just the data. When I load the XLS file (excel extension), it asks me where my CSS style sheet is...

If anyone has had the same problem in the past and had it resolved, I emplore you to help.. *beg, grovel, beg some more*.

Thanks in advance.
Neil Trigger - http://www.ghostlypublishing.co.uk - Ghostly Publishing - Children's Fantasy Books

#2 wisewood

wisewood
  • Members
  • PipPipPip
  • Advanced Member
  • 226 posts
  • LocationRotherham, England

Posted 25 April 2006 - 11:35 AM

I came up with a script to export data from a mysql database, and to create an Excel spreadsheet containing the required data. This Excel sheet is saved to a specific location on the webserver.

If you want me to send over the script, let me know and i'll comment it up so its easy to modify for you.

I use it for creating a mail-merge source file for when we want to send a letter to multiple clients... have a simple form where you can select the clients who are due to receive the letter, click a submit button and it transfers their details from the database and generates a .xls file with the content in it.

It's pretty straight-forward really... but took me ages to get it working as i wanted.
wisewood: proven fact, I am both wise, and wooden.

#3 gerkintrigg

gerkintrigg
  • Members
  • PipPipPip
  • Magician
  • 828 posts
  • LocationBristol, UK
  • Age:37

Posted 25 April 2006 - 11:48 AM

Yes I'd love you to send me the script. Could you forward it to runner@422.com please.
thanks.
Neil Trigger - http://www.ghostlypublishing.co.uk - Ghostly Publishing - Children's Fantasy Books




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users