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	1652	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	821	September 17, 2020
Merged cells from excel file Activities excel , activities , question	4	491	July 29, 2023
Change Excel format inside it: width of columns and rows Studio datatable , excel , uiautomation , studio , question	9	2984	April 14, 2021
Excel Cell height increase Mobile Automation excel , question	4	2024	February 9, 2021

Most Active Users - Yesterday
ashokkarale
Yoichi
Julian_Muhlbauer
miwa_yamamoto
Anil_G
A_Learner
BharathKamalapur
madhabhazra0
Lalasa_Mulakaluri
bayu.herlambang
More details...

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

Related topics