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	516	July 26, 2023
How to rename multiple excel sheets in a folder Studio studio , question , activities_panel	2	1022	June 14, 2022
How to rename multiple sheet if fails StudioX excel , studiox	4	481	February 14, 2023
Raname sheets Studio studio , question , find_references	10	887	August 1, 2023
Delete rows from spreadsheet using StudioX StudioX studiox , question	14	2298	February 20, 2021

Most Active Users - Yesterday
Yoichi
ashokkarale
Anil_G
Ajay_Mishra
AkshaySandhu
jast1631
Gowthaman_Subramanian
Damai_Revanth
ppr
mayank_26
More details...

Rename Excel Sheet for MULTIPLE Excel Files

Related topics