MySQL: Exporting Data to Excel II: Going straight to Excel Support
Last week Allan introduced us to the notion of pulling information out from our database and making it available as in a CSV type format ready for using in Excel. This week Allan extends this idea by firstly showing us how to save our CSV data and then how to really wow our reporting colleagues by using BiffWriter to throw data straight into an Excel document….
…. and even if the business analysts don't really appreciate it, you can have an inner glow of satisfaction knowing how much more usable your website is!
Allan comes from Cape Town, South Africa. He has been implicated in writing for several WROX, glasshaus, Wiley and Apress publications, generally in the 'cool stuff that PHP can do' sections.
You can catch up with him at his website http://www.mediafrenzy.co.za.