read excel file

vaishnavi mishal

10y1.1kWindows Forms

Hello

how to read excel file in windows form c#?

4 Replies

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

Paras Kharbanda10y ago
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 Somani10y ago
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();
Priyank Patel10y ago
Too Easy ... please follow the below link

http://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of
Ranjit Powar10y ago
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);