Export Data as xlsx

QuestionsExport Data as xlsx
Gunaseelan asked 9 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 9 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

1 + 9 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?