Export data from excell

mary jean ligas

12y1.4kVisual Basic .NET

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anupam Singh12y ago
Accepted 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..
0
mary jean ligas12y ago
I've tried to bind it to a grid is just beacause i want to see the value of cells that extracted from excell..
0
mary jean ligas12y ago
Heres' my template
0
Anupam Singh12y ago
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.
0
arun prasath12y ago
Refer this :https://code.google.com/p/excellibrary/
0
mary jean ligas12y ago
please give me the sample code
0
arun prasath12y ago
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
0
mary jean ligas12y ago
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];
0
Anupam Singh12y ago
Hi mary jeans,

read a nice example here
0