How load data into datatable from excel.
I have 1 excel and 4 sheets so please let me know how to load the data from excel
You can read your sheets into seperate DataTables and merge them using Merge Data Table, like so:
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 requirement
Please and and let me know if any issues.
Mark as solution if it works