public class DataTableImportOptions : ImportOptions 

var workbook = Workbook.Create("test.xlsx" );



var worksheet = workbook.Worksheets[ 0 ];



// Define a dataTable, the import options(show specific ColumnNames) and call the ImportData function.



  var dataTable = new DataTable( "Employees" );

  dataTable.Columns.Add( "Name", typeof( string ) );

  dataTable.Columns.Add( "Position", typeof( string ) );

  dataTable.Columns.Add( "Experience", typeof( double ) );

  dataTable.Columns.Add( "Salary", typeof( int ) );

  dataTable.Rows.Add( "Jenny Melchuck", "Project Manager", 11.5d, 77000 );

  dataTable.Rows.Add( "Cindy Gartner", "Medical Assistant", 1.3d, 56000 );

  dataTable.Rows.Add( "Carl Jones", "Web Designer", 4d, 66000 );

  dataTable.Rows.Add( "Anna Karlweiss", "Account Executive", 7.8d, 51000 );

  dataTable.Rows.Add( "Julia Robertson", "Marketing Coordinator", 17.6d, 65000 );

  var dataTableImportOptions = new DataTableImportOptions() { DestinationTopLeftAddress = "B5", ColumnNames = new string[] { "Name", "Experience", "Position" }, IsColumnNamesShown = true };

  worksheet.ImportData( dataTable, dataTableImportOptions );



workbook.Save();