Unanswered: How to export grid into excel ?
How to export grid into excel ?
please help me to implement this feature
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.
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.