I am trying to export data from Excel11.0 object to datatable using C#. I can't
properly open workbooks. Can anyone please help me to fix this error. I got the above error when i try to open the Workbooks.Open(___,____, ). I am Beginner So kindly help me.
Here is the code:
String strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strpath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection objconn = new OleDbConnection(strConnection);
if (objconn.State == ConnectionState.Closed)
{
objconn.Open();
}
Excel.Application app = new Excel.Application();
Excel.Workbook lworkbook = app.Workbooks.Open(txtselect.Text, Type.Missing, true, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
lworkbook = app.ActiveWorkbook;
Excel.Sheets lsheets = lworkbook.Worksheets;
Excel.Worksheet lworksheet = (Excel.Worksheet)lsheets.get_Item(1);
lworksheet.Name = "person12";
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter adp = new OleDbDataAdapter("select * from person12", objconn);
adp.Fill(dt);
dataGridView1.DataSource = dt;
objconn.Close();