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

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

Anonymous — Thu, 18 Oct 2018 13:45:16 GMT

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.

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

petter — Thu, 18 Oct 2018 14:05:07 GMT

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

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

petter — Thu, 18 Oct 2018 14:11:13 GMT

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