Need to automate excel sheet

Hi friends,

I need to automate one excel file. the excel file have around 20sheets. In that the bot have to delete the excel 19sheets. 1st sheet is the main sheet which contains student datas. Then the bot have to delete the one specific column name is “Grand total”. Please guide me on this


Welcome to forums

Instead of deleting the sheet you can take the data of the particular sheet and using write range create another file and other you can delete the column by using the filter data table activity

1 Like

No i want to delete the sheets

Hi @Ashwinny_Ls,

Does the sheet you want to keep have a constant name? If so, I think using a For Each Excel Sheet activity, If Sheet name = KeepSheet, do nothing, Else you can use the Delete Sheet activity to delete it.