View Full Version : How to export grid into excel ?

2 Nov 2011, 1:36 AM
Hi everyone,

How to export grid into excel ?

please help me to implement this feature

16 Jan 2012, 10:48 PM
I use the Pear package Spreadsheet_Excel_Writer (a bit out of date really) - which does everything server-side.

I came across this thread on the forum the other day, but have not tried it myself.


16 Jan 2012, 11:46 PM
I have, it works to a degree but not in all browsers. I prefer doing it server side because you can customize the formating to a much larger degree. Most of my scripts that generate the json for the store also generate the same data in Excel; therefore I have a single "data gathering" script and then it either outputs json or Excel depending on what was asked for (default=json). All you then need is a button in the grid title bar to "save" to Excel.