How to calculate excel cells amount with content in Studio

[rahulsharma]

@dhu

same length of column

does this mean you need to have the excel column width equal as for others? or do you need to Auto-Fit the column width

have a look at the below thread:

How to Set Column width in Excel

Hello @iumerparay, After writing data in excel, you want to auto-fit the column right? Then, using Invoke VBA could be a option. firstly write the code below in txt file. Sub ColumnWidth() Columns("H:H").EntireColumn.AutoFit End Sub Then use Invoke VBA activity in excel application scope and mention txt path and methodName e.g here i’ve used ColumnWidth just change column in above code as here’s H. [image]