Need to delete 1st sheet tab in all excel file from Blue prism

M

MohanGururaj

New Member
Dear Developers,

I want to delete 1st sheet tab from all the workbook in a particular folder. I can do for only one workbook using "delete sheet tab" in excel VBO. But I need to delete it from all the files in the folder. Sheet tab name will be constant but File names and file count will be changed every time.

I have searched google but I can see its been done by Code stage. I don't want to include code stage here.

Thanks in advance.
 
S

Sachin_Kharmale

Active Member
Hi MohanGururaj,

You should design flow like bellow ,
View attachment 1559899320823.png

You need the list excel files in input folder using "List Files" Action from " Utility- File Management "Blue Prism VBO

View attachment 1559899447124.png

Then you will get output as Files collection which contains all excel file details

View attachment 1559899518211.png

Then Loop the collection Use [Files.Path] as input to open workbook for Excel VBO
and do same step for all excel to delete worksheet from excel file.

Best,
Sachin
 
You must log in or register to reply here.
Top