How to calculate excel cells amount with content in Studio

[dhu]

Hi team,

As I am creating a new column and want to put into some content with the same length of column as the others, but how to calculate the numbers need to add?

[THIRU_NANI (NaNi)]

Hi! welcome to community!

if you want to add items to a excel please follow the below steps.

1.Take one build datatable and create your columns
2. then take for each row in data table
3.Take one assign and create a variable type:string and in the value field. enter the expression from where you are getting the data.
3.take one Add Data Row activity
4.Navigate to properties inside the array of row mention {Your string variable}

Regards,
NaNi

[Hiba_B (Hiba Beldi)]

Hi @dhu !

Welcome back to UiPath Community
I am not sure to understand.
Let’s say you have a datatable like this:

Do you want one more column with data at column F or G or I did not get your need ?

[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]