How to edit row/column width using UiPath?

[Adhu_4 (Aditya)]

How to edit row/column width using UiPath?

[reda (Reda_Marzouk)]

Hi @Adhu_4

Can you please elaborate more on the application on which you want to edit the row/column width.

Regards,
Reda

[VirajN (Viraj Nalawade)]

I am guessing you mean excel

try sending hot keys
Alt H + Alt O + Alt H for height
Alt H + Alt O + Alt W for width

I hope I understood your issue correctly

[Adhu_4 (Aditya)]

When i insert a data table to a word doc the values are not fitting properly it is irregular

[VirajN (Viraj Nalawade)]

is your wrap text turned on?

[Adhu_4 (Aditya)]

No where do i find it in word ?

[reda (Reda_Marzouk)]

So the application is word right?

If this is the case you can use autofit, but aren’t the page margins going to make you a problem ?

[Adhu_4 (Aditya)]

No that is not a issue

[VirajN (Viraj Nalawade)]

where did you copy the table from?

[Adhu_4 (Aditya)]

I used insert data table in word application scope and the DT was read from a Excel sheet

[Adhu_4 (Aditya)]

That is for images right?

[balupad14 (Balamurugan)]

Hello @Adhu_4,

Here is some activities AutoFitColumns,AutoFitRows,Format Cells. Can you try these.

You can download activity here.

https://go.uipath.com/component/balareva-xl-activities

Sample are here. But it as package from UiPath Gallery.

BalaReva.Excel.Activities Continue

Hi Friends, I have included some new activity in the package (AutoFitColumns,AutoFitRows,Format Cells). Now you can get the package here. I have uploaded the package in the UiPath Go. After It is uploaded , I will remove the package from here. Namespace : [image] AutoFitColumns Properties : [image] Usage of Column Range Single Column = { “A:A” } Continuous Columns={“B:D”} Multiple Columns ={ “A:A”,“D:D”, “E:G” } Range of Cells ={“A1:D8”} To set column width AutoFit=False ColumnWi…

Regards
Balamurugan.S

[LeftBrainCo (Louis McKernan)]

For some of my projects I create a blank template that is already formatted and such before hand. This is saved in a template folder. I then duplicate the template to the desired location, rename it and insert the data into it. You cannot do this for all solutions, but if it is a document you create a lot this is an easy rout to take. You can also then change the visual formatting of it on the fly without a need to update the automation.

[Caithlyn_Saturos]

Hi @balupad14,
what if i only want to set the range of row into 1 only?

[balupad14 (Balamurugan)]

Hi @Caithlyn_Saturos,

I am not clear. Can you elaborate on it, please?

Thank you
Balamurugan.S

[eraih]

Hi @Adhu_4
Where your able to resolve this issue? I’m currently facing the same issue. Kindly share your solution IF you’ve resolved it.

Thanks
Jay

[NithyaSankar]

Hi
I just want to do ‘autofit row height’ to only a particular selected cell. How can I do that using BalaReva.Excel.Sheets.AutoFitRows activity?
What would be the row range in that case?

Thanks

[balupad14 (Balamurugan)]

Hi @NithyaSankar ,

Please check this. you can get more detail about this activity.

BalaReva

Thank you
Balamurugan.S

[NithyaSankar]

Thanks… I understood how to use that.
I am getting an error for the following activity after this.

I just created a test workflow like below to test this.

Can you please help me on this?

[balupad14 (Balamurugan)]

Hi @NithyaSankar ,

Can you please use the autofit Rows outside of the excel application scope.

Thank you
Balamurugan.s