URGENT UIPATH ERROR HELP NEEDED "The 'br' start tag on line......"

[audrxyx]

I am trying to run a robot and I have encountered this error as seen below:

I’m just trying to read the cell ‘B16’ which contains a company name:

Please kindly advise me on how to solve this issue!

[jack.chan]

can you try change it to thisexcel application scope?

[Rahul_Unnikrishnan]

Hello @audrxyx ,

Ihope you are trying to Read the cell B16 from all the excels. Plz correct if im wrong.

Then do as below:

1)Use Excel Activity . Source as CurrentFile.ToString
2)Use Read Cell activity.

Inside this activity you can provide the sheet and the cell “B16”.

Read Cell

[audrxyx]

Hi @jack.chan & @Rahul_Unnikrishnan

Thank you for both of your suggestions, I have implemented it and it works.

However, I am facing this issue now:

I have these data in the excel sheet:

I suppose this error is due to having an empty row in my data? but there are instances where the cell(s)/row(s) is empty, any way to get around this?

Any solutions?

[Rahul_Unnikrishnan]

Hai @audrxyx ,

Please output the value of Read Range in a message box using Output Datatable activity and check whether some data is there in that Datatable.

I think the Excel is not read properly. If it is blank then you need to verify the properties and the sheetname provided in the Read Range activity.

[Rahul_Unnikrishnan]

@audrxyx I think you have used Raed Cell activity. It will accept only one cell like “C3”

If you want to read a set of cells then use Read Range activity and provide the Range as you have given.

[audrxyx]

Hi @Rahul_Unnikrishnan,

Thanks! You have sharp eyes.

I have changed to read range and it gives me the error of “Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))”. I did some research and people said it can be solved by adding a ‘Kill Process’ activity

However, UIPATH now tells me that the document already exists when I don’t see it in the folder I have assigned it to:

Am I doing anything wrong? any suggestions?

[Rahul_Unnikrishnan]

Hi @audrxyx

Here are you trying to insert the datatable to Excel? Also in any of the steps are you copying the Word Template to some folder.

If yes, before to the Copy file, use delete file activity and delete the Word template which is there in the folder.

As per the error in the output panel, i understood like that.