publicvoidCreate(){varwb=newXLWorkbook();varws=wb.Worksheets.Add("Inserting Tables");// From a list of stringsvarlistOfStrings=newList<String>();listOfStrings.Add("House");listOfStrings.Add("Car");ws.Cell(1,1).Value="From Strings";ws.Cell(1,1).AsRange().AddToNamed("Titles");vartableWithStrings=ws.Cell(2,1).InsertTable(listOfStrings);// From a list of arraysvarlistOfArr=newList<Int32[]>();listOfArr.Add(newInt32[]{1,2,3});listOfArr.Add(newInt32[]{1});listOfArr.Add(newInt32[]{1,2,3,4,5,6});ws.Cell(1,3).Value="From Arrays";ws.Range(1,3,1,8).Merge().AddToNamed("Titles");vartableWithArrays=ws.Cell(2,3).InsertTable(listOfArr);// From a DataTablevardataTable=GetTable();ws.Cell(7,1).Value="From DataTable";ws.Range(7,1,7,4).Merge().AddToNamed("Titles");vartableWithData=ws.Cell(8,1).InsertTable(dataTable.AsEnumerable());// From a queryvarlist=newList<Person>();list.Add(newPerson(){Name="John",Age=30,House="On Elm St."});list.Add(newPerson(){Name="Mary",Age=15,House="On Main St."});list.Add(newPerson(){Name="Luis",Age=21,House="On 23rd St."});list.Add(newPerson(){Name="Henry",Age=45,House="On 5th Ave."});varpeople=frompinlistwherep.Age>=21selectnew{p.Name,p.House,p.Age};ws.Cell(7,6).Value="From Query";ws.Range(7,6,7,8).Merge().AddToNamed("Titles");vartableWithPeople=ws.Cell(8,6).InsertTable(people.AsEnumerable());// Prepare the style for the titlesvartitlesStyle=wb.Style;titlesStyle.Font.Bold=true;titlesStyle.Alignment.Horizontal=XLAlignmentHorizontalValues.Center;titlesStyle.Fill.BackgroundColor=XLColor.Cyan;// Format all titles in one shotwb.NamedRanges.NamedRange("Titles").Ranges.Style=titlesStyle;ws.Columns().AdjustToContents();wb.SaveAs("InsertingTables.xlsx");}classPerson{publicStringHouse{get;set;}publicStringName{get;set;}publicInt32Age{get;set;}}privateDataTableGetTable(){DataTabletable=newDataTable();table.Columns.Add("Dosage",typeof(int));table.Columns.Add("Drug",typeof(string));table.Columns.Add("Patient",typeof(string));table.Columns.Add("Date",typeof(DateTime));table.Rows.Add(25,"Indocin","David",DateTime.Now);table.Rows.Add(50,"Enebrel","Sam",DateTime.Now);table.Rows.Add(10,"Hydralazine","Christoff",DateTime.Now);table.Rows.Add(21,"Combivent","Janet",DateTime.Now);table.Rows.Add(100,"Dilantin","Melanie",DateTime.Now);returntable;}