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);
}
