How to read a particular column like my excel will have many columns example name, height , so the bot has to pick data from excel under the same column headers and replace the same in a word file under the same category…any idea on this?
As long as picking values from a specific column goes, you get use read range and then use a for each row to iterate through the data table, inside that if you write row(“Column_Name”) ,it will give you the particular column value in that row.
Also you could refer to this link to copy the data from excel to word!
Hope this helps
Thank you! I just needed the approach to get the value of last non-empty cell in a particular column. Can you help on this?
I have given the Sheet name, and coulmn name A1 but unsure of getting the last non empty cell under the same column?
You mean to say you only want the last column value? not the whole column?