read excel file

Question

Hello how to read excel file in windows form c#?

Priyank Patel · Answer

Too Easy ... please follow the below link http://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of

Paras Kharbanda · Answer

Hi vaishnavi! for reading excel file you can use NPOI library for Windows Through this you can read excel file and can also convert to xml also. Using filestream read excel file and create workbook having Worksheet etc.

Sourabh Somani · Answer

Read My Article Read Excel Sheet Data //Coneection String by default empty string ConStr = "" ; //getting the path of the file string path = "[Path]" string ext=path.Split('.')[path.Split('.').Length-1]; //checking that extantion is .xls or .xlsx if (ext.Trim() == ".xls" ) { //connection string for that file which extantion is .xls ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"" ; } else if (ext.Trim() == ".xlsx" ) { //connection string for that file which extantion is .xlsx ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"" ; } //making query string query = "SELECT * FROM [Sheet1$]" ; //Providing connection OleDbConnection conn = new OleDbConnection(ConStr); //checking that connection state is closed or not if closed the //open the connection if (conn.State == ConnectionState.Closed) { conn.Open(); } //create command object OleDbCommand cmd = new OleDbCommand(query, conn); // create a data adapter and get the data into dataadapter OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); //fill the Excel data to data set da.Fill(ds); //close the connection conn.Close();

Ranjit Powar · Answer

First add namespace using System.Data.OleDb; And then use following code OleDbConnection OleDbcon = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=Excel 12.0;"); OleDbCommand OledbCmd = new OleDbCommand("Select * from [Sheet1$]", OleDbcon); OleDbDataAdapter oledbDa = new OleDbDataAdapter(OledbCmd); DataSet ds = new DataSet(); oledbDa.Fill(ds);

read excel file

Answers (4)