/// <summary> /// /// </summary> /// <param name="range"></param> /// <param name="title"></param> private void FormatHeader(Excel.Range range, string title) { range.Merge(true); range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; range.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; range.Value2 = title; range.RowHeight = 35; range.Font.Name = "Arial Unicode MS"; range.Font.Bold = true; range.Font.Size = 20; range.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black); }