private DataSet ReadExcel(string pFileName)
{
if (pFileName.Equal(""))
{
return null;
}
string vConn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; Extended Properties=Excel 8.0;", pFileName);
OleDbDataAdapter vExcelAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]", vConn);
DataSet vData = new DataSet();
try
{
vExcelAdapter.Fill(vData);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return vData ;
}
{
if (pFileName.Equal(""))
{
return null;
}
string vConn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}; Extended Properties=Excel 8.0;", pFileName);
OleDbDataAdapter vExcelAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]", vConn);
DataSet vData = new DataSet();
try
{
vExcelAdapter.Fill(vData);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return vData ;
}