利用Aspose.Cells 导出数据到excel 。需要引入Aspose.Cells.dll;
具体使用方法贴代码:
private string ExportProjectReportExcel(List<ProjectReportDetail> prdlist, string ProjectReportName)
{
//新建工作簿
Workbook wb = new Workbook();
//新建样式
Style style = wb.Styles[wb.Styles.Add()];
//设置单元格水平居中对齐和垂直居中对齐
style.HorizontalAlignment = TextAlignmentType.Center;
//新建工作表
Worksheet ws = wb.Worksheets[0];
//ws.ClearComments();
//添加标题内容
ws.Cells[0, 0].PutValue("项目团队");
ws.Cells[0, 1].PutValue("任务名称");
ws.Cells[0, 2].PutValue("人员分工");
ws.Cells[0, 3].PutValue("开始时间");
ws.Cells[0, 4].PutValue("结束时间");
ws.Cells[0, 5].PutValue("总数量");
ws.Cells[0, 6].PutValue("累计完成数量");