Delete a Column in Excel

[SunHung1]

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?

[jebarson]

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.

[VedSengupta]

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?

[krishna.kodimurali9]

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



​​