Read top row,cell value from a table, Excel 2010
Posted on 2013-01-10
Can you pls suggest me in reading top (row,cell) value from a excel 2010 table
FYI, Table -> is from SQL datasource
example i have a table named (MyTable) .. which can be filtered
A B C
1 Name Dept Project
2 Henry 501 GGG
3 Lynn 201 GGG
7 Henry 401 KKK
8 Joe 101 RRR
9 Lynn 301 KKK
Rrequirement : always read value from the (first row , second column) from the table.
Note:- Table can be filtered.