Guest User

btnImport

a guest
Jan 15th, 2018
486
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.01 KB | None | 0 0
  1. using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel Workbook 97-2003|*.xls|Excel Workbook|*.xlsx", ValidateNames = true })
  2.             {
  3.                 if (ofd.ShowDialog() == DialogResult.OK)
  4.                 {
  5.                     FileStream fs = File.Open(ofd.FileName, FileMode.Open, FileAccess.Read);
  6.                     IExcelDataReader reader;
  7.                     if (ofd.FilterIndex == 1)
  8.                         reader = ExcelReaderFactory.CreateBinaryReader(fs);//Read excel 97-2003
  9.                     else
  10.                         reader = ExcelReaderFactory.CreateOpenXmlReader(fs);//Read excel 2007
  11.                     reader.IsFirstRowAsColumnNames = true;
  12.                     result = reader.AsDataSet();
  13.                     cboSheet.Items.Clear();
  14.                     //Add sheet to comboxbox
  15.                     foreach (System.Data.DataTable dt in result.Tables)
  16.                         cboSheet.Items.Add(dt.TableName);
  17.                     reader.Close();
  18.                 }
  19.             }
Advertisement
Add Comment
Please, Sign In to add comment