In my excel i have to delete some columns based on some condition. So i am reading the entire headers and putting in a list. Then i am reading each items from the list using for loop and checking whether i need the column or not based on the header name.
But how would i know the alphabet of the column so that i can delete the column from the excel.
If i delete the column from the excel the next column will be shifted to left and it will disturb the positions. So first i want to get the column (with alphabet and no.) then select a cell by select range activity and then press ctrl+space to select the entire column and then do a clear content.