read data from excel sheet

Question

Hi I have one excel sheet where 5 columns are there. How will I read only starting two columns and bind In datatable??

Saikiran Gst · Answer

Hi rachayita jaiswal I hope this code is use full for u check this code code behind:- ------------- if (FlUploadcsv.HasFile) { string FileName = FlUploadcsv.FileName; string path = string.Concat(Server.MapPath(~/Upload/ + FlUploadcsv.FileName)); FlUploadcsv.PostedFile.SaveAs(path); OleDbConnection OleDbcon = new OleDbConnection(Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + path + ;Extended Properties=Excel 12.0;); OleDbCommand cmd1 = new OleDbCommand(SELECT QuestionsId FROM [Sheet1$] OleDbcon); OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(cmd1); dt = new DataTable(); objAdapter1.Fill(dt); } Regards saikiran gst