topic Re: How to change xlsx to xls format while doing Export to Excel. in QlikView

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

renuka_sasikumar — Wed, 23 Mar 2016 07:25:01 GMT

Hi,

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

Regards,

Renuka S

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

Chanty4u — Wed, 23 Mar 2016 07:32:53 GMT

u can change the format after doing export.

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

Gysbert_Wassenaar — Wed, 23 Mar 2016 07:34:51 GMT

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.

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

jagan — Wed, 23 Mar 2016 07:36:59 GMT

Hi,

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

Regards,

jagan.

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

renuka_sasikumar — Wed, 23 Mar 2016 08:51:24 GMT

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.

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

renuka_sasikumar — Wed, 23 Mar 2016 08:53:13 GMT

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

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

awhitfield — Wed, 23 Mar 2016 09:33:33 GMT

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

Andy

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

renuka_sasikumar — Wed, 23 Mar 2016 09:41:19 GMT

What do you mean by this.

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

awhitfield — Wed, 23 Mar 2016 09:43:34 GMT

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

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

renuka_sasikumar — Wed, 23 Mar 2016 09:52:04 GMT

Thanks for your reply.