topic How to export tables using javascript in Integration, Extension & APIs

How to export tables using javascript

gugags6 — Sat, 16 Nov 2024 02:47:47 GMT

Im totally newbie in Qliksense. I need to export so many tables in a only turn. My idea is create a extension using javascript, where I reference all my tables in the code, and create a button. When I click on the button, all my tables will be exported in my directory C in xlsx or csv format.

Im trying to use the exportMethod, but I dont know how to reference my tables. I have no idea how to go on. Please, anyone has something like this to share?

Re: How to export tables using javascript

donk — Thu, 16 Sep 2021 12:35:47 GMT

Ping! I'm not clear on this either. Any help here?

Re: How to export tables using javascript

Aiham_Azmeh — Fri, 17 Sep 2021 05:54:04 GMT

Hi,

In your extension, you should be able to use the `Visualization API` table property returned in the visualization model, ex:

const app = qlik.currApp(this); app.visualization.get('your_table_visualization_id').then(visModel => { visModel.exportData({ format: 'OOXML', state: 'A' }); });

doc link > https://qlik.dev/apis/javascript/capabilities#%23%2Fdefinitions%2FQVisualization%2Fentries%2FexportData

Re: How to export tables using javascript

donk — Fri, 17 Sep 2021 12:58:47 GMT

Thank you. I might be in the wrong section. I want to do this in a Qlik View extension and this looks like it's only for Qlik Sense. Is there a similar API I can use in Qlik View?

From an extension I would like to be able to access data in a table or list in CSV format to pass to an external API.