Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
suhas_chandran
New Contributor II

Storing Data into Multiple Tabs in an Excel / CSV file.

Hi Experts,

I was wondering if there was a way to store tables in to Excel or CSV into multiple tabs in QlikSense. This could be achieved in the Qlikview with Macros but as you know QlikSense does not supprort macros. Is there anyway i could store in the load script. Thanks in Advance.

Tags (2)
2 Replies
MVP
MVP

Re: Storing Data into Multiple Tabs in an Excel / CSV file.

It is not possible with standard Qlik Sense no.

Furthermore CSV will never allow "tabs" as that is not a part of any CSV-format variation....

MVP
MVP

Re: Storing Data into Multiple Tabs in an Excel / CSV file.

You can have an external PowerShell to do the job for you - collecting multiple xlsx-files into one. The PowerShell script could be triggered by the creation of the files and then perform post-processing of them into a single file. You can use the built-in Window FileSystemWatcher event triggering mechanism.

https://steemit.com/utopian-io/@cha0s0000/use-powershell-to-merge-many-excel-files-as-one

This is an example with C# but you can find other examples with both PowerShell or even VBScript:

https://www.codeproject.com/Articles/1220093/A-Robust-Solution-for-FileSystemWatcher-Firing-Eve