从DataGrid导出时格式化Excel工作表标题
问题描述:
亲爱的你好,
我正在将数据从DataGrid导出为
Hello dear,
I am exporting data from DataGrid as
Workbook workbook = new Workbook();
// create a worksheet object
Worksheet worksheet = new Worksheet("Enterprise_Summary_Reports");
// for header
foreach (DataGridColumn dgcol in datagrid1.Columns)
{
worksheet.Cells[0, ColumnCount] = new Cell(dgcol.Header.ToString());
CellStyle css = new CellStyle();
css.BackColor = (Color)Colors.Red;
worksheet.Cells[0, ColumnCount].Style = css;
ColumnCount++;
}
// statements for adding rows
workbook.Worksheets.Add(worksheet);
// get the selected file''s stream
Stream sFile = sDialog.OpenFile();
workbook.Save(sFile);
通过此操作我的文件被正确保存,但是我分配给标题行的格式,即 BackColor为红色不在Excel工作表中显示.
请为我建议正确的方法.
在此先感谢
By this my file get saved properly but the formatting which i assigned to header row i.e BackColor is Red not displayed in excel sheet.
Please suggest me proper way for this.
Thanks in advance
答
嗨
使用这个
Microsoft.Office.Interop.Excel.Range rngTableHeading = excel.get_Range("A2","IV2");
rngTableHeading.Font.Name ="Calibri";
rngTableHeading.Font.Size ="12";
rngTableHeading.Font.Bold = true;
rngTableHeading.Interior.ColorIndex = 36;
rngTableHeading.Rows.AutoFit();
通过
Shan.R
Hi
Use this
Microsoft.Office.Interop.Excel.Range rngTableHeading = excel.get_Range("A2", "IV2");
rngTableHeading.Font.Name = "Calibri";
rngTableHeading.Font.Size = "12";
rngTableHeading.Font.Bold = true;
rngTableHeading.Interior.ColorIndex = 36;
rngTableHeading.Rows.AutoFit();
By
Shan.R
为什么不尝试ExcelPackage.dll:)
why don''t you try ExcelPackage.dll :)