How to read the excel data in table format and write into the web application

Help Studio
, ,
1

Prerequisite: A Schedule is given on a Weekly basis where there are security guards present on particular sites for particular times.

Chennai Port: 587-2076
CSS Sat Sun Mon Tue Wed Thu Fri
Time/Hours 12/03 12/04 12/05 12/06 12/07 12/08 12/09
0001-0800 (8) Rajini Rajini Rajini Rajini Kamal Kamal Kamal
0800-1600 (8) Surya Surya Karthi Karthi Karthi Karthi Karthi
1600-2400 (8) Vijay Ajith Ajith Ajith Ajith Ajith Ajith

Please provide a solution.

Thanks,
Sandeep Varma
+91 8978216870

Reboot, Work

2

Hello @Sandeep_Varma_Rudraraju

If you are trying to read the data from excel, you can use the “read range activity”.
The if you want to add the data row by row, you can use a “for each row in datatable” activity.
Else if you want to add all the excel content in a single step, you can use Output datatable activity to convert to string and then use Type Activity.

Thanks