The Engineering Behind Enterprise AI

Read Excel using Dotnet application

Amit Patriwala

July 5, 2008

steps:

1) create simple dotnet application(here i am used C#.net)

2) put the below code

//add namespace
using System.Data.OleDb;
//read Excel File
string FilePath =”c:\test.xls”;
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ FilePath +";Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select * from [sheet1$]", con);
DataTable dt = new DataTable();
//get data in datatable
da.Fill(dt);

Thnx

Asp.Net 2.0, dotnet

2 responses to “Read Excel using Dotnet application”

alpesh

January 22, 2010

i faced here some problem Like : –

External table is not in the expected format

actually my req. is system generate xls file n then user will update some col.

then again nedd to import in DB .. at that time i face above error : External table is not in the expected format.

i hope u will reply for suggestion…

Reply
kricksen

January 6, 2011

thanks for providing the simple example for reading excel files

Reply

Read Excel using Dotnet application

2 responses to “Read Excel using Dotnet application”

Leave a ReplyCancel reply

Discover more from The Engineering Behind Enterprise AI