i have a excel file and i have to read some column from excel and fill in my gridview. can anyone know how to do please help me.

Post

View All

piyush kumar

i have a excel file and i have to read some column from excel and fill in my gridview. can anyone know how to do please help me.

By piyush kumar in ASP.NET on Jun 21 2008

0
4.1k
1

Post Your Answer

Jun, 2008 23
OleDbconnection cn; OleDataAdapter cmd; DataSet ds; cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source= C:\blablabla.xls; Extended properties = Excel 8.0;"); cmd = new OledbDataAdapter(Select * From [Sheet 1$A1:B10],cn); cn.Open(); cmd.Fill(ds); cn.close(); this sample selects range A1/B10 from Sheet1
- 0