Get multiple excel sheets to one DataTable

How load data into datatable from excel.


Check below

Follow Link

Hope this helps you


I have 1 excel and 4 sheets so please let me know how to load the data from excel

Hi @Mohita_Sharma,

You can read your sheets into seperate DataTables and merge them using Merge Data Table, like so:

image image

Edit: Off-topic, please give your forum posts more descriptive titles. This will allow for easier diagnosis of your problem, resulting in you getting your solution faster.

Error is showing End of expression please let me know

"Insert into PLUS_GRADE.PG_SUBMITTED_OFFERS (DEPARTURE_DATE, CODE, FLIGHT) Values ( " ’ " + 10/1/2020 + " ’ , ’ " + FZ + " ’ , ’ " + 45 + " ’ ) "

Please get the Worksheet names with GetWorksheets activity. It results in List variable.
give the loop for Sheet list and read the each workbook data in Loop
If all sheets have same format read data in one data table
If sheets are in different format store in various data tables. Please try as per your requirementGetSheetName
Please and and let me know if any issues.
Mark as solution if it works