Export data from excell

Question

Please help me on how to extract selected excell cell then pass it to textbox in asp.net c#..please let me know

Anupam Singh · Answer

Hi mary :( your file having some readonly (security issues). I am attaching a website here with my text excel file. you just have to run this website in you system. hope this will help you..

mary jean ligas · Answer

I've tried to bind it to a grid is just beacause i want to see the value of cells that extracted from excell..

mary jean ligas · Answer

Heres' my template

Anupam Singh · Answer

Mary can you share excel file. Because you are saying that data should be in textbox but here in this code you are binding in grid.

arun prasath · Answer

Refer this : https://code.google.com/p/excellibrary/

mary jean ligas · Answer

please give me the sample code

arun prasath · Answer

Try excel library if only xls file or if yu want .xlsx too means try excel data reader. not with oledb.am not familiar with OLEDB

mary jean ligas · Answer

Heres my excell template i want to get those on yellow fills and get their values and pass to textbox..please help me how heres my snippet: string { connString = } { connString = } connString =  ; string fileType = Path .GetExtension(file.FileName).ToLower(); string fileName = Path .GetFileName(file.FileName); string path = file.PostedFile.FileName; if (fileType.Trim() == .xls ) Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + path + ;Extended Properties=\Excel 8.0;HDR=Yes;IMEX=2\ ; else if (fileType.Trim() == .xlsx ) Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + path + ;Extended Properties=\Excel 12.0;HDR=Yes;IMEX=2\ ; //string query = select [Vendor#][Vendor Name][E-mail][Account Number][Total Amount][Remarks] from [Sheet1$]; //string query = select [VATINC] from [Sheet1$E9];[Sheet1$A1:A1] { conn.Open(); string query = select * from [Sheet1$] ; OleDbConnection conn = new OleDbConnection (connString); if (conn.State == ConnectionState .Closed) OleDbCommand cmd = new OleDbCommand (query conn); OleDbDataAdapter adapter = new OleDbDataAdapter (cmd); //DataTable table = new DataTable(); adapter.Fill(ds); { GridView1.DataSource = data; GridView1.DataBind(); } DataSet ds = new DataSet (); foreach ( DataRow dr in ds.Tables[0].Rows) string data = dr[0] dr[1] dr[2];

Anupam Singh · Answer

Hi mary jeans read a nice example here