i have an excel file, i should select column as “Debit(AUD)” or some time it will be only “Debit” and i should go for the last total and read that particular cell.
In this, i should select column name as “Debit(AUD)” and go for the last in that column and read that particular cell(contains 25,405,177.14).
what i have did is
first i taken read range and get the datatable as output
next, i taken read cell, in that cell name if i take as index its working fine, but i need column name(dt.rows.count) will get the count.
in the cell, i tried like this as “Debit(AUD”)+(dt.rows.count).ToString
but am facing error.
can any one help me on this