-
1. Re: download all the worksheets
Catherine Brown Aug 10, 2017 7:28 AM (in response to sravanthi.d.2)Not to Excel. Each worksheet will need to be downloaded individually. Unless you can get them into the same worksheet, but that can be difficult to do.
-
2. Re: download all the worksheets
pavan mojala Aug 10, 2017 7:48 AM (in response to sravanthi.d.2)It's not the first table that gets downloaded by default.It's the "highlighted worksheet" that gets downloaded. I don't think there is a way around to achieve your requirement,correct me if I am wrong.
-
3. Re: download all the worksheets
sravanthi.d.2 Aug 10, 2017 8:17 AM (in response to pavan mojala)yeah, it is the highlighted table
-
4. Re: download all the worksheets
sravanthi.d.2 Aug 10, 2017 8:18 AM (in response to Catherine Brown)or is there a way that we download to tableau workbook and from then we save it as .xlsx?
-
5. Re: download all the worksheets
Catherine Brown Aug 10, 2017 8:26 AM (in response to sravanthi.d.2)No, the interactions in desktop are essentially the same as in server.
Tableau treats each Tableau worksheet like an Excel worksheet, so unless they are in the same worksheet you have to download them separately.
-
6. Re: download all the worksheets
pavan mojala Aug 10, 2017 8:32 AM (in response to Catherine Brown)Yes, you're absolutely correct.
-
7. Re: download all the worksheets
Jay Morehart Aug 10, 2017 1:27 PM (in response to sravanthi.d.2)This could be done using either tabcmd or the API to write a tool that serially downloads the .csvs and merges them into a .xlsx file. You would then just need a webpage with a button to execute the script, Add that to the dashboard as a web object or modify the method here to add the button to the dashboard.
it looks like there are some php libraries for excel and I found this page that has a power shell script for merging .csvs into a single excel file (I personally have not tested this yet).
This method requires some development time, but it should give you what you want, and the end user would be none the wiser.
Hope this helps!