Can UiPath identify if text is bolded in an excel cell?

Help Studio
1

I have an excel report that is generated from an ERP system in a list where the main machine is bolded at the top, and all the parts used to build the machine exist below: The format would look something like:
MACHINE ONE
Part 1
Part 2
Part 3
MACHINE TWO
Part 1
Part 2
Part 3
Part 4

The number of lines of parts allocated to each machine is not the same and there is no other unique identifier that can be used to separate the machines.
My goal is to be able to move each machine with its parts to its own sheet. Can you assist?

2

@lmanier

If no identifier for machine name exists then you can use vba to check if cell font is bold and if it is create a new sheet and write the rows till the next bold cell in the new sheet

vba would be something like this

Function IsBold(cell As Range) As Boolean
    IsBold = cell.Font.Bold
End Function
1 Like
4

The only other differentiator is the Machine lines are in size 9 font while the parts are in size 8 font