[Help] How To? Excel Script: Rename all Sheets - Remove suffix

[pg2020]

Hello, everyone,

I hope I'm right here

I've been working with Power Automate for 2 weeks.
Goal: Combine multiple CSV files in one Excel file in different worksheets.
Convert CSV files to Excel workbooks - Office Scripts
Combine workbooks into a single workbook - Office Scripts

Unfortunately, the worksheets now have all file extensions as names.
Example: Name.csv.xslx.Sheet1 , Name2.csv.xlsx.Sheet1
Etc.

How can I remove the file extensions in all worksheet Names?
The following must be removed: .csv.xlsx.Sheet1
This is the same for all worksheets.

Unfortunately, I haven't found any other solution to combine individual csv files in an Excel file than this solution from Microsoft.

Thanks in advance and looking forward to a solution
Best Regards
Patrick

 

[pg2020]

I´m really sorry, i dont find a Edit Button.
The Scipt should be Office Script
The flow runs completly in the cloud.

 

[beyphy]

I'd recommend asking your question on the Office Scripts page on StackOverflow or on Microsoft's Office Scripts forum. Members of the Office Scripts team frequent these pages and can answer your question. You can see links below:

StackOverflow: Newest 'office-scripts' Questions

Microsoft: Questions in tag: office-scripts-excel-dev - Microsoft Q&A