on 01-27-2022 8:48 PM
Hi, I would like to query data and export it to an Excel XLSX target file, preferably into 4 different tabs.
I see how to export to CSV as a target, but not Excel.
Is there a way to run 4 queries, and get the results into 1 XLSX file in 4 tabs ?
Running SAPDS ver 14.2.13.2467
As far as I know, this is not supported by Data Services out-of-the-box.
However, it is possible using external resources. We do it in our environment by storing results in temporary, delimited text files and then calling a custom function which executes a free utility which converts each temporary file into a worksheet in an Excel .xlsx target file. It is not for the faint of heart.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.