110,476
社区成员
发帖
与我相关
我的任务
分享
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelName + ";Extended Properties='Excel 8.0;HDR=NO';";
OleDbConnection con = new OleDbConnection(strConn);
OleDbDataAdapter cmd = new OleDbDataAdapter("select top 4 * from ["+GetSheetName(excelName)+"$]", con);
DataSet ds = new DataSet();
try
{
cmd.Fill(ds);
}
catch
{
return null;
}
return ds;
static readonly DateTime march1st1900 = new DateTime(1900, 03, 01);
static readonly DateTime december31st1899 = new DateTime(1899, 12, 31);
static readonly TimeSpan after1stMarchAdjustment = new TimeSpan(1, 0, 0, 0);
public static DateTime ConvertExcelDateToDate(string excelDate)
{
TimeSpan ts = TimeSpan.Parse(excelDate);
DateTime dt = december31st1899+ts;
if (dt >= march1st1900)
{
return dt - after1stMarchAdjustment;
}
return dt;
}
tatic readonly DateTime march1st1900 = new DateTime(1900, 03, 01);
static readonly DateTime december31st1899 = new DateTime(1899, 12, 31);
static readonly TimeSpan after1stMarchAdjustment = new TimeSpan(1, 0, 0, 0);
public static DateTime ConvertExcelDateToDate(string excelDate)
{
TimeSpan ts = TimeSpan.Parse(excelDate);
DateTime dt = december31st1899+ts;
if (dt >= march1st1900)
{
return dt - after1stMarchAdjustment;
}
return dt;
}