How to change xlsx to xls format while doing Export to Excel.

[renuka_sasikumar]

Hi,

How to change xlsx to xls format while doing Export to Excel.

Regards,

Renuka S

[Chanty4u]

u can change the format after doing export.

[Gysbert_Wassenaar]

It's not possible to export to xlsx. Only the older .xls format and text/csv is available for export. Well, you could try a macro, but I don't recommend this. Such macro's are slow and don't work in the ajax client. If you still want a macro then search this site. I'm sure there are examples available.

[jagan · Accepted solution]

Hi,

It is not possible, only csv or txt or xls is possible.

Regards,

jagan.

[renuka_sasikumar]

Hi,

I think it is possible, I could not try because here its Microsoft Office 2003.

But As I know there is a option in QMC.

QMC-System-QlikView Web Servers- Go to tab Web

Under that Mime Types you can add the

extension .xlsx &

its content as application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Hope its work.

Can anyone try this if possible.

[renuka_sasikumar]

Also you can here correct Microsoft Office MIME types

http://stackoverflow.com/questions/4212861/what-is-a-correct-mime-type-for-docx-pptx-etc

Regards,

Renuka S

[awhitfield]

Yes, but you could also put .BANANA in too as a mime type! But that doesn't mean it will work!

Andy

[renuka_sasikumar]

What do you mean by this.

[awhitfield]

Jus because you can enter .xlsx as a mime type doesn't mean that QV will export to it, the mime types are NOT validated, you can enter any thing in the field, e.g. .BANANA!

Andy

[renuka_sasikumar]

Thanks for your reply.