Hi. I have a use case where i have to fill data in a web form using an excel sheet. The problem is that the excel has more than one sheet and the website has multiple sections. I’m attaching SS for better understanding.
As you can see in the SS, website has multiple layers like(customer_location,LCP_cabinets etc.). Now, i have sheet1 for ‘‘customer_location’’, sheet2 for ‘‘LCP_cabinet’’ and so on. For each layer we have ‘Add Point’ option. But, since each layers have different number of fields and the column names are different for each layer how do i fill the points.