How to add sheets in excel and create a new excel sheet

Hello ,
I have an excel with multiple sheets(these sheets have names) and i want add these sheet and create a new excel sheet. how this can be done Please anyone help with this.

HI @Shree_Vybhavi,

Refer this post

Regards, Arivu :slight_smile:

hi @Shree_Vybhavi,

By this way you can create a new excel sheet in existing one.

image

Regards´
Balamurugan

2 Likes

for create sheet and excel file, give any new name then it will create
if we give the exist name of sheet or file means it will override the data

Hello @rajsekhar

Do you know how to check either sheet exist or not in a excel file? i need the boolean output.

Thanks,
Meg

Hey @megharajky

Just First Crete the object of Workbook then use below Code :slight_smile:

bool Sheet_exists = wb.GetSheets.ToList().Exists(function(sheet) sheet.ToString() = “Sheet1”)

Regards…!!
Aksh

4 Likes

Thanks @aksh1yadav :slight_smile:

Thank you so much for sharing. I’m undergoing weekend Excel training in Chennai and I’m gathering additional information from various articles and forums. This is really helpful. Do share more information.

the created sheet is inserted before existing sheet, can i place it after the existing sheet?

2 Likes

Hi @fprmana,

After insert the new sheet . you can use this activity “Move Sheet” activity from the below package.

Regards
Balamurugan.S

2 Likes

thanks for the answer, but I found another solution,
i use copy sheet activity, it paste new sheet after existing sheet, then I can paste the data on it.

1 Like