Hello again… how can I accomplish the following? I have a FOLDER with 40 excel files, all have the same structure and a sheet named “Información” I want to take the value for cell “B1” inside each excel file and be used to rename the “Información” sheet. As in the picture… any suggestion? Thank…

Hi, Is your sheet to read from B1 has same name as its filename? If so,the following will work. [image] infoSheetName = System.IO.Path.GetFileNameWithoutExtension(currentFile.Name) If not, can you share naming rule of the target sheet? Regards,

Rename Excel Sheet for MULTIPLE Excel Files

Help StudioX

fernando_zuluaga (Fernando Zuluaga) May 6, 2022, 10:51pm 2

hey

try this

Regards!

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Renaming Excel files after Sheet names/Cell Values StudioX studiox , question	8	342	July 26, 2023
How to rename multiple excel sheets in a folder Studio studio , question , activities_panel	2	840	June 14, 2022
How to rename multiple sheet if fails StudioX excel , studiox	4	450	February 14, 2023
Raname sheets Studio studio , question , find_references	10	538	August 1, 2023
Delete rows from spreadsheet using StudioX StudioX studiox , question	14	2105	February 20, 2021

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Rename Excel Sheet for MULTIPLE Excel Files

Related Topics