Find last used row and column of excel in c#

Asked Feb 08 '15 at 14:56

Active Feb 08 '15 at 14:56

Viewed 501 times

I have used the following code to import excel file into my data table in c#

OleDbConnection con=new OleDbConnection(strcon);
Con.open ();
OledbCommand oledbcommand=new oleDbCmmand("select * from [sheat1$",con);
OleDbDataReader dr= oledbCommand. ExecuteReader();
//loading in datatable
Dt.load (dr);

Please help me in telling how can I find the last used row and last column in my excel or datatable in c# .

Please help!!!!

asked Feb 08 '15 at 14:56

user3228318

do you cant get last record in excel file ? and last column in last record? – osman Rahimi Feb 08 '15 at 15:04
No. I want the last used row and column. – user3228318 Feb 08 '15 at 15:14
http://stackoverflow.com/questions/12276745/find-the-last-used-row-in-excel-with-c-sharp – osman Rahimi Feb 08 '15 at 15:16
Is there no other way to do like in continuation with what I tried to do... – user3228318 Feb 08 '15 at 15:43

Find last used row and column of excel in c#

0 Answers0