varworkbook=newXLWorkbook();varws=workbook.Worksheets.Add("Inserting Columns");// Color the entire spreadsheet using columnsws.Columns().Style.Fill.BackgroundColor=XLColor.LightCyan;// Put a value in a few cellsforeach(varrinEnumerable.Range(1,5))foreach(varcinEnumerable.Range(1,5))ws.Cell(r,c).Value="X";

varblueColumn=ws.Column(2);varredColumn=ws.Column(5);blueColumn.Style.Fill.BackgroundColor=XLColor.Blue;blueColumn.InsertColumnsAfter(2);redColumn.Style.Fill.BackgroundColor=XLColor.Red;redColumn.InsertColumnsBefore(2);ws.Rows(3,4).Style.Fill.BackgroundColor=XLColor.Orange;ws.Range("B1:D1").InsertColumnsAfter(2);ws.Range("B2:D2").InsertColumnsBefore(2);ws.Range("B3:D3").InsertColumnsAfter(2);ws.Range("B4:D4").InsertColumnsBefore(2);workbook.SaveAs("InsertingColumns.xlsx");