Export Data as xlsx

Questions › Export Data as xlsx

Gunaseelan asked 10 years ago

I really want to export the data as .xlsx file instead of .xls.

How to get the data in .xlsx format?

3 Answers

Abu Ghufran answered 10 years ago

You can pass file name with complete xlsx extension.

$grid["export"] = array("format"=>"xls",
"filename"=>"my-file.xlsx", …);

Benjamin answered 9 years ago

Hi Abu,

Is this depending on the phpgrid version? … because it doesn't work for me

Thanks

Abu Ghufran answered 9 years ago

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