Willcode4cash icon

Extract Worksheet to DataTable

Willcode4cash | PRO | 09/23/16 04:24:27 AM UTC | 0 ⭐ | 245 👁️ | Never ⏰ | []
C# |

430 B

|

None

|

0 👍

/

0 👎

DataTable LoadWorksheetInDataTable(string fileName, string sheetName)
{
    DataTable sheetData = new DataTable();
    using (OleDbConnection conn = this.returnConnection(fileName))
    {
        conn.Open();
        // retrieve the data using data adapter
        OleDbDataAdapter sheetAdapter = new OleDbDataAdapter("select F2, F4 from [" + sheetName + "]", conn);
        sheetAdapter.Fill(sheetData);
    }
    return sheetData;
}

Comments