@lakshman as i show in screen shots, i am already have this package but cannot use the last version of this package that include these activites. So there is no autofit activity here. That is why i am asking how can i autofit all columns.
Is the Installed Package version 2019.4.0 ?
Show me screenshot of Balareva.Excel.Activities Package version.
Here is my page.
You can call below package , by adding it in settings of uipath.
AdvanceExcel.1.0.9.nupkg (9.6 KB)
Uninstall that Package and Install it again. Package version should be 19.4.0
i have just installed it but i don’t know what i should write this properties: FileName, Range, SheetName and AutoFit. Can you help me about this?
1.Column Range: A:D
2.File Path : where you save path of excel.
3.Sheet Name : what sheet you want auto fit columns.
And do you know what should i write the properties that “FontColor” and “FontStyle” ?
Cause i also want to make gray and bold a spesific row
I have seen the screen shot @mazlumkacar. you are using the old version. You need update or new installation like below.
See the logo of the
Here is a the package (version 7.1.0) and it has an activity called “Cell Font” (you have to download and install it . Because I have submitted into the UiPath Go)
I have a similar question- I want to autofit only visible columns.
For example: Columns- A,B,C,D,E,F,G (A,B,D are hidden)- I want to apply autofit to C,E,F,G columns only (visible ones)
I used the BelaReva activity and the Excel Extension activity- both are autofitting all the columns (making the hidden ones- visible on sheet).
Would appreciate some help.
Here is an activity called “Get Hidden Columns” to get the all hidden columns in the entire worksheet.
Thank you @balupad14,
I tried the new version but its not working with password protected files.
could you please add a password parameter as well. that would be great.
Thank you for using the package.Really I thank your feedback. Normally I am testing with simple data. If you don’t mind , can you provide a sample like what you have the real one. I can test it. If any needs to add or fix some thing in the activity that I can do. If you feel uncomfortable to share file here. you can send it by message.
Thank you for getting back to me. Unfortunately i cannot share excel files- not even via message.
would it be okay if you could add password to any excel file and try it.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.