Hello,
For this scenario, you can make use of OLEDB VBO Blueprism.
Write a sql query to drop that column B from excel and check.
or else,
Write sql query to fetch all the data except column B from excel to collection and write it to excel (you can overwrite or create a new excel file & do whatever you want to)
Good Luck.