从DataGrid导出时格式化Excel工作表标题 [英] Format excel sheet header while exporting from DataGrid

问题描述

亲爱的你好，

我正在将数据从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 :)

这篇关于从DataGrid导出时格式化Excel工作表标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！