Thank you for your reply!
I will do it using the UI!
■What I want to do
┗・I want to paste the values from the cross-tabulation table displayed in Tableau into Excel.
Processing plan
①Match the Tableau sheet name with the Excel sheet name and create a mapping table.
②Iterate through the sheet names using a foreach loop and process each sheet one by one.
Processing content: Paste the values from the Tableau cross-tabulation table into Excel cell A1 (which is also fixed).
■Issues
• I don’t know how to retrieve the sheet names in Tableau.
┗• I tried to read the Tableau file as XML data in Explorer to retrieve the sheet names, but it didn’t work.
Any advice would be greatly appreciated.
sheetNodes = XmlDocument.SelectNodes(“//sheet[@name]”)
*Translated with DeepL.com (free version)*Thank you for your reply!
I will do it using the UI!
■What I want to do
┗・I want to paste the values from the cross-tabulation table displayed in Tableau into Excel.
Processing plan
①Match the Tableau sheet name with the Excel sheet name and create a mapping table.
②Iterate through the sheet names using a foreach loop and process each sheet one by one.
Processing content: Paste the values from the Tableau cross-tabulation table into Excel cell A1 (which is also fixed).
■Issues
• I don’t know how to retrieve the sheet names in Tableau.
┗• I tried to read the Tableau file as XML data in Explorer to retrieve the sheet names, but it didn’t work.
Any advice would be greatly appreciated.
sheetNodes = XmlDocument.SelectNodes(“//sheet[@name]”)