使用Aspose.Cells组件生成Excel文件实例

           Stylestyle=workbook.Styles[workbook.Styles.Add()];//新增样式

           #region表头
           //标题
           style.HorizontalAlignment=TextAlignmentType.Center;//文字居中 
           style.Font.Name="宋体";//文字字体
           style.Font.Size=18;//文字大小 
           style.Font.IsBold=true;//粗体

           cells.Merge(0,0,1,12);              //合并单元格
           cells[0,0].PutValue("标准化工作意见建议汇总表");  //填写内容
           cells[0,0].SetStyle(style);           //给单元格关联样式 
           cells.SetRowHeight(0,28);             //设置行高 

           //发布时间
           style.HorizontalAlignment=TextAlignmentType.Left;
           style.Font.Size=11;
           style.Font.IsBold=false;
           cells.Merge(1,0,1,7);
           cells[1,0].PutValue(String.Format("发布起止时间：{0}至{1}",DateTime.Now.AddDays(-1).ToString("yyyy年MM月dd日"),DateTime.Now.ToString("yyyy年MM月dd日")));
           cells[1,0].SetStyle(style);
           cells.SetRowHeight(1,20);

           //统计时间
           style.HorizontalAlignment=TextAlignmentType.Right;
           style.Font.Size=11;
           style.Font.IsBold=false;
           cells.Merge(1,7,1,5);
           cells[1,7].PutValue(String.Format("统计时间:{0}",DateTime.Now.ToString("yyyy年MM月dd日")));
           cells[1,7].SetStyle(style);
           cells.SetRowHeight(1,20);
           #endregion

           #region表格

           #region表格标题行
           //序号
           style.HorizontalAlignment=TextAlignmentType.Center;
           cells[2,0].PutValue("序号");
           cells[2,0].SetStyle(style);
           cells.SetRowHeight(2,20);
           cells.SetColumnWidthPixel(0,38);

           //建议时间
           cells[2,1].PutValue("建议时间");
           cells[2,1].SetStyle(style);
           cells.SetColumnWidthPixel(1,77);

           //建议部门
           cells[2,2].PutValue("建议部门");
           cells[2,2].SetStyle(style);
           cells.SetColumnWidthPixel(2,107);

           //建议人
           cells[2,3].PutValue("建议人");
           cells[2,3].SetStyle(style);
           cells.SetColumnWidthPixel(3,69);

           //类  别
           cells[2,4].PutValue("类  别");
           cells[2,4].SetStyle(style);
           cells.SetColumnWidthPixel(4,71);

           //业务种类
           cells[2,5].PutValue("业务种类");
           cells[2,5].SetStyle(style);
           cells.SetColumnWidthPixel(5,71);

           //标准名称
           cells[2,6].PutValue("标准名称");
           cells[2,6].SetStyle(style);
           cells.SetColumnWidthPixel(6,114);

           //标准章、条编号
           cells[2,7].PutValue("标准章、条编号");
           cells[2,7].SetStyle(style);
           cells.SetColumnWidthPixel(7,104);

           //意见建议
           cells[2,8].PutValue("意见建议");
           cells[2,8].SetStyle(style);
           cells.SetColumnWidthPixel(8,255);

           //处理部门
           cells[2,9].PutValue("处理部门");
           cells[2,9].SetStyle(style);
           cells.SetColumnWidthPixel(9,72);

           //处理进度
           cells[2,10].PutValue("处理进度");
           cells[2,10].SetStyle(style);
           cells.SetColumnWidthPixel(10,72);

           //备注
           cells[2,11].PutValue("备注");
           cells[2,11].SetStyle(style);
           cells.SetColumnWidthPixel(11,255);

           #endregion

           #endregion

           System.IO.MemoryStreamms=workbook.SaveToStream();//生成数据流
           byte[]bt=ms.ToArray();

           workbook.Save(@"E:\test.xls");//保存到硬盘
       }