Advertisement
Willcode4cash

Extract Worksheet to DataTable

Sep 22nd, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.43 KB | None | 0 0
  1. DataTable LoadWorksheetInDataTable(string fileName, string sheetName)
  2. {
  3.     DataTable sheetData = new DataTable();
  4.     using (OleDbConnection conn = this.returnConnection(fileName))
  5.     {
  6.         conn.Open();
  7.         // retrieve the data using data adapter
  8.         OleDbDataAdapter sheetAdapter = new OleDbDataAdapter("select F2, F4 from [" + sheetName + "]", conn);
  9.         sheetAdapter.Fill(sheetData);
  10.     }
  11.     return sheetData;
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement