Hi, I have a problem where I need to process the values from Excel into one form.
its in Reframework.
Here, I need to read 1st Company and get all the Models corresponding to company and check the checboxes for each model of same company…
Bot should repeat the same for all the companies.
Please help to solve this New Microsoft Excel Worksheet.xlsx (8.3 KB)
As the cells are merged ideally you would get data in the first row only and the remaining merged cells will be empty
Follow the steps
Have a variable created str_Comp and initialize it with String.Empty
Read the data into datatable dt
For each row in datatable on dt
3 now use a if condition with Not currentRow("Company").ToString.Trim.Equals(String.Empty)
On the then side use assign with str_Comp = currentRow("Company").ToString.Trim…Also on the then side include logic for start of nee company as only when new company comes in this then block is executed
Leave else side empty
Now after if and inside the loop use str_Comp to give the compny value and currentRow("Model").ToString for mode values