Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Exporting lists from QMC to Excel

shaun_lombard
Contributor

Exporting lists from QMC to Excel

I stumbled upon this feature while trying desperately to simply get a list of items displayed in the QMC exported into an Excel spreadsheet. If there are other simpler methods, please let me know.

The tip requires OneNote and Excel and Internet Explorer (Other browsers not tested)

If you have any questions let me know.

Shaun

Comments
william_fu
Contributor II

You're a legend!

0 Likes
Partner
Partner

Don't know why can reply to Shaun directly hence do it here.

This doesn't work for me?

And if I use print, it print the screenshot as an image to OneNote...

Any idea?

Thanks

Fei

0 Likes
shaun_lombard
Contributor

I am using IE 11 and OneNote 2016, are you using the same versions?

0 Likes
Partner
Partner

Yes, I am using IE 11.64.16299.0 and OneNote 2016.

0 Likes
shaun_lombard
Contributor

I have seen a recommendation to change the value of the following registry key from 1 to 0

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\User Settings\OneNoteToIEAddin

Change "Count" from 1 to 0 and then restart the machine.

Mine is currently set to 1 and is working fine.

0 Likes
Partner
Partner

Thank you for your effort Shaun.

I have made this change and restarted my PC but still have the same error.

Cheers.

Fei

0 Likes
jeremy_fourman
Contributor

Thank you, this worked well for me today.

Version history
Revision #:
1 of 1
Last update:
‎2016-07-25 08:39 PM
Updated by: