I really want to export the data as .xlsx file instead of .xls.
How to get the data in .xlsx format?
3 Answers
You can pass file name with complete xlsx extension.
$grid["export"] = array("format"=>"xls",
"filename"=>"my-file.xlsx", …);
It's very old feature and should be available in your version. Make sure you pass same var to set_options.
$grid["export"] = array("format"=>"xls",
"filename"=>"my-file.xlsx",
"heading"=>"Export to Excel Test");
$g->set_options($grid);
If it still does not work, email me code for review at [email protected]
Your Answer