The datatable writen in excel is generated from a string.
Thus the numbers of columns in a row is not fixed.
In my case, I would like to get all column items for row 3, which is highlighted in yellow , and joint them in the format of
“9023459211 Oct 01, 2020 39267.19 GBP 0 0 39267.19”
and assign this value to a Variable.
would you please guide me how to count the number of columns that is not blank in a row. and how to joint all the columns with space?
Much appreciation in advance!
Column1 Column2 Column3 Column4 Column5 Column6 Column7
“DOCUMENT_REFERENCE_NUMBER DOCUMENT_DATE” DOCUMENT_AMOUNT DOCUMENT_CURRENCY AMOUNT_WITHHELD DISCOUNT_TAKEN AMOUNT_PAID
“9023459211 Oct 01, 2020 39267.19 GBP 0” 0 39267.19
example.xlsx (10.0 KB)