Ejemplo n.º 1
0
        private static void AddColumnNames(Excel.Worksheet sheet)
        {
            string[] tempHeadingArray =
            {
                "FirstName",
                "LastName",
                "Income",
                "Tax",
                "Total Income"
            };

            var columnNameRange = sheet.get_Range(sheet.Cells[3, 1], sheet.Cells[3, tempHeadingArray.Length]);
            columnNameRange.Style = "NewStyle";
            columnNameRange.Font.Size = 10;
            columnNameRange.Value = tempHeadingArray;
            columnNameRange.UseStandardWidth = true;
            columnNameRange.ColumnWidth = 14;
            columnNameRange.WrapText = true;
        }