/**/
/// <summary>
/// 初始化Excel Workbook
/// </summary>
/// <param name="book">book</param>
private void InitializeBook(Workbook book)
{
book.Properties.Author = Author; //作者
book.Properties.LastAuthor = LastAuthor; //最后作者
book.Properties.Created = DateTime.Now; //创建时间
book.Properties.Company = Company; //公司
book.Properties.Version = Version; //版本
book.ExcelWorkbook.WindowHeight = 13500;
book.ExcelWorkbook.WindowWidth = 17100;
book.ExcelWorkbook.WindowTopX = 360;
book.ExcelWorkbook.WindowTopY = 75;
book.ExcelWorkbook.ProtectWindows = false;
book.ExcelWorkbook.ProtectStructure = false;
}
/**/
/// <summary>
/// 设置样式
/// </summary>
/// <param name="styles">样式集合</param>
private void SetStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "宋体";
Default.Font.Size = 12;
Default.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// TitleStyle
// -----------------------------------------------
WorksheetStyle TitleStyle = styles.Add("TitleStyle");
TitleStyle.Font.Bold = true;
TitleStyle.Font.FontName = "黑体";
TitleStyle.Font.Size = 14;
TitleStyle.Alignment.Horizontal = StyleHorizontalAlignment.Center;
TitleStyle.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// FieldStyle
// -----------------------------------------------
WorksheetStyle FieldStyle = styles.Add("FieldStyle");
FieldStyle.Font.Bold = true;
FieldStyle.Font.FontName = "宋体";
FieldStyle.Font.Size = 12;
FieldStyle.Alignment.Horizontal = StyleHorizontalAlignment.Center;
FieldStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// LastFieldStyle
// -----------------------------------------------
WorksheetStyle LastFieldStyle = styles.Add("LastFieldStyle");
LastFieldStyle.Font.Bold = true;
LastFieldStyle.Font.FontName = "宋体";
LastFieldStyle.Font.Size = 12;
LastFieldStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// DataStyle
// -----------------------------------------------
WorksheetStyle DataStyle = styles.Add("DataStyle");
DataStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
}
/**/
/// <summary>
/// 初始化Excel Workbook
/// </summary>
/// <param name="book">book</param>
private void InitializeBook(Workbook book)
{
book.Properties.Author = Author;//作者
book.Properties.LastAuthor = LastAuthor;//最后作者
book.Properties.Created = DateTime.Now;//创建时间
book.Properties.Company = Company;//公司
book.Properties.Version = Version;//版本
book.ExcelWorkbook.WindowHeight = 13500;
book.ExcelWorkbook.WindowWidth = 17100;
book.ExcelWorkbook.WindowTopX = 360;
book.ExcelWorkbook.WindowTopY = 75;
book.ExcelWorkbook.ProtectWindows = false;
book.ExcelWorkbook.ProtectStructure = false;
}
/**/
/// <summary>
/// 设置样式
/// </summary>
/// <param name="styles">样式集合</param>
private void SetStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "宋体";
Default.Font.Size = 12;
Default.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// TitleStyle
// -----------------------------------------------
WorksheetStyle TitleStyle = styles.Add("TitleStyle");
TitleStyle.Font.Bold = true;
TitleStyle.Font.FontName = "黑体";
TitleStyle.Font.Size = 14;
TitleStyle.Alignment.Horizontal = StyleHorizontalAlignment.Center;
TitleStyle.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// FieldStyle
// -----------------------------------------------
WorksheetStyle FieldStyle = styles.Add("FieldStyle");
FieldStyle.Font.Bold = true;
FieldStyle.Font.FontName = "宋体";
FieldStyle.Font.Size = 12;
FieldStyle.Alignment.Horizontal = StyleHorizontalAlignment.Center;
FieldStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
FieldStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// LastFieldStyle
// -----------------------------------------------
WorksheetStyle LastFieldStyle = styles.Add("LastFieldStyle");
LastFieldStyle.Font.Bold = true;
LastFieldStyle.Font.FontName = "宋体";
LastFieldStyle.Font.Size = 12;
LastFieldStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
LastFieldStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// DataStyle
// -----------------------------------------------
WorksheetStyle DataStyle = styles.Add("DataStyle");
DataStyle.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
DataStyle.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
}
private static void GenerateStyles(WorksheetStyleCollection styles)
{
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
WorksheetStyle quantity = styles.Add("Number");
quantity.NumberFormat = "0";
WorksheetStyle euro = styles.Add("Euro");
euro.NumberFormat = "\"€\"\\ #,##0.00_-";
WorksheetStyle header = styles.Add("Header");
header.Font.Bold = true;
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Arial";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s63
// -----------------------------------------------
WorksheetStyle s63 = styles.Add("s63");
s63.Font.FontName = "Times New Roman";
s63.Font.Size = 20;
s63.Font.Color = "#FFFFFF";
s63.Interior.Color = "#000000";
s63.Interior.Pattern = StyleInteriorPattern.Solid;
s63.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s63.Alignment.Vertical = StyleVerticalAlignment.Center;
s63.Alignment.WrapText = true;
s63.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s64
// -----------------------------------------------
WorksheetStyle s64 = styles.Add("s64");
s64.Font.FontName = "Times New Roman";
s64.Font.Size = 11;
s64.Font.Color = "#FFFFFF";
s64.Interior.Color = "#000000";
s64.Interior.Pattern = StyleInteriorPattern.Solid;
s64.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s64.Alignment.Vertical = StyleVerticalAlignment.Top;
s64.Alignment.WrapText = true;
s64.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s65
// -----------------------------------------------
WorksheetStyle s65 = styles.Add("s65");
s65.Font.FontName = "Times New Roman";
s65.Font.Size = 12;
s65.Font.Color = "#333399";
s65.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s65.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s65.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s66
// -----------------------------------------------
WorksheetStyle s66 = styles.Add("s66");
s66.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s66.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s67
// -----------------------------------------------
WorksheetStyle s67 = styles.Add("s67");
s67.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s67.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s68
// -----------------------------------------------
WorksheetStyle s68 = styles.Add("s68");
s68.Font.FontName = "Times New Roman";
s68.Font.Size = 12;
s68.Font.Color = "#333333";
s68.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s68.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s68.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s69
// -----------------------------------------------
WorksheetStyle s69 = styles.Add("s69");
s69.Font.FontName = "Times New Roman";
s69.Font.Size = 12;
s69.Font.Color = "#333333";
s69.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s69.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s69.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
s69.NumberFormat = "Currency";
// -----------------------------------------------
// s70
// -----------------------------------------------
WorksheetStyle s70 = styles.Add("s70");
s70.Font.FontName = "Times New Roman";
s70.Font.Size = 11;
s70.Font.Color = "#000000";
s70.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s70.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s70.NumberFormat = "Currency";
// -----------------------------------------------
// s71
// -----------------------------------------------
WorksheetStyle s71 = styles.Add("s71");
s71.Font.FontName = "Times New Roman";
s71.Font.Size = 12;
s71.Font.Color = "#333399";
s71.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s71.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s71.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s72
// -----------------------------------------------
WorksheetStyle s72 = styles.Add("s72");
s72.Font.FontName = "Segoe UI";
s72.Font.Size = 12;
s72.Font.Color = "#333333";
s72.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s72.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s72.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s73
// -----------------------------------------------
WorksheetStyle s73 = styles.Add("s73");
s73.Font.FontName = "Arial";
s73.Font.Size = 12;
s73.Font.Color = "#333333";
s73.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s73.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s73.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
s73.NumberFormat = "Currency";
// -----------------------------------------------
// s74
// -----------------------------------------------
WorksheetStyle s74 = styles.Add("s74");
s74.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s74.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s74.NumberFormat = "Currency";
// -----------------------------------------------
// s75
// -----------------------------------------------
WorksheetStyle s75 = styles.Add("s75");
s75.Font.FontName = "Arial";
s75.Font.Size = 12;
s75.Font.Color = "#000000";
s75.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s75.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s75.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s76
// -----------------------------------------------
WorksheetStyle s76 = styles.Add("s76");
s76.Font.Bold = true;
s76.Font.Italic = true;
s76.Font.FontName = "Times New Roman";
s76.Font.Size = 12;
s76.Font.Color = "#333399";
s76.Interior.Color = "#FFFF99";
s76.Interior.Pattern = StyleInteriorPattern.Solid;
s76.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s76.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s76.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s77
// -----------------------------------------------
WorksheetStyle s77 = styles.Add("s77");
s77.Font.Bold = true;
s77.Font.Italic = true;
s77.Font.FontName = "Times New Roman";
s77.Font.Size = 12;
s77.Font.Color = "#333399";
s77.Interior.Color = "#FFFF99";
s77.Interior.Pattern = StyleInteriorPattern.Solid;
s77.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s77.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s77.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
s77.NumberFormat = "\"¤\"\\ #,##0.00";
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Arial";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s63
// -----------------------------------------------
WorksheetStyle s63 = styles.Add("s63");
s63.Font.FontName = "Times New Roman";
s63.Font.Size = 20;
s63.Font.Color = "#FFFFFF";
s63.Interior.Color = "#000000";
s63.Interior.Pattern = StyleInteriorPattern.Solid;
s63.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s63.Alignment.Vertical = StyleVerticalAlignment.Center;
s63.Alignment.WrapText = true;
s63.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s64
// -----------------------------------------------
WorksheetStyle s64 = styles.Add("s64");
s64.Font.FontName = "Times New Roman";
s64.Font.Size = 11;
s64.Font.Color = "#FFFFFF";
s64.Interior.Color = "#000000";
s64.Interior.Pattern = StyleInteriorPattern.Solid;
s64.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s64.Alignment.Vertical = StyleVerticalAlignment.Top;
s64.Alignment.WrapText = true;
s64.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s65
// -----------------------------------------------
WorksheetStyle s65 = styles.Add("s65");
s65.Font.FontName = "Times New Roman";
s65.Font.Size = 12;
s65.Font.Color = "#333399";
s65.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s65.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s65.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s66
// -----------------------------------------------
WorksheetStyle s66 = styles.Add("s66");
s66.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s66.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s67
// -----------------------------------------------
WorksheetStyle s67 = styles.Add("s67");
s67.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s67.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s68
// -----------------------------------------------
WorksheetStyle s68 = styles.Add("s68");
s68.Font.FontName = "Times New Roman";
s68.Font.Size = 12;
s68.Font.Color = "#333333";
s68.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s68.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s68.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s69
// -----------------------------------------------
WorksheetStyle s69 = styles.Add("s69");
s69.Font.FontName = "Times New Roman";
s69.Font.Size = 12;
s69.Font.Color = "#333333";
s69.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s69.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s69.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
s69.NumberFormat = "Currency";
// -----------------------------------------------
// s70
// -----------------------------------------------
WorksheetStyle s70 = styles.Add("s70");
s70.Font.FontName = "Times New Roman";
s70.Font.Size = 11;
s70.Font.Color = "#000000";
s70.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s70.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s70.NumberFormat = "Currency";
// -----------------------------------------------
// s71
// -----------------------------------------------
WorksheetStyle s71 = styles.Add("s71");
s71.Font.FontName = "Times New Roman";
s71.Font.Size = 12;
s71.Font.Color = "#333399";
s71.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s71.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s71.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s72
// -----------------------------------------------
WorksheetStyle s72 = styles.Add("s72");
s72.Font.FontName = "Segoe UI";
s72.Font.Size = 12;
s72.Font.Color = "#333333";
s72.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s72.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s72.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s73
// -----------------------------------------------
WorksheetStyle s73 = styles.Add("s73");
s73.Font.FontName = "Arial";
s73.Font.Size = 12;
s73.Font.Color = "#333333";
s73.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s73.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s73.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
s73.NumberFormat = "Currency";
// -----------------------------------------------
// s74
// -----------------------------------------------
WorksheetStyle s74 = styles.Add("s74");
s74.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s74.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s74.NumberFormat = "Currency";
// -----------------------------------------------
// s75
// -----------------------------------------------
WorksheetStyle s75 = styles.Add("s75");
s75.Font.FontName = "Arial";
s75.Font.Size = 12;
s75.Font.Color = "#000000";
s75.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s75.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s75.Alignment.ReadingOrder = StyleReadingOrder.LeftToRight;
// -----------------------------------------------
// s76
// -----------------------------------------------
WorksheetStyle s76 = styles.Add("s76");
s76.Font.Bold = true;
s76.Font.Italic = true;
s76.Font.FontName = "Times New Roman";
s76.Font.Size = 12;
s76.Font.Color = "#333399";
s76.Interior.Color = "#FFFF99";
s76.Interior.Pattern = StyleInteriorPattern.Solid;
s76.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s76.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s76.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
// -----------------------------------------------
// s77
// -----------------------------------------------
WorksheetStyle s77 = styles.Add("s77");
s77.Font.Bold = true;
s77.Font.Italic = true;
s77.Font.FontName = "Times New Roman";
s77.Font.Size = 12;
s77.Font.Color = "#333399";
s77.Interior.Color = "#FFFF99";
s77.Interior.Pattern = StyleInteriorPattern.Solid;
s77.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s77.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s77.Alignment.ReadingOrder = StyleReadingOrder.RightToLeft;
s77.NumberFormat = "\"¤\"\\ #,##0.00";
}
private void GenerarEstilos(WorksheetStyleCollection styles)
{
//[Default]
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Formata Regular";
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
WorksheetStyle s16 = styles.Add("s16");
s16.Name = "Millares";
s16.NumberFormat = "_ * #,##0.00_ ;_ * \\-#,##0.00_ ;_ * " + "-" + "??_ ;_ @_ ";
WorksheetStyle s31 = styles.Add("s31");
s31.Font.FontName = "Tahoma";
s31.Font.Size = 8;
s31.Font.Color = "#000000";
s31.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s31.Alignment.Vertical = StyleVerticalAlignment.Center;
s31.Alignment.WrapText = true;
s31.NumberFormat = "@";
WorksheetStyle s32 = styles.Add("s32");
s32.Font.FontName = "Formata Regular";
s32.NumberFormat = "#####";
s32.Font.Color = "#000000";
s32.Alignment.Vertical = StyleVerticalAlignment.Center;
WorksheetStyle s62 = styles.Add("s62");
s62.Alignment.Vertical = StyleVerticalAlignment.Center;
WorksheetStyle s63 = styles.Add("s63");
s63.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s63.Alignment.Vertical = StyleVerticalAlignment.Center;
WorksheetStyle s65 = styles.Add("s65");
s65.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s65.Alignment.Vertical = StyleVerticalAlignment.Center;
WorksheetStyle s84 = styles.Add("s84");
s84.Interior.Color = "#BFBFBF";
s84.Interior.Pattern = StyleInteriorPattern.Solid;
s84.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s84.Alignment.Vertical = StyleVerticalAlignment.Center;
s84.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s84.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s84.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s84.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
WorksheetStyle s85 = styles.Add("s85");
s85.Alignment.Vertical = StyleVerticalAlignment.Center;
s85.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s85.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s85.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s85.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
WorksheetStyle s86 = styles.Add("s86");
s86.Parent = "s16";
s86.Font.FontName = "Formata Regular";
s86.Font.Color = "#000000";
s86.Alignment.Vertical = StyleVerticalAlignment.Center;
;
WorksheetStyle s87 = styles.Add("s87");
s87.Font.FontName = "Formata Regular";
s87.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s87.Alignment.Vertical = StyleVerticalAlignment.Center;
s87.Alignment.WrapText = true;
//WorksheetStyle s88 = styles.Add("s88");
//s88.Alignment.Horizontal = StyleHorizontalAlignment.Center;
//s88.Alignment.Vertical = StyleVerticalAlignment.Center;
//s88.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s88.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s88.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s88.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
//s88.NumberFormat = "@";
//WorksheetStyle s89 = styles.Add("s89");
//s89.Parent = "s16";
//s89.Font.FontName = "Formata Regular";
//s89.Font.Color = "#000000";
//s89.Alignment.Vertical = StyleVerticalAlignment.Center;
//s89.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s89.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s89.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s89.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
//s89.NumberFormat = "_ * #,##0.00_ ;_ * \\-#,##0.00_ ;_ * " + "-" + "??_ ;_ @_ ";
WorksheetStyle s94 = styles.Add("s94");
s94.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s94.Alignment.Vertical = StyleVerticalAlignment.Center;
s94.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s94.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s94.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s94.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// m66637088
// -----------------------------------------------
WorksheetStyle m66637088 = styles.Add("m66637088");
m66637088.Font.Bold = true;
m66637088.Font.FontName = "Times New Roman";
m66637088.Font.Size = 11;
m66637088.Font.Color = "#000000";
m66637088.Interior.Color = "#8DB4E3";
m66637088.Interior.Pattern = StyleInteriorPattern.Solid;
m66637088.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m66637088.Alignment.Vertical = StyleVerticalAlignment.Center;
m66637088.Alignment.WrapText = true;
m66637088.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
m66637088.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
m66637088.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// m66637108
// -----------------------------------------------
WorksheetStyle m66637108 = styles.Add("m66637108");
m66637108.Font.Bold = true;
m66637108.Font.FontName = "Times New Roman";
m66637108.Font.Size = 11;
m66637108.Font.Color = "#FF0000";
m66637108.Interior.Color = "#FFFF00";
m66637108.Interior.Pattern = StyleInteriorPattern.Solid;
m66637108.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m66637108.Alignment.Vertical = StyleVerticalAlignment.Center;
m66637108.Alignment.WrapText = true;
m66637108.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
m66637108.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
m66637108.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
m66637108.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// m66637128
// -----------------------------------------------
WorksheetStyle m66637128 = styles.Add("m66637128");
m66637128.Font.FontName = "Times New Roman";
m66637128.Font.Size = 11;
m66637128.Font.Color = "#000000";
m66637128.Interior.Color = "#FFFFFF";
m66637128.Interior.Pattern = StyleInteriorPattern.Solid;
m66637128.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m66637128.Alignment.Vertical = StyleVerticalAlignment.Center;
m66637128.Alignment.WrapText = true;
m66637128.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
m66637128.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
m66637128.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
m66637128.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
m66637128.NumberFormat = "Standard";
// -----------------------------------------------
// s62
// -----------------------------------------------
WorksheetStyle s62 = styles.Add("s62");
s62.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s62.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s64
// -----------------------------------------------
WorksheetStyle s64 = styles.Add("s64");
s64.Font.Bold = true;
s64.Font.FontName = "Times New Roman";
s64.Font.Size = 11;
s64.Font.Color = "#000000";
s64.Interior.Color = "#FAC090";
s64.Interior.Pattern = StyleInteriorPattern.Solid;
s64.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s64.Alignment.Vertical = StyleVerticalAlignment.Center;
s64.Alignment.WrapText = true;
s64.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s64.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s64.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s64.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s65
// -----------------------------------------------
WorksheetStyle s65 = styles.Add("s65");
s65.Font.FontName = "Times New Roman";
s65.Font.Size = 11;
s65.Font.Color = "#000000";
s65.Interior.Color = "#FFFFFF";
s65.Interior.Pattern = StyleInteriorPattern.Solid;
s65.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s65.Alignment.Vertical = StyleVerticalAlignment.Center;
s65.Alignment.WrapText = true;
s65.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s65.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s65.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s65.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s66
// -----------------------------------------------
WorksheetStyle s66 = styles.Add("s66");
s66.Font.FontName = "Times New Roman";
s66.Font.Size = 11;
s66.Font.Color = "#000000";
s66.Interior.Color = "#FFFFFF";
s66.Interior.Pattern = StyleInteriorPattern.Solid;
s66.Alignment.Vertical = StyleVerticalAlignment.Center;
s66.Alignment.WrapText = true;
s66.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s66.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s66.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s66.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
s66.NumberFormat = "Standard";
// -----------------------------------------------
// s67
// -----------------------------------------------
WorksheetStyle s67 = styles.Add("s67");
s67.Font.FontName = "Times New Roman";
s67.Font.Size = 11;
s67.Font.Color = "#000000";
s67.Interior.Color = "#FFFFFF";
s67.Interior.Pattern = StyleInteriorPattern.Solid;
s67.Alignment.Vertical = StyleVerticalAlignment.Center;
s67.Alignment.WrapText = true;
s67.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s68
// -----------------------------------------------
WorksheetStyle s68 = styles.Add("s68");
s68.Font.Bold = true;
s68.Font.FontName = "Times New Roman";
s68.Font.Size = 11;
s68.Font.Color = "#000000";
s68.Interior.Color = "#8DB4E3";
s68.Interior.Pattern = StyleInteriorPattern.Solid;
s68.Alignment.Vertical = StyleVerticalAlignment.Center;
s68.Alignment.WrapText = true;
s68.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
s68.NumberFormat = "Standard";
// -----------------------------------------------
// s69
// -----------------------------------------------
WorksheetStyle s69 = styles.Add("s69");
s69.Font.Bold = true;
s69.Font.FontName = "Times New Roman";
s69.Font.Size = 11;
s69.Font.Color = "#FF0000";
s69.Interior.Color = "#FFFF00";
s69.Interior.Pattern = StyleInteriorPattern.Solid;
s69.Alignment.Vertical = StyleVerticalAlignment.Center;
s69.Alignment.WrapText = true;
s69.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
s69.NumberFormat = "Standard";
// -----------------------------------------------
// s90
// -----------------------------------------------
WorksheetStyle s90 = styles.Add("s90");
s90.Font.Bold = true;
s90.Font.FontName = "Times New Roman";
s90.Font.Size = 18;
s90.Font.Color = "#000000";
s90.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s90.Alignment.Vertical = StyleVerticalAlignment.Center;
s90.Alignment.WrapText = true;
// -----------------------------------------------
// s91
// -----------------------------------------------
WorksheetStyle s91 = styles.Add("s91");
s91.Font.Italic = true;
s91.Font.FontName = "Times New Roman";
s91.Font.Color = "#000000";
s91.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s91.Alignment.Vertical = StyleVerticalAlignment.Center;
s91.Alignment.WrapText = true;
// -----------------------------------------------
// s92
// -----------------------------------------------
WorksheetStyle s92 = styles.Add("s92");
s92.Font.FontName = "Times New Roman";
s92.Font.Size = 11;
s92.Font.Color = "#000000";
s92.Interior.Color = "#FFFFFF";
s92.Interior.Pattern = StyleInteriorPattern.Solid;
s92.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s92.Alignment.Vertical = StyleVerticalAlignment.Center;
s92.Alignment.WrapText = true;
s92.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s92.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s92.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s96
// -----------------------------------------------
WorksheetStyle s96 = styles.Add("s96");
s96.Font.Italic = true;
s96.Font.FontName = "Times New Roman";
s96.Font.Color = "#000000";
s96.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s96.Alignment.Vertical = StyleVerticalAlignment.Center;
s96.Alignment.WrapText = true;
s96.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// m51494400
// -----------------------------------------------
WorksheetStyle m51494400 = styles.Add("m51494400");
m51494400.Font.FontName = "Verdana";
m51494400.Font.Color = "#000000";
m51494400.Interior.Color = "#ECECEC";
m51494400.Interior.Pattern = StyleInteriorPattern.Solid;
m51494400.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494400.Alignment.WrapText = true;
m51494400.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494400.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494400.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494400.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494420
// -----------------------------------------------
WorksheetStyle m51494420 = styles.Add("m51494420");
m51494420.Font.FontName = "Verdana";
m51494420.Font.Color = "#000000";
m51494420.Interior.Color = "#ECECEC";
m51494420.Interior.Pattern = StyleInteriorPattern.Solid;
m51494420.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494420.Alignment.WrapText = true;
m51494420.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494420.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494420.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494420.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494440
// -----------------------------------------------
WorksheetStyle m51494440 = styles.Add("m51494440");
m51494440.Font.FontName = "Verdana";
m51494440.Font.Color = "#000000";
m51494440.Interior.Color = "#ECECEC";
m51494440.Interior.Pattern = StyleInteriorPattern.Solid;
m51494440.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494440.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494440.Alignment.WrapText = true;
m51494440.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494440.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494440.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494440.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494460
// -----------------------------------------------
WorksheetStyle m51494460 = styles.Add("m51494460");
m51494460.Font.FontName = "Verdana";
m51494460.Font.Color = "#000000";
m51494460.Interior.Color = "#ECECEC";
m51494460.Interior.Pattern = StyleInteriorPattern.Solid;
m51494460.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494460.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494460.Alignment.WrapText = true;
m51494460.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494460.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494460.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494460.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494480
// -----------------------------------------------
WorksheetStyle m51494480 = styles.Add("m51494480");
m51494480.Font.FontName = "Verdana";
m51494480.Font.Color = "#000000";
m51494480.Interior.Color = "#ECECEC";
m51494480.Interior.Pattern = StyleInteriorPattern.Solid;
m51494480.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494480.Alignment.WrapText = true;
m51494480.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494480.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494480.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494480.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494176
// -----------------------------------------------
WorksheetStyle m51494176 = styles.Add("m51494176");
m51494176.Font.FontName = "Verdana";
m51494176.Font.Color = "#000000";
m51494176.Interior.Color = "#ECECEC";
m51494176.Interior.Pattern = StyleInteriorPattern.Solid;
m51494176.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494176.Alignment.WrapText = true;
m51494176.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494176.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494176.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494176.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494196
// -----------------------------------------------
WorksheetStyle m51494196 = styles.Add("m51494196");
m51494196.Font.FontName = "Verdana";
m51494196.Font.Color = "#000000";
m51494196.Interior.Color = "#ECECEC";
m51494196.Interior.Pattern = StyleInteriorPattern.Solid;
m51494196.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494196.Alignment.WrapText = true;
m51494196.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494216
// -----------------------------------------------
WorksheetStyle m51494216 = styles.Add("m51494216");
m51494216.Font.FontName = "Verdana";
m51494216.Font.Color = "#000000";
m51494216.Interior.Color = "#ECECEC";
m51494216.Interior.Pattern = StyleInteriorPattern.Solid;
m51494216.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494216.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494216.Alignment.WrapText = true;
m51494216.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494236
// -----------------------------------------------
WorksheetStyle m51494236 = styles.Add("m51494236");
m51494236.Font.FontName = "Verdana";
m51494236.Font.Color = "#000000";
m51494236.Interior.Color = "#ECECEC";
m51494236.Interior.Pattern = StyleInteriorPattern.Solid;
m51494236.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494236.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494236.Alignment.WrapText = true;
m51494236.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494256
// -----------------------------------------------
WorksheetStyle m51494256 = styles.Add("m51494256");
m51494256.Font.FontName = "Verdana";
m51494256.Font.Color = "#000000";
m51494256.Interior.Color = "#ECECEC";
m51494256.Interior.Pattern = StyleInteriorPattern.Solid;
m51494256.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494256.Alignment.WrapText = true;
m51494256.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494256.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494256.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494256.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494276
// -----------------------------------------------
WorksheetStyle m51494276 = styles.Add("m51494276");
m51494276.Font.FontName = "Verdana";
m51494276.Font.Color = "#000000";
m51494276.Interior.Color = "#FFFFFF";
m51494276.Interior.Pattern = StyleInteriorPattern.Solid;
m51494276.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494276.Alignment.WrapText = true;
m51494276.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494276.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494276.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494276.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494296
// -----------------------------------------------
WorksheetStyle m51494296 = styles.Add("m51494296");
m51494296.Font.FontName = "Verdana";
m51494296.Font.Color = "#000000";
m51494296.Interior.Color = "#FFFFFF";
m51494296.Interior.Pattern = StyleInteriorPattern.Solid;
m51494296.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494296.Alignment.WrapText = true;
m51494296.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494316
// -----------------------------------------------
WorksheetStyle m51494316 = styles.Add("m51494316");
m51494316.Font.FontName = "Verdana";
m51494316.Font.Color = "#000000";
m51494316.Interior.Color = "#FFFFFF";
m51494316.Interior.Pattern = StyleInteriorPattern.Solid;
m51494316.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494316.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494316.Alignment.WrapText = true;
m51494316.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494336
// -----------------------------------------------
WorksheetStyle m51494336 = styles.Add("m51494336");
m51494336.Font.FontName = "Verdana";
m51494336.Font.Color = "#000000";
m51494336.Interior.Color = "#FFFFFF";
m51494336.Interior.Pattern = StyleInteriorPattern.Solid;
m51494336.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494336.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494336.Alignment.WrapText = true;
m51494336.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494356
// -----------------------------------------------
WorksheetStyle m51494356 = styles.Add("m51494356");
m51494356.Font.FontName = "Verdana";
m51494356.Font.Color = "#000000";
m51494356.Interior.Color = "#FFFFFF";
m51494356.Interior.Pattern = StyleInteriorPattern.Solid;
m51494356.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494356.Alignment.WrapText = true;
m51494356.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494356.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494356.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494356.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// s70
// -----------------------------------------------
WorksheetStyle s70 = styles.Add("s70");
s70.Font.FontName = "Verdana";
s70.Font.Color = "#000000";
s70.Alignment.Vertical = StyleVerticalAlignment.Top;
s70.Alignment.WrapText = true;
// -----------------------------------------------
// s83
// -----------------------------------------------
WorksheetStyle s83 = styles.Add("s83");
s83.Font.FontName = "Verdana";
s83.Font.Color = "#000000";
s83.Interior.Color = "#FFFFFF";
s83.Interior.Pattern = StyleInteriorPattern.Solid;
s83.Alignment.Vertical = StyleVerticalAlignment.Center;
s83.Alignment.WrapText = true;
// -----------------------------------------------
// s89
// -----------------------------------------------
WorksheetStyle s89 = styles.Add("s89");
s89.Font.Bold = true;
s89.Font.FontName = "Verdana";
s89.Font.Color = "#000000";
s89.Interior.Color = "#C2C2C2";
s89.Interior.Pattern = StyleInteriorPattern.Solid;
s89.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s89.Alignment.Vertical = StyleVerticalAlignment.Center;
s89.Alignment.WrapText = true;
s89.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
s89.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
s89.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s90
// -----------------------------------------------
WorksheetStyle s90 = styles.Add("s90");
s90.Font.Bold = true;
s90.Font.FontName = "Verdana";
s90.Font.Color = "#000000";
s90.Interior.Color = "#C2C2C2";
s90.Interior.Pattern = StyleInteriorPattern.Solid;
s90.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s90.Alignment.Vertical = StyleVerticalAlignment.Center;
s90.Alignment.WrapText = true;
s90.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
s90.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s91
// -----------------------------------------------
WorksheetStyle s91 = styles.Add("s91");
s91.Font.Bold = true;
s91.Font.FontName = "Verdana";
s91.Font.Color = "#000000";
s91.Interior.Color = "#C2C2C2";
s91.Interior.Pattern = StyleInteriorPattern.Solid;
s91.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s91.Alignment.Vertical = StyleVerticalAlignment.Center;
s91.Alignment.WrapText = true;
s91.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
s91.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s129
// -----------------------------------------------
WorksheetStyle s129 = styles.Add("s129");
s129.Font.FontName = "Verdana";
s129.Font.Color = "#000000";
s129.Interior.Color = "#FFFFFF";
s129.Interior.Pattern = StyleInteriorPattern.Solid;
s129.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s129.Alignment.Vertical = StyleVerticalAlignment.Center;
s129.Alignment.WrapText = true;
// -----------------------------------------------
// s130
// -----------------------------------------------
WorksheetStyle s130 = styles.Add("s130");
s130.Font.Bold = true;
s130.Font.FontName = "Verdana";
s130.Font.Color = "#000000";
s130.Interior.Color = "#FFFFFF";
s130.Interior.Pattern = StyleInteriorPattern.Solid;
s130.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s130.Alignment.Vertical = StyleVerticalAlignment.Center;
s130.Alignment.WrapText = true;
// -----------------------------------------------
// s131
// -----------------------------------------------
WorksheetStyle s131 = styles.Add("s131");
s131.Font.Bold = true;
s131.Font.FontName = "Verdana";
s131.Font.Color = "#000000";
s131.Interior.Color = "#FFFFFF";
s131.Interior.Pattern = StyleInteriorPattern.Solid;
s131.Alignment.Vertical = StyleVerticalAlignment.Center;
s131.Alignment.WrapText = true;
// -----------------------------------------------
// s132
// -----------------------------------------------
WorksheetStyle s132 = styles.Add("s132");
s132.Font.FontName = "Verdana";
s132.Font.Size = 18;
s132.Font.Color = "#000000";
s132.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s132.Alignment.Vertical = StyleVerticalAlignment.Center;
s132.Alignment.WrapText = true;
// -----------------------------------------------
// s133
// -----------------------------------------------
WorksheetStyle s133 = styles.Add("s133");
s133.Font.FontName = "Verdana";
s133.Font.Color = "#666666";
s133.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s133.Alignment.Vertical = StyleVerticalAlignment.Center;
s133.Alignment.WrapText = true;
// -----------------------------------------------
// s134
// -----------------------------------------------
WorksheetStyle s134 = styles.Add("s134");
s134.Alignment.Vertical = StyleVerticalAlignment.Center;
s134.Alignment.WrapText = true;
// -----------------------------------------------
// s135
// -----------------------------------------------
WorksheetStyle s135 = styles.Add("s135");
s135.Font.Bold = true;
s135.Font.FontName = "Verdana";
s135.Font.Color = "#000000";
s135.Alignment.Vertical = StyleVerticalAlignment.Center;
s135.Alignment.WrapText = true;
// -----------------------------------------------
// s136
// -----------------------------------------------
WorksheetStyle s136 = styles.Add("s136");
s136.Font.FontName = "Verdana";
s136.Font.Color = "#000000";
s136.Alignment.Vertical = StyleVerticalAlignment.Center;
s136.Alignment.WrapText = true;
// -----------------------------------------------
// s137
// -----------------------------------------------
WorksheetStyle s137 = styles.Add("s137");
s137.Font.FontName = "Verdana";
s137.Font.Color = "#000000";
s137.Alignment.Vertical = StyleVerticalAlignment.Center;
s137.Alignment.WrapText = true;
s137.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s141
// -----------------------------------------------
WorksheetStyle s141 = styles.Add("s141");
s141.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s141.Alignment.Vertical = StyleVerticalAlignment.Top;
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// m92103616
// -----------------------------------------------
WorksheetStyle m92103616 = styles.Add("m92103616");
m92103616.Font.Bold = true;
m92103616.Font.FontName = "Times New Roman";
m92103616.Font.Size = 11;
m92103616.Font.Color = "#000000";
m92103616.Interior.Color = "#8DB4E3";
m92103616.Interior.Pattern = StyleInteriorPattern.Solid;
m92103616.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m92103616.Alignment.Vertical = StyleVerticalAlignment.Center;
m92103616.Alignment.WrapText = true;
m92103616.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
m92103616.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
m92103616.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// m92103636
// -----------------------------------------------
WorksheetStyle m92103636 = styles.Add("m92103636");
m92103636.Font.Bold = true;
m92103636.Font.FontName = "Times New Roman";
m92103636.Font.Size = 11;
m92103636.Font.Color = "#000000";
m92103636.Interior.Color = "#D8D8D8";
m92103636.Interior.Pattern = StyleInteriorPattern.Solid;
m92103636.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m92103636.Alignment.Vertical = StyleVerticalAlignment.Center;
m92103636.Alignment.WrapText = true;
m92103636.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
m92103636.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
m92103636.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// m92103656
// -----------------------------------------------
WorksheetStyle m92103656 = styles.Add("m92103656");
m92103656.Font.Bold = true;
m92103656.Font.FontName = "Times New Roman";
m92103656.Font.Size = 11;
m92103656.Font.Color = "#F2F2F2";
m92103656.Interior.Color = "#E46D0A";
m92103656.Interior.Pattern = StyleInteriorPattern.Solid;
m92103656.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m92103656.Alignment.Vertical = StyleVerticalAlignment.Center;
m92103656.Alignment.WrapText = true;
m92103656.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
m92103656.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
m92103656.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
m92103656.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// m92103676
// -----------------------------------------------
WorksheetStyle m92103676 = styles.Add("m92103676");
m92103676.Font.Bold = true;
m92103676.Font.FontName = "Times New Roman";
m92103676.Font.Size = 11;
m92103676.Font.Color = "#FF0000";
m92103676.Interior.Color = "#FFFF00";
m92103676.Interior.Pattern = StyleInteriorPattern.Solid;
m92103676.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m92103676.Alignment.Vertical = StyleVerticalAlignment.Center;
m92103676.Alignment.WrapText = true;
m92103676.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
m92103676.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
m92103676.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
m92103676.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s16
// -----------------------------------------------
WorksheetStyle s16 = styles.Add("s16");
s16.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s16.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s17
// -----------------------------------------------
WorksheetStyle s17 = styles.Add("s17");
s17.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s18
// -----------------------------------------------
WorksheetStyle s18 = styles.Add("s18");
s18.Font.Bold = true;
s18.Font.FontName = "Calibri";
s18.Font.Size = 18;
s18.Font.Color = "#000000";
// -----------------------------------------------
// s19
// -----------------------------------------------
WorksheetStyle s19 = styles.Add("s19");
s19.Font.Bold = true;
s19.Font.FontName = "Times New Roman";
s19.Font.Size = 11;
s19.Font.Color = "#000000";
s19.Interior.Color = "#FAC090";
s19.Interior.Pattern = StyleInteriorPattern.Solid;
s19.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s19.Alignment.Vertical = StyleVerticalAlignment.Center;
s19.Alignment.WrapText = true;
s19.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s19.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s19.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s19.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s110
// -----------------------------------------------
WorksheetStyle s110 = styles.Add("s110");
s110.Font.Bold = true;
s110.Font.FontName = "Times New Roman";
s110.Font.Size = 18;
s110.Font.Color = "#000000";
s110.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s110.Alignment.Vertical = StyleVerticalAlignment.Center;
s110.Alignment.WrapText = true;
// -----------------------------------------------
// s111
// -----------------------------------------------
WorksheetStyle s111 = styles.Add("s111");
s111.Font.FontName = "Times New Roman";
s111.Font.Size = 11;
s111.Font.Color = "#000000";
s111.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s111.Alignment.Vertical = StyleVerticalAlignment.Center;
s111.Alignment.WrapText = true;
// -----------------------------------------------
// s112
// -----------------------------------------------
WorksheetStyle s112 = styles.Add("s112");
s112.Font.Italic = true;
s112.Font.FontName = "Times New Roman";
s112.Font.Color = "#000000";
s112.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s112.Alignment.Vertical = StyleVerticalAlignment.Center;
s112.Alignment.WrapText = true;
s112.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s113
// -----------------------------------------------
WorksheetStyle s113 = styles.Add("s113");
s113.Font.FontName = "Times New Roman";
s113.Font.Size = 11;
s113.Font.Color = "#000000";
s113.Interior.Color = "#FFFFFF";
s113.Interior.Pattern = StyleInteriorPattern.Solid;
s113.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s113.Alignment.Vertical = StyleVerticalAlignment.Center;
s113.Alignment.WrapText = true;
s113.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s113.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s113.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s113.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s114
// -----------------------------------------------
WorksheetStyle s114 = styles.Add("s114");
s114.Font.FontName = "Times New Roman";
s114.Font.Size = 11;
s114.Font.Color = "#000000";
s114.Interior.Color = "#FFFFFF";
s114.Interior.Pattern = StyleInteriorPattern.Solid;
s114.Alignment.Vertical = StyleVerticalAlignment.Center;
s114.Alignment.WrapText = true;
s114.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s114.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s114.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s114.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s115
// -----------------------------------------------
WorksheetStyle s115 = styles.Add("s115");
s115.Font.FontName = "Times New Roman";
s115.Font.Size = 11;
s115.Font.Color = "#000000";
s115.Interior.Color = "#FFFFFF";
s115.Interior.Pattern = StyleInteriorPattern.Solid;
s115.Alignment.Vertical = StyleVerticalAlignment.Center;
s115.Alignment.WrapText = true;
s115.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s115.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s115.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s115.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s115.NumberFormat = "Standard";
// -----------------------------------------------
// s116
// -----------------------------------------------
WorksheetStyle s116 = styles.Add("s116");
s116.Font.Bold = true;
s116.Font.FontName = "Times New Roman";
s116.Font.Size = 11;
s116.Font.Color = "#000000";
s116.Interior.Color = "#8DB4E3";
s116.Interior.Pattern = StyleInteriorPattern.Solid;
s116.Alignment.Vertical = StyleVerticalAlignment.Center;
s116.Alignment.WrapText = true;
s116.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s116.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s116.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s116.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s116.NumberFormat = "Standard";
// -----------------------------------------------
// s117
// -----------------------------------------------
WorksheetStyle s117 = styles.Add("s117");
s117.Font.Bold = true;
s117.Font.FontName = "Times New Roman";
s117.Font.Size = 11;
s117.Font.Color = "#FF0000";
s117.Interior.Color = "#FFFF00";
s117.Interior.Pattern = StyleInteriorPattern.Solid;
s117.Alignment.Vertical = StyleVerticalAlignment.Center;
s117.Alignment.WrapText = true;
s117.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s117.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s117.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s117.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s117.NumberFormat = "Standard";
// -----------------------------------------------
// s118
// -----------------------------------------------
WorksheetStyle s118 = styles.Add("s118");
s118.Font.Bold = true;
s118.Font.FontName = "Times New Roman";
s118.Font.Size = 11;
s118.Font.Color = "#000000";
s118.Interior.Color = "#D8D8D8";
s118.Interior.Pattern = StyleInteriorPattern.Solid;
s118.Alignment.Vertical = StyleVerticalAlignment.Center;
s118.Alignment.WrapText = true;
s118.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s118.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s118.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s118.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s118.NumberFormat = "Standard";
// -----------------------------------------------
// s119
// -----------------------------------------------
WorksheetStyle s119 = styles.Add("s119");
s119.Font.Bold = true;
s119.Font.FontName = "Times New Roman";
s119.Font.Size = 11;
s119.Font.Color = "#F2F2F2";
s119.Interior.Color = "#E46D0A";
s119.Interior.Pattern = StyleInteriorPattern.Solid;
s119.Alignment.Vertical = StyleVerticalAlignment.Center;
s119.Alignment.WrapText = true;
s119.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s119.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s119.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s119.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s119.NumberFormat = "Standard";
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
try
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s21
// -----------------------------------------------
WorksheetStyle s21 = styles.Add("s21");
s21.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s21.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s22
// -----------------------------------------------
WorksheetStyle s22 = styles.Add("s22");
s22.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s22.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s34
// -----------------------------------------------
WorksheetStyle s34 = styles.Add("s34");
s34.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s34.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s34.NumberFormat = "0";
// -----------------------------------------------
// s44
// -----------------------------------------------
WorksheetStyle s44 = styles.Add("s44");
s44.Font.FontName = "Verdana";
s44.Font.Color = "#000000";
s44.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s44.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s44.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s44.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s44.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s44.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s45
// -----------------------------------------------
WorksheetStyle s45 = styles.Add("s45");
s45.Font.FontName = "Verdana";
s45.Font.Color = "#000000";
//s45.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s45.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s45.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s45.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s45.NumberFormat = "0";
s45.Alignment.Horizontal = StyleHorizontalAlignment.Right;
// -----------------------------------------------
// s46
// -----------------------------------------------
WorksheetStyle s46 = styles.Add("s46");
s46.Font.FontName = "Verdana";
s46.Font.Color = "#000000";
s46.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s46.Alignment.Vertical = StyleVerticalAlignment.Bottom;
//s46.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s46.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s46.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s46.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s46.NumberFormat = "0";
// -----------------------------------------------
// s47
// -----------------------------------------------
WorksheetStyle s47 = styles.Add("s47");
s47.Font.FontName = "Verdana";
s47.Font.Color = "#000000";
s47.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s47.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s47.NumberFormat = "0";
// -----------------------------------------------
// s48
// -----------------------------------------------
WorksheetStyle s48 = styles.Add("s48");
s48.Font.FontName = "Verdana";
s48.Interior.Color = "#FFFFFF";
s48.Interior.Pattern = StyleInteriorPattern.Solid;
s48.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s48.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s48.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s48.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s48.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s48.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s49
// -----------------------------------------------
WorksheetStyle s49 = styles.Add("s49");
s49.Font.FontName = "Verdana";
s49.Font.Color = "#000000";
s49.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s49.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s49.NumberFormat = "0";
// -----------------------------------------------
// s50
// -----------------------------------------------
WorksheetStyle s50 = styles.Add("s50");
s50.Font.FontName = "Verdana";
s50.Font.Color = "#000000";
s50.NumberFormat = "0";
// -----------------------------------------------
// s51
// -----------------------------------------------
WorksheetStyle s51 = styles.Add("s51");
s51.Font.FontName = "Verdana";
s51.Font.Color = "RED";
s51.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s51.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s51.NumberFormat = "Fixed";
// -----------------------------------------------
// s52
// -----------------------------------------------
WorksheetStyle s52 = styles.Add("s52");
s52.Font.FontName = "Verdana";
s52.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s52.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s52.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s52.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s52.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s52.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s54
// -----------------------------------------------
WorksheetStyle s54 = styles.Add("s54");
s54.Font.Bold = true;
s54.Font.FontName = "Verdana";
s54.Font.Size = 11;
s54.Font.Color = "#000000";
s54.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s54.Alignment.Vertical = StyleVerticalAlignment.Bottom;
s54.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s54.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s54.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s54.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s55
// -----------------------------------------------
WorksheetStyle s55 = styles.Add("s55");
s55.Font.Bold = true;
s55.Font.FontName = "Verdana";
s55.Font.Size = 10;
s55.Font.Color = "#000000";
s55.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s55.Alignment.Vertical = StyleVerticalAlignment.Bottom;
//s55.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s55.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s55.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s55.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s56
// -----------------------------------------------
WorksheetStyle s56 = styles.Add("s56");
s56.Font.Bold = true;
s56.Font.FontName = "Verdana";
s56.Font.Size = 10;
s56.Font.Color = "#000000";
s56.Alignment.WrapText = true;
s56.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s56.Alignment.Vertical = StyleVerticalAlignment.Bottom;
//s56.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
//s56.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
//s56.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
//s56.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
}
catch (Exception ex)
{
}
}
/// <summary>
/// Erstelle die Layout Styles
/// </summary>
/// <param name="styles"></param>
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Allgemein
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Default";
// -----------------------------------------------
// Ergebnis1
// -----------------------------------------------
WorksheetStyle Result = styles.Add("Result");
Result.Name = "Result";
Result.Font.Bold = true;
Result.Font.Italic = true;
Result.Font.Underline = UnderlineStyle.Single;
Result.Font.Size = 10;
// -----------------------------------------------
// Ergebnis2
// -----------------------------------------------
WorksheetStyle Result2 = styles.Add("Result2");
Result2.Name = "Result2";
Result2.Font.Bold = true;
Result2.Font.Italic = true;
Result2.Font.Underline = UnderlineStyle.Single;
Result2.Font.Size = 10;
// -----------------------------------------------
// Überschrift
// -----------------------------------------------
WorksheetStyle Heading = styles.Add("Heading");
Heading.Name = "Heading";
Heading.Font.Bold = true;
Heading.Font.Italic = true;
Heading.Font.Size = 11;
// -----------------------------------------------
// Überschrift2
// -----------------------------------------------
WorksheetStyle Heading1 = styles.Add("Heading1");
Heading1.Name = "Heading1";
Heading1.Font.Bold = true;
Heading1.Font.Italic = true;
Heading1.Font.Size = 11;
// -----------------------------------------------
// Normales Layout
// -----------------------------------------------
WorksheetStyle Normal = styles.Add("Normal");
Normal.Name = "Normal";
Normal.Font.FontName = "Tahoma1";
Normal.Font.Size = 11;
// -----------------------------------------------
// Spalte1
// -----------------------------------------------
WorksheetStyle co1 = styles.Add("co1");
// -----------------------------------------------
// Spalte2
// -----------------------------------------------
WorksheetStyle co2 = styles.Add("co2");
// -----------------------------------------------
// Spalte3
// -----------------------------------------------
WorksheetStyle co3 = styles.Add("co3");
// -----------------------------------------------
// Spalte4
// -----------------------------------------------
WorksheetStyle co4 = styles.Add("co4");
// -----------------------------------------------
// Spalte5
// -----------------------------------------------
WorksheetStyle co5 = styles.Add("co5");
// -----------------------------------------------
// Spalte6
// -----------------------------------------------
WorksheetStyle co6 = styles.Add("co6");
// -----------------------------------------------
// Spalte7
// -----------------------------------------------
WorksheetStyle co7 = styles.Add("co7");
// -----------------------------------------------
// Spalte8
// -----------------------------------------------
WorksheetStyle co8 = styles.Add("co8");
// -----------------------------------------------
// Spalte9
// -----------------------------------------------
WorksheetStyle co9 = styles.Add("co9");
// -----------------------------------------------
// Spalte10
// -----------------------------------------------
WorksheetStyle co10 = styles.Add("co10");
// -----------------------------------------------
// ta1
// -----------------------------------------------
WorksheetStyle ta1 = styles.Add("ta1");
// -----------------------------------------------
// neuer Style "normal"
// -----------------------------------------------
WorksheetStyle ce1 = styles.Add("ce1");
ce1.Parent = "Normal";
ce1.Font.Bold = true;
ce1.Font.FontName = "Tahoma1";
ce1.Font.Size = 11;
ce1.Interior.Color = _HEADERCOLOR;
ce1.Interior.Pattern = StyleInteriorPattern.Solid;
ce1.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce1.Alignment.Vertical = StyleVerticalAlignment.Center;
ce1.Alignment.WrapText = true;
ce1.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle2
// -----------------------------------------------
WorksheetStyle ce2 = styles.Add("ce2");
ce2.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce2.Alignment.Vertical = StyleVerticalAlignment.Center;
ce2.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
ce2.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle3
// -----------------------------------------------
WorksheetStyle ce3 = styles.Add("ce3");
ce3.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce3.Alignment.Vertical = StyleVerticalAlignment.Center;
ce3.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle4
// -----------------------------------------------
WorksheetStyle ce4 = styles.Add("ce4");
ce4.Parent = "Normal";
ce4.Font.Bold = true;
ce4.Font.FontName = "Tahoma1";
ce4.Font.Size = 11;
ce4.Interior.Color = _HEADERCOLOR;
ce4.Interior.Pattern = StyleInteriorPattern.Solid;
ce4.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce4.Alignment.Vertical = StyleVerticalAlignment.Center;
ce4.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle5
// -----------------------------------------------
WorksheetStyle ce5 = styles.Add("ce5");
ce5.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce5.Alignment.Vertical = StyleVerticalAlignment.Center;
ce5.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
ce5.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle6
// -----------------------------------------------
WorksheetStyle ce6 = styles.Add("ce6");
ce6.Parent = "Normal";
ce6.Font.Bold = true;
ce6.Font.FontName = "Tahoma1";
ce6.Font.Size = 11;
ce6.Interior.Color = _HEADERCOLOR;
ce6.Interior.Pattern = StyleInteriorPattern.Solid;
ce6.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce6.Alignment.Vertical = StyleVerticalAlignment.Center;
ce6.Alignment.WrapText = true;
ce6.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce6.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle7
// -----------------------------------------------
WorksheetStyle ce7 = styles.Add("ce7");
ce7.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce7.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// WorksheetStyle8
// -----------------------------------------------
WorksheetStyle ce8 = styles.Add("ce8");
ce8.Font.Bold = true;
ce8.Font.FontName = "Tahoma";
ce8.Font.Size = 11;
ce8.Interior.Color = _HEADERCOLOR;
ce8.Interior.Pattern = StyleInteriorPattern.Solid;
ce8.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce8.Alignment.Vertical = StyleVerticalAlignment.Center;
ce8.Alignment.WrapText = true;
ce8.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle9
// -----------------------------------------------
WorksheetStyle ce9 = styles.Add("ce9");
ce9.Parent = "Normal";
ce9.Font.Bold = true;
ce9.Font.FontName = "Tahoma1";
ce9.Font.Size = 11;
ce9.Interior.Color = _HEADERCOLOR;
ce9.Interior.Pattern = StyleInteriorPattern.Solid;
ce9.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce9.Alignment.Vertical = StyleVerticalAlignment.Center;
ce9.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce9.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
//
// WorksheetStyle10
//
WorksheetStyle cell10 = styles.Add("ce10");
cell10.Alignment.Horizontal = StyleHorizontalAlignment.Center;
cell10.Alignment.Vertical = StyleVerticalAlignment.Center;
cell10.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
//
// WorksheetStyle11
//
WorksheetStyle cell11 = styles.Add("ce11");
cell11.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
cell11.Alignment.Horizontal = StyleHorizontalAlignment.Left;
//cell11.Alignment.WrapText = true;
cell11.Alignment.Vertical = StyleVerticalAlignment.Center;
cell11.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// m83608040
// -----------------------------------------------
WorksheetStyle m83608040 = styles.Add("m83608040");
m83608040.Font.Italic = true;
m83608040.Font.FontName = "Times New Roman";
m83608040.Font.Size = 11;
m83608040.Font.Color = "#000000";
m83608040.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m83608040.Alignment.Vertical = StyleVerticalAlignment.Center;
m83608040.Alignment.WrapText = true;
m83608040.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
m83608040.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
m83608040.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// m83608060
// -----------------------------------------------
WorksheetStyle m83608060 = styles.Add("m83608060");
m83608060.Font.Bold = true;
m83608060.Font.FontName = "Times New Roman";
m83608060.Font.Size = 12;
m83608060.Font.Color = "#FF0000";
m83608060.Interior.Color = "#FFFF00";
m83608060.Interior.Pattern = StyleInteriorPattern.Solid;
m83608060.Alignment.Horizontal = StyleHorizontalAlignment.Right;
m83608060.Alignment.Vertical = StyleVerticalAlignment.Center;
m83608060.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
m83608060.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
m83608060.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
m83608060.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s67
// -----------------------------------------------
WorksheetStyle s67 = styles.Add("s67");
s67.Font.Bold = true;
s67.Font.FontName = "Times New Roman";
s67.Font.Size = 12;
s67.Font.Color = "#333399";
s67.Interior.Color = "#FCD5B4";
s67.Interior.Pattern = StyleInteriorPattern.Solid;
s67.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s67.Alignment.Vertical = StyleVerticalAlignment.Center;
s67.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s67.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s68
// -----------------------------------------------
WorksheetStyle s68 = styles.Add("s68");
s68.Font.FontName = "Times New Roman";
s68.Font.Size = 11;
s68.Font.Color = "#000000";
s68.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s68.Alignment.Vertical = StyleVerticalAlignment.Center;
s68.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s68.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s69
// -----------------------------------------------
WorksheetStyle s69 = styles.Add("s69");
s69.Font.FontName = "Times New Roman";
s69.Font.Size = 11;
s69.Font.Color = "#000000";
s69.Alignment.Vertical = StyleVerticalAlignment.Center;
s69.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s69.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// s70
// -----------------------------------------------
WorksheetStyle s70 = styles.Add("s70");
s70.Font.Bold = true;
s70.Font.Italic = true;
s70.Font.FontName = "Times New Roman";
s70.Font.Size = 11;
s70.Font.Color = "#000000";
s70.Interior.Color = "#DBE5F1";
s70.Interior.Pattern = StyleInteriorPattern.Solid;
s70.Alignment.Vertical = StyleVerticalAlignment.Center;
s70.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s70.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s70.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s70.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
s70.NumberFormat = "Standard";
// -----------------------------------------------
// s74
// -----------------------------------------------
WorksheetStyle s74 = styles.Add("s74");
s74.Font.Bold = true;
s74.Font.FontName = "Times New Roman";
s74.Font.Size = 12;
s74.Font.Color = "#FF0000";
s74.Interior.Color = "#FFFF00";
s74.Interior.Pattern = StyleInteriorPattern.Solid;
s74.Alignment.Vertical = StyleVerticalAlignment.Center;
s74.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
s74.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
s74.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
s74.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
s74.NumberFormat = "Standard";
// -----------------------------------------------
// s75
// -----------------------------------------------
WorksheetStyle s75 = styles.Add("s75");
s75.Font.Bold = true;
s75.Font.FontName = "Times New Roman";
s75.Font.Size = 16;
s75.Font.Color = "#000000";
s75.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s75.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// s76
// -----------------------------------------------
WorksheetStyle s76 = styles.Add("s76");
s76.Font.Italic = true;
s76.Font.FontName = "Times New Roman";
s76.Font.Size = 11;
s76.Font.Color = "#000000";
s76.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s76.Alignment.Vertical = StyleVerticalAlignment.Center;
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// m51494400
// -----------------------------------------------
WorksheetStyle m51494400 = styles.Add("m51494400");
m51494400.Font.FontName = "Verdana";
m51494400.Font.Color = "#000000";
m51494400.Interior.Color = "#ECECEC";
m51494400.Interior.Pattern = StyleInteriorPattern.Solid;
m51494400.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494400.Alignment.WrapText = true;
m51494400.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494400.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494400.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494400.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494420
// -----------------------------------------------
WorksheetStyle m51494420 = styles.Add("m51494420");
m51494420.Font.FontName = "Verdana";
m51494420.Font.Color = "#000000";
m51494420.Interior.Color = "#ECECEC";
m51494420.Interior.Pattern = StyleInteriorPattern.Solid;
m51494420.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494420.Alignment.WrapText = true;
m51494420.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494420.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494420.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494420.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494440
// -----------------------------------------------
WorksheetStyle m51494440 = styles.Add("m51494440");
m51494440.Font.FontName = "Verdana";
m51494440.Font.Color = "#000000";
m51494440.Interior.Color = "#ECECEC";
m51494440.Interior.Pattern = StyleInteriorPattern.Solid;
m51494440.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494440.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494440.Alignment.WrapText = true;
m51494440.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494440.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494440.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494440.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494460
// -----------------------------------------------
WorksheetStyle m51494460 = styles.Add("m51494460");
m51494460.Font.FontName = "Verdana";
m51494460.Font.Color = "#000000";
m51494460.Interior.Color = "#ECECEC";
m51494460.Interior.Pattern = StyleInteriorPattern.Solid;
m51494460.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494460.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494460.Alignment.WrapText = true;
m51494460.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494460.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494460.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494460.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494480
// -----------------------------------------------
WorksheetStyle m51494480 = styles.Add("m51494480");
m51494480.Font.FontName = "Verdana";
m51494480.Font.Color = "#000000";
m51494480.Interior.Color = "#ECECEC";
m51494480.Interior.Pattern = StyleInteriorPattern.Solid;
m51494480.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494480.Alignment.WrapText = true;
m51494480.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
m51494480.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494480.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494480.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494176
// -----------------------------------------------
WorksheetStyle m51494176 = styles.Add("m51494176");
m51494176.Font.FontName = "Verdana";
m51494176.Font.Color = "#000000";
m51494176.Interior.Color = "#ECECEC";
m51494176.Interior.Pattern = StyleInteriorPattern.Solid;
m51494176.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494176.Alignment.WrapText = true;
m51494176.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494176.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494176.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494176.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494196
// -----------------------------------------------
WorksheetStyle m51494196 = styles.Add("m51494196");
m51494196.Font.FontName = "Verdana";
m51494196.Font.Color = "#000000";
m51494196.Interior.Color = "#ECECEC";
m51494196.Interior.Pattern = StyleInteriorPattern.Solid;
m51494196.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494196.Alignment.WrapText = true;
m51494196.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494196.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494216
// -----------------------------------------------
WorksheetStyle m51494216 = styles.Add("m51494216");
m51494216.Font.FontName = "Verdana";
m51494216.Font.Color = "#000000";
m51494216.Interior.Color = "#ECECEC";
m51494216.Interior.Pattern = StyleInteriorPattern.Solid;
m51494216.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494216.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494216.Alignment.WrapText = true;
m51494216.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494216.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494236
// -----------------------------------------------
WorksheetStyle m51494236 = styles.Add("m51494236");
m51494236.Font.FontName = "Verdana";
m51494236.Font.Color = "#000000";
m51494236.Interior.Color = "#ECECEC";
m51494236.Interior.Pattern = StyleInteriorPattern.Solid;
m51494236.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494236.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494236.Alignment.WrapText = true;
m51494236.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494236.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494256
// -----------------------------------------------
WorksheetStyle m51494256 = styles.Add("m51494256");
m51494256.Font.FontName = "Verdana";
m51494256.Font.Color = "#000000";
m51494256.Interior.Color = "#ECECEC";
m51494256.Interior.Pattern = StyleInteriorPattern.Solid;
m51494256.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494256.Alignment.WrapText = true;
m51494256.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494256.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494256.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494256.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494276
// -----------------------------------------------
WorksheetStyle m51494276 = styles.Add("m51494276");
m51494276.Font.FontName = "Verdana";
m51494276.Font.Color = "#000000";
m51494276.Interior.Color = "#FFFFFF";
m51494276.Interior.Pattern = StyleInteriorPattern.Solid;
m51494276.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494276.Alignment.WrapText = true;
m51494276.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494276.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
m51494276.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494276.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494296
// -----------------------------------------------
WorksheetStyle m51494296 = styles.Add("m51494296");
m51494296.Font.FontName = "Verdana";
m51494296.Font.Color = "#000000";
m51494296.Interior.Color = "#FFFFFF";
m51494296.Interior.Pattern = StyleInteriorPattern.Solid;
m51494296.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494296.Alignment.WrapText = true;
m51494296.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494296.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494316
// -----------------------------------------------
WorksheetStyle m51494316 = styles.Add("m51494316");
m51494316.Font.FontName = "Verdana";
m51494316.Font.Color = "#000000";
m51494316.Interior.Color = "#FFFFFF";
m51494316.Interior.Pattern = StyleInteriorPattern.Solid;
m51494316.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494316.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494316.Alignment.WrapText = true;
m51494316.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494316.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494336
// -----------------------------------------------
WorksheetStyle m51494336 = styles.Add("m51494336");
m51494336.Font.FontName = "Verdana";
m51494336.Font.Color = "#000000";
m51494336.Interior.Color = "#FFFFFF";
m51494336.Interior.Pattern = StyleInteriorPattern.Solid;
m51494336.Alignment.Horizontal = StyleHorizontalAlignment.Center;
m51494336.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494336.Alignment.WrapText = true;
m51494336.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
m51494336.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// m51494356
// -----------------------------------------------
WorksheetStyle m51494356 = styles.Add("m51494356");
m51494356.Font.FontName = "Verdana";
m51494356.Font.Color = "#000000";
m51494356.Interior.Color = "#FFFFFF";
m51494356.Interior.Pattern = StyleInteriorPattern.Solid;
m51494356.Alignment.Vertical = StyleVerticalAlignment.Center;
m51494356.Alignment.WrapText = true;
m51494356.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 2, "#959595");
m51494356.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 2, "#959595");
m51494356.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
m51494356.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 2, "#959595");
// -----------------------------------------------
// s70
// -----------------------------------------------
WorksheetStyle s70 = styles.Add("s70");
s70.Font.FontName = "Verdana";
s70.Font.Color = "#000000";
s70.Alignment.Vertical = StyleVerticalAlignment.Top;
s70.Alignment.WrapText = true;
// -----------------------------------------------
// s83
// -----------------------------------------------
WorksheetStyle s83 = styles.Add("s83");
s83.Font.FontName = "Verdana";
s83.Font.Color = "#000000";
s83.Interior.Color = "#FFFFFF";
s83.Interior.Pattern = StyleInteriorPattern.Solid;
s83.Alignment.Vertical = StyleVerticalAlignment.Center;
s83.Alignment.WrapText = true;
// -----------------------------------------------
// s89
// -----------------------------------------------
WorksheetStyle s89 = styles.Add("s89");
s89.Font.Bold = true;
s89.Font.FontName = "Verdana";
s89.Font.Color = "#000000";
s89.Interior.Color = "#C2C2C2";
s89.Interior.Pattern = StyleInteriorPattern.Solid;
s89.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s89.Alignment.Vertical = StyleVerticalAlignment.Center;
s89.Alignment.WrapText = true;
s89.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 3, "#959595");
s89.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
s89.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s90
// -----------------------------------------------
WorksheetStyle s90 = styles.Add("s90");
s90.Font.Bold = true;
s90.Font.FontName = "Verdana";
s90.Font.Color = "#000000";
s90.Interior.Color = "#C2C2C2";
s90.Interior.Pattern = StyleInteriorPattern.Solid;
s90.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s90.Alignment.Vertical = StyleVerticalAlignment.Center;
s90.Alignment.WrapText = true;
s90.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 2, "#959595");
s90.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s91
// -----------------------------------------------
WorksheetStyle s91 = styles.Add("s91");
s91.Font.Bold = true;
s91.Font.FontName = "Verdana";
s91.Font.Color = "#000000";
s91.Interior.Color = "#C2C2C2";
s91.Interior.Pattern = StyleInteriorPattern.Solid;
s91.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s91.Alignment.Vertical = StyleVerticalAlignment.Center;
s91.Alignment.WrapText = true;
s91.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 3, "#959595");
s91.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s129
// -----------------------------------------------
WorksheetStyle s129 = styles.Add("s129");
s129.Font.FontName = "Verdana";
s129.Font.Color = "#000000";
s129.Interior.Color = "#FFFFFF";
s129.Interior.Pattern = StyleInteriorPattern.Solid;
s129.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s129.Alignment.Vertical = StyleVerticalAlignment.Center;
s129.Alignment.WrapText = true;
// -----------------------------------------------
// s130
// -----------------------------------------------
WorksheetStyle s130 = styles.Add("s130");
s130.Font.Bold = true;
s130.Font.FontName = "Verdana";
s130.Font.Color = "#000000";
s130.Interior.Color = "#FFFFFF";
s130.Interior.Pattern = StyleInteriorPattern.Solid;
s130.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s130.Alignment.Vertical = StyleVerticalAlignment.Center;
s130.Alignment.WrapText = true;
// -----------------------------------------------
// s131
// -----------------------------------------------
WorksheetStyle s131 = styles.Add("s131");
s131.Font.Bold = true;
s131.Font.FontName = "Verdana";
s131.Font.Color = "#000000";
s131.Interior.Color = "#FFFFFF";
s131.Interior.Pattern = StyleInteriorPattern.Solid;
s131.Alignment.Vertical = StyleVerticalAlignment.Center;
s131.Alignment.WrapText = true;
// -----------------------------------------------
// s132
// -----------------------------------------------
WorksheetStyle s132 = styles.Add("s132");
s132.Font.FontName = "Verdana";
s132.Font.Size = 18;
s132.Font.Color = "#000000";
s132.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s132.Alignment.Vertical = StyleVerticalAlignment.Center;
s132.Alignment.WrapText = true;
// -----------------------------------------------
// s133
// -----------------------------------------------
WorksheetStyle s133 = styles.Add("s133");
s133.Font.FontName = "Verdana";
s133.Font.Color = "#666666";
s133.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s133.Alignment.Vertical = StyleVerticalAlignment.Center;
s133.Alignment.WrapText = true;
// -----------------------------------------------
// s134
// -----------------------------------------------
WorksheetStyle s134 = styles.Add("s134");
s134.Alignment.Vertical = StyleVerticalAlignment.Center;
s134.Alignment.WrapText = true;
// -----------------------------------------------
// s135
// -----------------------------------------------
WorksheetStyle s135 = styles.Add("s135");
s135.Font.Bold = true;
s135.Font.FontName = "Verdana";
s135.Font.Color = "#000000";
s135.Alignment.Vertical = StyleVerticalAlignment.Center;
s135.Alignment.WrapText = true;
// -----------------------------------------------
// s136
// -----------------------------------------------
WorksheetStyle s136 = styles.Add("s136");
s136.Font.FontName = "Verdana";
s136.Font.Color = "#000000";
s136.Alignment.Vertical = StyleVerticalAlignment.Center;
s136.Alignment.WrapText = true;
// -----------------------------------------------
// s137
// -----------------------------------------------
WorksheetStyle s137 = styles.Add("s137");
s137.Font.FontName = "Verdana";
s137.Font.Color = "#000000";
s137.Alignment.Vertical = StyleVerticalAlignment.Center;
s137.Alignment.WrapText = true;
s137.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 3, "#959595");
// -----------------------------------------------
// s141
// -----------------------------------------------
WorksheetStyle s141 = styles.Add("s141");
s141.Alignment.Horizontal = StyleHorizontalAlignment.Left;
s141.Alignment.Vertical = StyleVerticalAlignment.Top;
}
/// <summary>
/// Erstelle die Layout Styles
/// </summary>
/// <param name="styles"></param>
private void GenerateStyles(WorksheetStyleCollection styles) {
// -----------------------------------------------
// Allgemein
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Default";
// -----------------------------------------------
// Ergebnis1
// -----------------------------------------------
WorksheetStyle Result = styles.Add("Result");
Result.Name = "Result";
Result.Font.Bold = true;
Result.Font.Italic = true;
Result.Font.Underline = UnderlineStyle.Single;
Result.Font.Size = 10;
// -----------------------------------------------
// Ergebnis2
// -----------------------------------------------
WorksheetStyle Result2 = styles.Add("Result2");
Result2.Name = "Result2";
Result2.Font.Bold = true;
Result2.Font.Italic = true;
Result2.Font.Underline = UnderlineStyle.Single;
Result2.Font.Size = 10;
// -----------------------------------------------
// Überschrift
// -----------------------------------------------
WorksheetStyle Heading = styles.Add("Heading");
Heading.Name = "Heading";
Heading.Font.Bold = true;
Heading.Font.Italic = true;
Heading.Font.Size = 11;
// -----------------------------------------------
// Überschrift2
// -----------------------------------------------
WorksheetStyle Heading1 = styles.Add("Heading1");
Heading1.Name = "Heading1";
Heading1.Font.Bold = true;
Heading1.Font.Italic = true;
Heading1.Font.Size = 11;
// -----------------------------------------------
// Normales Layout
// -----------------------------------------------
WorksheetStyle Normal = styles.Add("Normal");
Normal.Name = "Normal";
Normal.Font.FontName = "Tahoma1";
Normal.Font.Size = 11;
// -----------------------------------------------
// Spalte1
// -----------------------------------------------
WorksheetStyle co1 = styles.Add("co1");
// -----------------------------------------------
// Spalte2
// -----------------------------------------------
WorksheetStyle co2 = styles.Add("co2");
// -----------------------------------------------
// Spalte3
// -----------------------------------------------
WorksheetStyle co3 = styles.Add("co3");
// -----------------------------------------------
// Spalte4
// -----------------------------------------------
WorksheetStyle co4 = styles.Add("co4");
// -----------------------------------------------
// Spalte5
// -----------------------------------------------
WorksheetStyle co5 = styles.Add("co5");
// -----------------------------------------------
// Spalte6
// -----------------------------------------------
WorksheetStyle co6 = styles.Add("co6");
// -----------------------------------------------
// Spalte7
// -----------------------------------------------
WorksheetStyle co7 = styles.Add("co7");
// -----------------------------------------------
// Spalte8
// -----------------------------------------------
WorksheetStyle co8 = styles.Add("co8");
// -----------------------------------------------
// Spalte9
// -----------------------------------------------
WorksheetStyle co9 = styles.Add("co9");
// -----------------------------------------------
// Spalte10
// -----------------------------------------------
WorksheetStyle co10 = styles.Add("co10");
// -----------------------------------------------
// ta1
// -----------------------------------------------
WorksheetStyle ta1 = styles.Add("ta1");
// -----------------------------------------------
// neuer Style "normal"
// -----------------------------------------------
WorksheetStyle ce1 = styles.Add("ce1");
ce1.Parent = "Normal";
ce1.Font.Bold = true;
ce1.Font.FontName = "Tahoma1";
ce1.Font.Size = 11;
ce1.Interior.Color = _HEADERCOLOR;
ce1.Interior.Pattern = StyleInteriorPattern.Solid;
ce1.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce1.Alignment.Vertical = StyleVerticalAlignment.Center;
ce1.Alignment.WrapText = true;
ce1.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle2
// -----------------------------------------------
WorksheetStyle ce2 = styles.Add("ce2");
ce2.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce2.Alignment.Vertical = StyleVerticalAlignment.Center;
ce2.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
ce2.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle3
// -----------------------------------------------
WorksheetStyle ce3 = styles.Add("ce3");
ce3.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce3.Alignment.Vertical = StyleVerticalAlignment.Center;
ce3.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle4
// -----------------------------------------------
WorksheetStyle ce4 = styles.Add("ce4");
ce4.Parent = "Normal";
ce4.Font.Bold = true;
ce4.Font.FontName = "Tahoma1";
ce4.Font.Size = 11;
ce4.Interior.Color = _HEADERCOLOR;
ce4.Interior.Pattern = StyleInteriorPattern.Solid;
ce4.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce4.Alignment.Vertical = StyleVerticalAlignment.Center;
ce4.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle5
// -----------------------------------------------
WorksheetStyle ce5 = styles.Add("ce5");
ce5.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce5.Alignment.Vertical = StyleVerticalAlignment.Center;
ce5.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
ce5.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle6
// -----------------------------------------------
WorksheetStyle ce6 = styles.Add("ce6");
ce6.Parent = "Normal";
ce6.Font.Bold = true;
ce6.Font.FontName = "Tahoma1";
ce6.Font.Size = 11;
ce6.Interior.Color = _HEADERCOLOR;
ce6.Interior.Pattern = StyleInteriorPattern.Solid;
ce6.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce6.Alignment.Vertical = StyleVerticalAlignment.Center;
ce6.Alignment.WrapText = true;
ce6.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce6.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle7
// -----------------------------------------------
WorksheetStyle ce7 = styles.Add("ce7");
ce7.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce7.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// WorksheetStyle8
// -----------------------------------------------
WorksheetStyle ce8 = styles.Add("ce8");
ce8.Font.Bold = true;
ce8.Font.FontName = "Tahoma";
ce8.Font.Size = 11;
ce8.Interior.Color = _HEADERCOLOR;
ce8.Interior.Pattern = StyleInteriorPattern.Solid;
ce8.Alignment.Horizontal = StyleHorizontalAlignment.Center;
ce8.Alignment.Vertical = StyleVerticalAlignment.Center;
ce8.Alignment.WrapText = true;
ce8.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1, "#000000");
ce8.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1, "#000000");
// -----------------------------------------------
// WorksheetStyle9
// -----------------------------------------------
WorksheetStyle ce9 = styles.Add("ce9");
ce9.Parent = "Normal";
ce9.Font.Bold = true;
ce9.Font.FontName = "Tahoma1";
ce9.Font.Size = 11;
ce9.Interior.Color = _HEADERCOLOR;
ce9.Interior.Pattern = StyleInteriorPattern.Solid;
ce9.Alignment.Horizontal = StyleHorizontalAlignment.Left;
ce9.Alignment.Vertical = StyleVerticalAlignment.Center;
ce9.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
ce9.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
//
// WorksheetStyle10
//
WorksheetStyle cell10 = styles.Add("ce10");
cell10.Alignment.Horizontal = StyleHorizontalAlignment.Center;
cell10.Alignment.Vertical = StyleVerticalAlignment.Center;
cell10.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
//
// WorksheetStyle11
//
WorksheetStyle cell11 = styles.Add("ce11");
cell11.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1, "#000000");
cell11.Alignment.Horizontal = StyleHorizontalAlignment.Left;
//cell11.Alignment.WrapText = true;
cell11.Alignment.Vertical = StyleVerticalAlignment.Center;
cell11.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1, "#000000");
}
private void GenerateStyles(WorksheetStyleCollection styles)
{
// -----------------------------------------------
// Default
// -----------------------------------------------
WorksheetStyle Default = styles.Add("Default");
Default.Name = "Normal";
Default.Font.FontName = "Calibri";
Default.Font.Size = 11;
Default.Font.Color = "#000000";
Default.Alignment.Vertical = StyleVerticalAlignment.Bottom;
// -----------------------------------------------
// s97
// -----------------------------------------------
WorksheetStyle s97 = styles.Add("s97");
s97.Font.FontName = "Times New Roman";
s97.Font.Size = 11;
s97.Font.Color = "#000000";
s97.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s97.Alignment.Vertical = StyleVerticalAlignment.Center;
s97.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s97.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s97.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s97.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s102
// -----------------------------------------------
WorksheetStyle s102 = styles.Add("s102");
s102.Font.Italic = true;
s102.Font.FontName = "Times New Roman";
s102.Font.Size = 11;
s102.Font.Color = "#000000";
s102.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s102.Alignment.Vertical = StyleVerticalAlignment.Center;
s102.Alignment.WrapText = true;
s102.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s102.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s102.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s103
// -----------------------------------------------
WorksheetStyle s103 = styles.Add("s103");
s103.Font.Bold = true;
s103.Font.FontName = "Times New Roman";
s103.Font.Size = 16;
s103.Font.Color = "#000000";
s103.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s103.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// s104
// -----------------------------------------------
WorksheetStyle s104 = styles.Add("s104");
s104.Font.Italic = true;
s104.Font.FontName = "Times New Roman";
s104.Font.Size = 11;
s104.Font.Color = "#000000";
s104.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s104.Alignment.Vertical = StyleVerticalAlignment.Center;
// -----------------------------------------------
// s107
// -----------------------------------------------
WorksheetStyle s107 = styles.Add("s107");
s107.Font.Bold = true;
s107.Font.FontName = "Times New Roman";
s107.Font.Size = 12;
s107.Font.Color = "#FF0000";
s107.Interior.Color = "#FFFF00";
s107.Interior.Pattern = StyleInteriorPattern.Solid;
s107.Alignment.Horizontal = StyleHorizontalAlignment.Right;
s107.Alignment.Vertical = StyleVerticalAlignment.Center;
s107.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s107.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s107.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s107.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s120
// -----------------------------------------------
WorksheetStyle s120 = styles.Add("s120");
s120.Font.Bold = true;
s120.Font.FontName = "Times New Roman";
s120.Font.Size = 12;
s120.Font.Color = "#376091";
s120.Interior.Color = "#FCD5B4";
s120.Interior.Pattern = StyleInteriorPattern.Solid;
s120.Alignment.Horizontal = StyleHorizontalAlignment.Center;
s120.Alignment.Vertical = StyleVerticalAlignment.Center;
s120.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s120.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s120.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s120.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s126
// -----------------------------------------------
WorksheetStyle s126 = styles.Add("s126");
s126.Font.Bold = true;
s126.Font.Italic = true;
s126.Font.FontName = "Times New Roman";
s126.Font.Size = 11;
s126.Font.Color = "#000000";
s126.Interior.Color = "#DBE5F1";
s126.Interior.Pattern = StyleInteriorPattern.Solid;
s126.Alignment.Vertical = StyleVerticalAlignment.Center;
s126.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s126.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s126.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s126.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s126.NumberFormat = "Standard";
// -----------------------------------------------
// s132
// -----------------------------------------------
WorksheetStyle s132 = styles.Add("s132");
s132.Font.FontName = "Times New Roman";
s132.Font.Size = 11;
s132.Font.Color = "#000000";
s132.Alignment.Vertical = StyleVerticalAlignment.Center;
s132.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s132.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s132.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s132.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
// -----------------------------------------------
// s133
// -----------------------------------------------
WorksheetStyle s133 = styles.Add("s133");
s133.Font.Bold = true;
s133.Font.FontName = "Times New Roman";
s133.Font.Size = 12;
s133.Font.Color = "#FF0000";
s133.Interior.Color = "#FFFF00";
s133.Interior.Pattern = StyleInteriorPattern.Solid;
s133.Alignment.Vertical = StyleVerticalAlignment.Center;
s133.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
s133.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
s133.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
s133.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
s133.NumberFormat = "Standard";
}