public ActionResult ExportOperateLogWithExcel()
{
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Sheet1");
var list = db.T_ZC_MemberLog.ToList();
foreach (var log in list)
{
ExcelGenerator.SpreadSheet.Row row = new ExcelGenerator.SpreadSheet.Row();
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.ID.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.StartDateTime.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.EndDateTime.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Message.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(Enum.GetName(typeof(OperateTypes),log.OperateType)));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(Enum.GetName(typeof(GenerateSystem),log.GenerateModule)));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.MemberID.ToString()));
worksheet.Rows.Add(row);
}
workbook.Worksheets.Add(worksheet);
return new ExcelResult(workbook.getBytes(), "Export.xls");
}
public ActionResult ExportErrorLogWithExcel()
{
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("错误日志");
var list = db.T_ZC_CommonLog.Where(l => l.Level == "Error").ToList();
foreach( var log in list)
{
ExcelGenerator.SpreadSheet.Row row = new ExcelGenerator.SpreadSheet.Row();
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.ID.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Level.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Logger.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Message.ToString()));
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Source.ToString()));
if(log.Exception.Length <= 500)
{
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Exception.ToString()));
}
else
{
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.Exception.Substring(0, 500)));
}
row.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(log.User.ToString()));
worksheet.Rows.Add(row);
}
workbook.Worksheets.Add(worksheet);
return new ExcelResult(workbook.getBytes(), "Export.xls");
}
//returns an XLS Stream
public static byte[] GetXLS(IList<IList<string>> table)
{
//Create a workbook
Workbook workbook = new Workbook();
//Create a worksheet
Worksheet worksheet = new Worksheet("Report");
//Create a new row
foreach (var row in table)
{
var xlsRow = new ExcelGenerator.SpreadSheet.Row();
foreach (var col in row)
{
xlsRow.Cells.Add(new ExcelGenerator.SpreadSheet.Cell(col));
}
worksheet.Rows.Add(xlsRow);
}
//Add worksheet to Workbook
workbook.Worksheets.Add(worksheet);
return workbook.getBytes();
}