Skip to main content
Topics#Tableau Desktop & Web AuthoringGaurav Gupta-Casale's Question
Gaurav Gupta-Casale asked in #Tableau Desktop & Web Authoring
Sep 22, 2023, 2:52 PM

I need to change a workbook by editing the XML. Is it possible to change a worksheet name without losing formatting? When I change the worksheet name by editing the XML it changes the dashboard vizs' fit from Entire View to Standard.

I know you can hide worksheets when publishing through the Tableau API - however, I want to two different wbs published derived from the same workbook.

 

Even though the two wbs, when published, will have the same exact dashboard worksheet names, the dashboard worksheet names will be different in the original wb.

 

Original Dashboard:

** Sheet 1A

** Sheet 1B

** Sheet 2

 

Published:

Dashboard A

** Sheet 1

** Sheet 2

 

Dashboard B

** Sheet 1

** Sheet 2

2 answers
  1. Gaurav Gupta-Casale
    Sep 25, 2023, 2:00 PM

    Hi Matthias,

     

    Thank you for your response.

     

    What's interesting is that I didn't change the formatting -- all I did is change the name value in one of the dashboard attributes in the XML:

    <dashboards>

    <dashboard _.fcp.AccessibleZoneTabOrder.true...enable-sort-zone-taborder='true' name='New Dashboard Tab Name'>

    </dashboards>

     

    And I did spot sizing information, and saw that the edited xml had all the fits set to 'entire view' (which is the setting that I want) and not to standard (which is what the workbook defaulted to when I opened the workbook through Tableau Desktop after I change the name value in the dashboard attribute). What's even more peculiar is that if you inspect the XML after the name value change, you will not find 'standard' anywhere.

     

    Best,

    Gaurav

Write an answer...
0/9000