Reading column in a excel with speciifc column headings,


#1

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?


#2

Hey @shreyaank,

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 :slight_smile:


#3

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?


#4

You mean to say you only want the last column value? not the whole column?


#5

Hi if you want just last non-empty cell from a particular column you can use this workflow:
ExcelDiffColumns.xaml (6.7 KB)
Also if you know how many elements are there in the column then you can simply use a read cell activity, if not then use this approach!

Regards

Niket Ghai