Hi, sorry for the delay. I have attached a sample Excel and HTML.
So basically if you see, There are 2 columns, and four rows in the Excel File. I can get what row a data belongs to in the HTML from the tr tag which had id attribute (r0, r1, …) . You can see this in the row image I attached, but I can’t get the column value of the data for which the user filled some answer in Answer column. There is no id for td tags.
I user cellIndex property of HTML to get the index of the td tag and used it as column value, but this failed me when there were merged cells in the Excel.
Hope I made this clear! If not please do tell me.
P.S we do have license.
forum.zip (106.8 KB)