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
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.