How to delete excel column 'B' which is exporting from SAP

selva.s2b

New Member
HI ,
I want to delete column 'B' from excel using blueprism. Excel not stored in local path. it will be exported from SAP and after removed column 'B' it should be saved into local path . Any one can explain this issue
 

Sukesh Kumaru

Active Member
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.
 
Top