Samsun asked 11 years ago
Hello Mr ABu,
In my grid i activated export excel, but when i save as the format is xml spreat sheet. Can the export is xls or xlsx file?
Regards,
Samsun
1 Answers
Abu Ghufran answered 11 years ago
OpenXML format is supported in MS-excel and Openoffice new versions.
You can try naming the export file with extension.
e.g. "filename"=>"my-file.xlsx"
$grid["export"] = array("format"=>"pdf", "filename"=>"my-file.xlsx", "heading"=>"Invoice Details", "orientation"=>"landscape", "paper"=>"a4");
If you are using older version of ms-excel, you can use CSV export that will open in excel anyway.
Your Answer
