I have an excel file which consists of a table which is unstructured and I’m trying to extract the value from last non empty cell of each row. I tried using
Get Row Item activity with column index as
finalDT.Columns.Count - 1 in
For each row, but this returns empty values as well. Any help would be appreciated. Please find the attached excel file (Sheet 2).
invoice.xlsx (9.3 KB)