I need to fetch details from excel and enter into some portal.
Name Productname itemname Productname itemname
123 asd asd
abc xxx ccc xxx abc
cde yyy ddd aaa abc
In this scenario, this excel has 5 column, fetching details from here and enter into the portal.
first row is fetching it has only 3 column value and enter into portal.Now, Second row is fetching, it first enter the abc, xxx and ccc. and again it has productname and itemname value in this time they need to click add category button to expand the form and type the xxx and abc. How to check whether it has 3 column or 5 column??