Using system;
Using system. Data;
Using system. Data. oledb;
Namespace legendigital. Swim. Common
{
/// <Summary>
/// Summary description for excel.
/// </Summary>
Publicclass Excel
{
Privateconststring string_conecttionstring = "provider = Microsoft. Jet. oledb.4.0; Data Source = {0}; extended properties =" Excel 8.0; HDR = yes; IMEX = 1 ;"";
Public Excel ()
{
//
// Todo: Add constructor logic here
//
}
Publicstatic datatable getdatatable (string excelfilepath, string SQL)
{
Try
{
Dataset DS = new dataset ();
String connstring = string. Format (string_conecttionstring, excelfilepath );
Using (oledbconnection CNN = new oledbconnection (connstring ))
{
CNN. open ();
Oledbdataadapter dataadapter = new oledbdataadapter (SQL, CNN );
Dataadapter. Fill (DS );
CNN. Close ();
Return Ds. Tables [0];
}
}
Finally
{
}
}
Publicstatic dataset filldataset (string excelfilepath, string SQL, dataset DS)
{
Datatable dt = getdatatable (excelfilepath, SQL );
Foreach (datarow DR in DT. Rows)
{
Try
{
Datarow newdr = Ds. Tables [0]. newrow ();
Foreach (datacolumn DC in DT. columns)
{
If (Ds. Tables [0]. Columns. Contains (DC. columnname ))
{
Newdr [DC. columnname] = Dr [DC. columnname];
}
}
DS. Tables [0]. Rows. Add (newdr );
}
Catch
{
}
}
DS. acceptchanges ();
Return Ds;
}
}
}