public ActionResult export(string name)
{
var user = OperatorProvider.Provider.Current();
//取出数据源
int total = 0;
DataTable exportTable = workmeetingbll.getExport(name);
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
//excelconfig.Title = "违章信息";
//excelconfig.TitleFont = "微软雅黑";
//excelconfig.TitlePoint = 25;
excelconfig.HeadHeight = 50;
excelconfig.HeadPoint = 12;
excelconfig.HeadFont = "宋体";
excelconfig.FileName = "危险预知训练导出.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "jobcontent", ExcelColumn = "作业内容", Width = 12, Alignment = "fill"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "workquarters", ExcelColumn = "作业岗位", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "usetime", ExcelColumn = "使用次数", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "redactiondate", ExcelColumn = "修订时间", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "redactionperson", ExcelColumn = "修订人", Width = 18
});
//调用导出方法
ExcelHelper.ExcelDownload(exportTable, excelconfig);
return(Success("导出成功。"));
}
