how to merge 21 excel files into single file as 21 sheets
how to do that
there are 21 excel files, the excel files should merge as single file with 21 excel sheets
You can use copy paste range activity
with two use excels one the main excel and second inside for loop for each excel
Or you can use workbook read range and then use write range workbook to write to final excel in loop
Both works
cheers
2 Likes
Directory.getfiles("Folderpath")
use for each for array and create output for each activity
inside use read range activity for reading the excel file
below that use write range activity and make the sheet dynamic by passing the for each output
can you send the sample code
there are 21 excel files how to keep the loop
in the source just you need to need the sheet name
and in the destination you need to make it dynamic by passing the int32 variable
can you explain how to mention the source and destination because i have different names for every excel file and sheet
Mutiplefilestosinlgefile.zip (13.4 KB)
hope this helps
i have developed the code in 2 ways
one is creating with the sheet names as Sheet1 ,
other one creating the sheetname as 2040001,
Surce will be excel1.CurrentSheet
and destination is Excel.Sheet("Sheetname" + currentItem.ToString)
cheers
I think you have send reversely
source contains 21 excel files
in your screenshot use excel file activity can only takes one excel file?
how to do
what about excel1? the error is that excel1 is not intialiazed
the destination sheet came empty
Anil_G
Yoichi
fernan
lakshmi.mp
Gayathri_Ramanathan
Nawazish_Ahmad
Tanmay_V_Chetule
Nguyen_Van_Luong1
Shiva_Nikhil
cprima