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

Export data from excell

Answers (9)