Export data from OpenOffice to DataTable/Dataset

Question

I am having Openoffice excel sheet that contains some fields like statedistricttalukazoneregionterritory i want to store excel sheet data into datatable Please any body help me Thanks.

Gopal Mahadak · Answer

Please Add Reference of Microsoft.Office.Interop.Excel from references... using System.Data.OleDb; using excel = Microsoft.Office.Interop.Excel; using System.IO; //////////for opening excel file OpenFileDialog o = new OpenFileDialog(); o.Filter = |*.xls; o.Filter = Excel files |*.xls; o.Title = select your Excel attachment ; if (o.ShowDialog() == System.Windows.Forms.DialogResult.OK) { txtFilePath.Text = o.FileName; } str=Path.GetFileName(txtFilePath.Text.ToString()); txtFilePath.Text = str; /////////////uploading excel file in Datatable excel._Application ae = new excel.Application(); excel.Workbook we = ae.Workbooks.Open(txtFilePath.Text); excel.Worksheet ws = ae.Worksheets.get_Item(1); excel.Range re = ws.UsedRange; DataTable dt = new DataTable(); dt.Columns.Add(Taluka);//adding column to datatable similar to excel sheet dt.Columns.Add(Place); for (row = 2; row { DataRow dr = dt.NewRow(); for (column = 1; column { dr[column - 1] = (re.Cells[row column] as Microsoft.Office.Interop.Excel.Range).Value2.ToString(); } dt.Rows.Add(dr); } we.Close(); ae.Quit();