Important

This page is obsolete and no longer being actively maintained. Please refer to pageTables atdocs.closedxml.io for the latest information.

varwb=newXLWorkbook();

varws=wb.Worksheets.Add("Contacts");

// Titlews.Cell("B2").Value="Contacts";// First Namesws.Cell("B3").Value="FName";ws.Cell("B4").Value="John";ws.Cell("B5").Value="Hank";ws.Cell("B6").Value="Dagny";// Last Namesws.Cell("C3").Value="LName";ws.Cell("C4").Value="Galt";ws.Cell("C5").Value="Rearden";ws.Cell("C6").Value="Taggart";

// Booleanws.Cell("D3").Value="Outcast";ws.Cell("D4").Value=true;ws.Cell("D5").Value=false;ws.Cell("D6").Value=false;// DateTimews.Cell("E3").Value="DOB";ws.Cell("E4").Value=newDateTime(1919,1,21);ws.Cell("E5").Value=newDateTime(1907,3,4);ws.Cell("E6").Value=newDateTime(1921,12,15);// Numericws.Cell("F3").Value="Income";ws.Cell("F4").Value=2000;ws.Cell("F5").Value=40000;ws.Cell("F6").Value=10000;

// From worksheetvarrngTable=ws.Range("B2:F6");// From another rangevarrngDates=rngTable.Range("D3:D5");// The address is relative to rngTable (NOT the worksheet)varrngNumbers=rngTable.Range("E3:E5");// The address is relative to rngTable (NOT the worksheet)

// Using OpenXML's predefined formatsrngDates.Style.NumberFormat.NumberFormatId=15;// Using a custom formatrngNumbers.Style.NumberFormat.Format="$ #,##0";

varrngHeaders=rngTable.Range("A2:E2");// The address is relative to rngTable (NOT the worksheet)rngHeaders.Style.Alignment.Horizontal=XLAlignmentHorizontalValues.Center;rngHeaders.Style.Font.Bold=true;rngHeaders.Style.Fill.BackgroundColor=XLColor.Aqua;

rngTable.Style.Border.BottomBorder=XLBorderStyleValues.Thin;

rngTable.Cell(1,1).Style.Font.Bold=true;rngTable.Cell(1,1).Style.Fill.BackgroundColor=XLColor.CornflowerBlue;rngTable.Cell(1,1).Style.Alignment.Horizontal=XLAlignmentHorizontalValues.Center;

rngTable.Row(1).Merge();// We could've also used: rngTable.Range("A1:E1").Merge()

//Add a thick outside borderrngTable.Style.Border.OutsideBorder=XLBorderStyleValues.Thick;// You can also specify the border for each side with:// rngTable.FirstColumn().Style.Border.LeftBorder = XLBorderStyleValues.Thick;// rngTable.LastColumn().Style.Border.RightBorder = XLBorderStyleValues.Thick;// rngTable.FirstRow().Style.Border.TopBorder = XLBorderStyleValues.Thick;// rngTable.LastRow().Style.Border.BottomBorder = XLBorderStyleValues.Thick;

ws.Columns(2,6).AdjustToContents();

wb.SaveAs("BasicTable.xlsx");