public void TestOpenXmlRead() { var fname = TestData.GetFileName("TestOpenXmlCrate.xlsx"); var dt = ExcelOpenXml.GetSheet(fname, "tab1"); Assert.IsTrue(File.Exists(fname)); }
private void BtnOpenXmlImport_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Title = "导入信息表"; openFileDialog.Filter = "Excel文档(*.xlsx)|*.xlsx"; if (openFileDialog.ShowDialog() == DialogResult.OK) { //var dataTable = ExcelOpenXml.GetSheet(openFileDialog.FileName); var dataTable = ExcelOpenXml.GetSheet(openFileDialog.FileName); gridView.DataSource = dataTable; } }
public void TestOpenXmlCrate() { var fname = TestData.GetNewExcelFileName("TestOpenXmlCrate.xlsx"); var dt1 = TestData.GetDataTable(tabName: "tab1"); var dt2 = TestData.GetDataTable(tabName: "tab2"); DataSet ds = new DataSet(); ds.Tables.Add(dt1); ds.Tables.Add(dt2); ExcelOpenXml.Create(fname, ds); Assert.IsTrue(File.Exists(fname)); }
// 导出日志 public void ExportLog(int?type, string logOperator, string startTime, string endTime) { List <Log.Entity.LogEntity> logList = Log.Service.LogService.SearchList(type, logOperator, startTime, endTime); string excelPath = HttpContext.Server.MapPath("~/Excel"); if (!System.IO.Directory.Exists(excelPath)) { System.IO.Directory.CreateDirectory(excelPath); } List <ColHeader> colHeaderList = new List <ColHeader>(); ExcelOpenXml excel = new ExcelOpenXml(excelPath); colHeaderList.Add(new ColHeader("Id", "序号", ColDataType.Number) { CustomHeaderFunc = CellFormat }); colHeaderList.Add(new ColHeader("TypeExp", "日志类型", ColDataType.String) { CustomHeaderFunc = CellFormat }); colHeaderList.Add(new ColHeader("OperatorExp", "操作人", ColDataType.String) { CustomHeaderFunc = CellFormat }); colHeaderList.Add(new ColHeader("OperateModule", "操作模块", ColDataType.String) { CustomHeaderFunc = CellFormat }); colHeaderList.Add(new ColHeader("OperateTimeExp", "操作时间", ColDataType.String) { CustomHeaderFunc = CellFormat }); colHeaderList.Add(new ColHeader("Msg", "日志内容", ColDataType.String) { CustomHeaderFunc = CellFormat }); excel.ExportToExcel <Log.Entity.LogEntity>(logList, colHeaderList, "日志", null); }