Hi All, I’ve a requirement to apply auto fit for the merged columns and the text should be visible to read. I’ve multiple excel files with different columns are merged. Robot should read the excel file and find the merged columns and apply auto fit. For example, one excel file D1 to H1 was merge…

Hi All, I found a solution :blush: working fine. Am sharing the script which will help if anyone wants to find a merged cell in the excel file and apply to autofit. Sub FindMergedCells() ' Declare sheet you want to look for merged cells on - in the example it's sheet 1 Dim sheet As Worksheet S…

How to apply auto fit for the merged columns [Excel]

Help Studio

muhammedyuzuak (Muhammed Yuzuak) June 15, 2022, 3:44pm 2

Hi @Shagoul_Hameed,

Have you had a chance to check this link?

Regards,
MY

1 Like

Topic		Replies	Views
How to AutoFit Columns in Excel before copy to Data Tables and create file CSV Studio datatable , excel , question	13	1663	January 15, 2021
I did the merge of two excel files, could you help me to keep the original formatting of the excel file? Help datatable , excel , uiautomation , activities , question	6	825	September 17, 2020
Merged cells from excel file Activities excel , activities , question	4	514	July 29, 2023
Change Excel format inside it: width of columns and rows Studio datatable , excel , uiautomation , studio , question	9	3103	April 14, 2021
Excel Cell height increase Mobile Automation excel , question	4	2035	February 9, 2021

Most Active Users - Yesterday
Anil_G
mkankatala
sharazkm32
ashokkarale
manasrlenka25
VanjaV
Llessur
maria14
Nishant_mantri
Anelisa_Bolosha1
More details...

How to apply auto fit for the merged columns [Excel]

Related topics