void options_CustomizeSheetHeader(DevExpress.Export.ContextEventArgs e) { // Create a new row. CellObject row = new CellObject(); XlFormattingObject rowFormatting = new XlFormattingObject(); // Specify row values. row.Value = "CORTE ALQUILER"; rowFormatting.Font = new XlCellFont { Bold = true, Size = 14 }; rowFormatting.BackColor = Color.Orange; rowFormatting.Alignment = new DevExpress.Export.Xl.XlCellAlignment { HorizontalAlignment = DevExpress.Export.Xl.XlHorizontalAlignment.Center, VerticalAlignment = DevExpress.Export.Xl.XlVerticalAlignment.Top }; row.Formatting = rowFormatting; // Add the created row to the output document. e.ExportContext.AddRow(new[] { row }); // Add an empty row to the output document. e.ExportContext.AddRow(); // Merge cells of two new rows. if (idArea == idAreaComercialSupervisor) { e.ExportContext.MergeCells(new DevExpress.Export.Xl.XlCellRange(new DevExpress.Export.Xl.XlCellPosition(0, 0), new DevExpress.Export.Xl.XlCellPosition(9, 1))); //EL 6 SON LAS COLUMNAS QUE TIENE EL REPORTE } else { e.ExportContext.MergeCells(new DevExpress.Export.Xl.XlCellRange(new DevExpress.Export.Xl.XlCellPosition(0, 0), new DevExpress.Export.Xl.XlCellPosition(8, 1))); //EL 6 SON LAS COLUMNAS QUE TIENE EL REPORTE } }
void options_CustomizeSheetHeader(DevExpress.Export.ContextEventArgs e) { // Create a new row. CellObject row = new CellObject(); XlFormattingObject rowFormatting = new XlFormattingObject(); // Specify row values. row.Value = "FACTURAS POR VENCER"; rowFormatting.Font = new XlCellFont { Bold = true, Size = 14 }; rowFormatting.BackColor = Color.Orange; rowFormatting.Alignment = new DevExpress.Export.Xl.XlCellAlignment { HorizontalAlignment = DevExpress.Export.Xl.XlHorizontalAlignment.Center, VerticalAlignment = DevExpress.Export.Xl.XlVerticalAlignment.Top }; row.Formatting = rowFormatting; // Add the created row to the output document. e.ExportContext.AddRow(new[] { row }); // Add an empty row to the output document. e.ExportContext.AddRow(); // Merge cells of two new rows. e.ExportContext.MergeCells(new DevExpress.Export.Xl.XlCellRange(new DevExpress.Export.Xl.XlCellPosition(0, 0), new DevExpress.Export.Xl.XlCellPosition(11, 1))); }