Getting Exception HRESULT: 0x80010114)

[Nikhil_Antony (Nikfega)]

This is my scenario, reading multiple .xlsx and CSV files and after that doing data table operation.

Sometime getting the HRESULT Exception. Any suggestion for this?

[Ajju (Ajjayya Hiremath)]

hello @Nikhil_Antony,

before reading any workbook make sure that all excel workbook are closed
after reading each excel or csv use kill activity for excel.
this might help you

Regards
Ajay

[Nikhil_Antony (Nikfega)]

Thanks @Ajju, I am using kill for EXCEL. And I a getting the error while reading second file

[vishnuvarthanp (vishnuvarthan)]

Hi Nikhil

Can you provide the complete exception message that u r getting , is there any error message associated with it?

[AnandKumar26 (Anand Kumar)]

@Nikhil_Antony

I am using kill for EXCEL. And I a getting the error while reading second file

Hi @Nikhil_Antony. Try to use some delay and then read the second file, that will work for you.

Thanks,
AK

[Ajju (Ajjayya Hiremath)]

@Nikhil_Antony
use kill excel activity after Each read excel activity and also give some delay between alternative read operation

[Nikhil_Antony (Nikfega)]

@ya it is working. Thanks
Is there any alternative to avoid delay. or is it possible to dynamic delay over here

[Ajju (Ajjayya Hiremath)]

@Nikhil_Antony

Are you using excel scope activity and inside read rage inside it… Or using read range under workbook activities?

You can try both if any one is working fine without delay its well and good

Read Range

Read Range

[loginerror (Maciej Kuźmicz)]

Hi @Nikhil_Antony

Welcome to our UiPath Forum!

Are you by chance using the Copy Sheet activity? See here for a clue:

Exception: 0x8001010E when copy paste sheet in excel

The error caused by that: the copy sheet activity can only copy sheet from one excel file to another, and cannot copy and paste sheet inside one excel file.

[Nikhil_Antony (Nikfega)]

No I am not using copy sheet activity

[md.ahtesham (Ahtesham)]

@Nikhil_Antony

If i am not wrong i believe that your first iteration is successful but second iteration is causing problem. Correct?

If so please have a look on it…

How to fix/solve Read Range Error (Excel Scope)

Simple buddy use a kill process activity before to this Read Range activity and mention the property PROCESS NAME as “EXCEL” that would close the excel before you read it. And this error occurs because the file from where we are fetching is running in background so thats why and to rectify this we need to close the application before we read Hope this would help you Kindly try this and let know for any queries or clarification Cheers @Ashik_Khan

If you face any further issue please revert

Regards,
Ahtesham

[WhenCutEsh (Venkatesh Nallana)]

@Nikhil_Antony This Issue Is actually Strange as If you restart your PC the error will go off sometimes running too much on excel operations makes the Excel corrupt, sometimes if the cell contains ######### also this kind of exceptions come up.

[md.ahtesham (Ahtesham)]

Please don’t use kill Excel . I have faced lots of issue because of this.

Kill will corrupt your excel.
I have faced this in Production Sever and wasted 2 days fixing this , then at the end i realised that KILL is causing this isssue.
Reason - When we use kill with excel it closes excel without saving . so, next time when you will open excel it will give message in left side of excel to save or not.

Best practice don’t use Kill with Excel.
I am just telling this with experience , maybe i might be wrong.

Regards,
Ahtesham