RPC Server Unavailable ,Done all the Delay,kill mentioned in the forum

Hello Guys,

 - In my task i need to delete particular range of rows.

How I done:
- Used lookup datatable to get the index
- Used Delete Range to delete that particular range of rows.

What i get
- Simply an error
Delete Row: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

image

I just need to know if any other activities or method to delete the particular range of rows.

@seanrockvz13 @ppr @Palaniyappan @lakshman @Srini84 @pravin_calvin @prasath_S @Yoichi @NIVED_NAMBIAR @Gopal_Tewari1
Regards
Sudharsan

Before using delete range make sure excel instance is closed properly.

Yes it is closed

to get more specific:

  • before running the Bot - ensure that no disturbing excel instances for the excel file a running
  • when deleting the range (assumed within an Excel Application Scope) ensure that the EAS is alive

check it also within a debug run with a little wait time between EAS and delete range

Now i have given delay between Excel application scope and delay and debug the xaml file ,its throwing an error “Failed setting the current sheet to …”

Regards
Sudharsan

And also @ppr

Whether we can able to delete the specific rows by giving the range in linq query?

@Sudharsan_AIT

Did you try with Delete Range?

Because the error you mentioned is with Delete Row

When there is a change in Datatable the Index will be changed
So this might cause this type of errors

Thanks

Yes i have tried that also still same error

Regards
Sudharsan

not sure If I got you

  • you want to delete rows on Excel right?

its depending on the details (and also not recommended for all cases, a more quick and dirty approach)

  • use datatable and remove the unneeded rows
  • fill up the filter result datatable with empty rows to get the same rows count as before the filtering
  • use filled up datatable to overwrite existing excel rows with a write range

@ppr
For Eg : i need to delete all the rows and column which is from a specific keyword.

Let’s say i am having 1000 rows in that my key word in “Entity ID”

What i need to do ,
- I need to delete all the rows and columns from the word “Entity ID” (i.e. Including the row which has Entity ID)

Regards
Sudharsan