111,101
社区成员




Microsoft.Office.Interop.Excel.Workbook workbook = rptExcel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
//这个地方需要你自己写适合自己的东西了
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets.get_Item(1);
Excel.Range titleRange = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, columnCount]);//选取单元格,选取一行或多行
titleRange.Merge(true);//合并单元格
titleRange.Value2 = strTitle; //设置单元格内文本
titleRange.Font.Name = "宋体";//设置字体
titleRange.Font.Size = 18;//字体大小
titleRange.Font.Bold = true;//加粗显示
titleRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;//水平居中
titleRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;//垂直居中
titleRange.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Excel.XlBorderWeight.xlMedium;//边框常规粗细
titleRange.Interior.Color = Color.FromArgb(224, 224, 224);//设置颜色