Append excel data

Help Studio
1

I want to append excel files data into one excel

I have 4 excel files report, All excel have single sheet available I want to append data in new excel

2
  • For Each File in Folder
    – Use Excel File currentfile
    — Read Range into DT_Temp
    — Merge Data Table DT_Temp into DT_Main

Then after that’s done you just Write Range to a new file.

3

Hi @yogitagaikwad2206

Check the below workflow:

image
image899×1017 51.3 KB

Sequence65.xaml (11.1 KB)

Hope it helps!!

4

Hi @yogitagaikwad2206

Can you try the below

image
image996×2542 195 KB

Main.xaml (18.1 KB)

Regards,

5

@yogitagaikwad2206

Follow the steps

  1. For each file in folder
  2. Use excel file - currentfile.FullName
  3. Inside that use merge datatable activity with destination as FinalDT and source as Excel.SelectedSheet.DataTableOutValue
  4. After then loop use write range workbook and write the finaldt to the file you need

image
image422×706 26.5 KB

Hope this helps

cheers

6

image
image1512×2016 1.77 MB

This is my workflow plz tell me how append all excel data into one excel sheet

7

@yogitagaikwad2206

Try this

Regards,

8

This can be done for large amount of data ?

9

large amount of data means how much data you have approximately @yogitagaikwad2206

Regards

10

In one excel there is 5000+ record in excel some excel have 2000 like this

11

The above process will work for you @yogitagaikwad2206

Regards

12

can u tell me why this error is come

image
image1208×293 9.75 KB

This is my workflow

image
image548×741 28.6 KB

image

13

Please remove the double quotes in Range of Read Range Workbook and run the flow @yogitagaikwad2206

Regards

14

again this error is come can u tell me why u take build data table?

image

15

Build Data Table is taken because since you need to append it to single data table and write it to an excel. Everytime you read the excel and merge it, every excel data get merged to a single Dt. I hope you have same columns in all the excels.

Regards

16

Workflow.xaml (20.2 KB)

can u plz check in this workflow what exactly problem is ?
MIS-6_13_2024, 6_47_15 PM.xlsx (10.4 KB)

this is excel

17

Hi @yogitagaikwad2206

Can you try the below flow:
Workflow.xaml (21.2 KB)

Regards

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.