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

[Anonymous]

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.

[petter]

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....

[petter]

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