public void Export2Excel() { var dt = new DataTable(); dt.Columns.Add("AutoID", typeof(int)); dt.Columns.Add("UserName", typeof(string)); dt.Columns.Add("Birthday", typeof(DateTime)); dt.Columns.Add("RegTime", typeof(DateTime)); var row1 = dt.NewRow(); row1["AutoID"] = 1; row1["UserName"] = "******"; row1["Birthday"] = new DateTime(1999, 9, 9); row1["RegTime"] = DateTime.Now; dt.Rows.Add(row1); var row2 = dt.NewRow(); row2["AutoID"] = 2; row2["UserName"] = "******"; row2["Birthday"] = new DateTime(2020, 9, 9); row2["RegTime"] = DateTime.Now; dt.Rows.Add(row2); //只输出日期 EPPlusUtils.Export(dt, SystemUtils.GetMapPath("/TestSource/EPPlusTest1.xlsx"), "Sheet1", "E3", "yyyy-mm-dd"); //分别输出日期和时间 EPPlusUtils.Export(dt, SystemUtils.GetMapPath("/TestSource/EPPlusTest2.xlsx"), "Sheet1", "E3", "yyyy-mm-dd,yyyy-mm-dd HH:mm:ss"); }
public void ReadExcel() { var excelFilePath = SystemUtils.GetMapPath("TestSource/通讯录.xlsx"); var dt = EPPlusUtils.Read(excelFilePath); Assert.AreEqual(true, dt.Rows.Count > 0); Assert.AreEqual("Jsonlee", EPPlusUtils.ReadCell(excelFilePath, "B2")); }