fetch row excel with sample data sheet 1 item st_name st_No class adviser 10 manee 10000056 2 byran sheet 2 item subject point Grade 20 Mathematics 80 A 20 Data Structure 70 B 20 DataBase 80 A sheet 3 item schoolteacher 30 Adam 30 Armin 30 Abigail and i want sheet result like t…

Hey @Harpoon Please refer this screenshot Input Data Tables are : Sheet1 read range :- DT1 Sheet2 read range :- DT2 Sheet3 read range :- DT3 [image] [image] [image] While doing write range activity please dont tick the add headers as you dont want the headers. Regards,

Hi @Harpoon , Just want to make sure, could you please confim this output table is order using which column? [image] Regards,

Hey @Harpoon , Please check this workflow 3excelTo1.zip (1.9 KB) Check the “Output sheet” Test101.xlsx (12.3 KB) [image] Hope this helps

Fetch row excel 3 sheets to 1 sheet

Help Activities

Jithesh_R (Jithesh Karkera) March 23, 2023, 3:45am 5

Hey @Harpoon
Please refer this screenshot
Input Data Tables are : Sheet1 read range :- DT1
Sheet2 read range :- DT2
Sheet3 read range :- DT3

While doing write range activity please dont tick the add headers as you dont want the headers.

Regards,

4 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Extract data from excel file Help studio	7	6133	June 13, 2022
Datatable query for row into column Activities excel	7	563	August 7, 2023
Reading Excel data from diffrent sheets row by row Studio excel , studio , question	1	720	March 28, 2020
Get a particular sheet from csv Activities excel , activities , question	3	635	December 27, 2022
Excel Scenario ( mutiple sheet) Studio studio , question , activities_panel	7	233	February 11, 2024

Fetch row excel 3 sheets to 1 sheet

Related topics