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

Help
1

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.

2

HI @Shree_Vybhavi,

Refer this post

Regards, Arivu :slight_smile:

3

hi @Shree_Vybhavi,

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

image

Regards´
Balamurugan

3 Likes
4

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

5

Hello @rajsekhar

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

Thanks,
Meg

6

Hey @megharajky

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

image
image942Ă—458 22.4 KB

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

Regards…!!
Aksh

4 Likes
7

Thanks @aksh1yadav :slight_smile:

8

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.

9

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

2 Likes
10

Hi @fprmana,

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

Regards
Balamurugan.S

2 Likes
11

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