topic Delete a Column in Excel in Product Forum

Delete a Column in Excel

SunHung1 — Fri, 17 Sep 2021 06:38:58 GMT

Hi Expert,

I would like to delete a column in Excel.

I have follow the steps perfectly in the video:
https://www.youtube.com/watch?v=NNL14z4R7M4

However it is giving an error message:
ERROR: Exception : Failed to select row: The given key was not present in the dictionary.

All input are valid, really have no idea why it is giving such error, would you please help?

Re: Delete a Column in Excel

jebarson — Fri, 17 Sep 2021 08:23:23 GMT

The input parameters used for the select action seems correct.

You can find the error reason by trying the following options ;

1) Use worksheet exists action before select action ( this will helps to find the sheet name you are trying to work is already exits)
2) Use close all instances and retry the action from create instance stage.

Re: Delete a Column in Excel

VedSengupta — Fri, 17 Sep 2021 09:34:20 GMT

Hello Sun Hung,
Cell reference B1:BX where X is the row till which you might want to delete.
Can you please try this and check once?

Re: Delete a Column in Excel

krishna.kodimurali9 — Fri, 17 Sep 2021 12:32:31 GMT

Hello @SunHung

You can follow as below, this works fine.

1. Make sure there are no grouped, Hidden Columns present in the sheet.
2. Input the exact SheetName
3. Add a show stage so that you see what's happening in the excel
4 .We are using shift Left as we are deleting Columns.

Regards,
Murali