Hi Team,
I need to Bold the Specific Row in Excel. I tried of using some of the UiPath forum output. But it does not work while bold the Specific row. Please help me to solve this issue.
Try with format cells activity
Which is modern activity
click on set format and click on font and you can select which you want
for the selection of the row
Excel.Sheet(“Sheetname”).Range(“3:3”)
you can pass the row which ever you want i have given as 3rd row replace it with your row
Cheers
Is any other way to bold this without modern activity? I don’t want modern activity for bold the specific row.
Hi Shiva, Great, this is worked. Thank u
1 Like
After Bolding row in excel i want to read excel sheet and store in datatable and insert this datatable in word document but while inserting this datatable in word file, it doesn’t show a specific row as bold. Do u know what is the reason?
When you read an Excel file you’re just reading data into a datatable. There is no formatting with it. It’s data.
If you want to keep the formatting etc then you’ll have to use UI Automation to open Word and click in its menus to add the table from Excel.
Manually we can achive this but how can achieve in UiPath?
By using UI Automation to do those same steps.
Without using UIAutomation, is it possible to achieve in any other way? because My requirement is do not use UI Automation.
Aside from advanced scripting, no.
Why is your requirement not to use UI Automation? It’s a fundamental part of automation, RPA, and UiPath.
ashokkarale
Anil_G
Ruban_shanmugam
Lalit_Chaudhari
eyashb
sonaliaggarwal47
PWilliams
AzeemK
Juan_Hkahfi