[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataTable(SAWorksheet Worksheet, DataTable DataTable,
		bool ShowFieldNames, int FirstRow, int FirstCol,
		string FieldList, SAXLFieldListMode FieldListMode)

GetDataFromDataTable imports an ADO.NET DataTable into a specified range of cells, and returns a Range object.

• Worksheet
  The DataTable will be imported to this worksheet.
• DataTable
  The ADO.NET DataTable to import to the worksheet.
• ShowFieldNames
  If set to True, DataTable column headers will be imported to the first row.
• MaxRows
  Specifies the maximum number of rows to import from the data source. To import the maximum rows available, use the constant ExcelApplication.ALL_ROWS. Note: Excel 95 will delete rows after 16,384.
• FieldList
  DataTable fields to include or exclude in the spreadsheet, depending on the value of FieldListMode. The parameter FieldList is a comma delimited string specifying DataTable fields to include or exclude. They may be referenced by field name or position, or both. The order in which fields are specified in the FieldList parameter is the order in which they will be returned.
• FieldListMode
  Includes or excludes fields listed in FieldList parameter. To include only fields specified by the parameter FieldList, set FieldListMode to saxlsInclude.

A Range object.

SARange Range1 = XlwApp.GetDataFromDataTable(WrkSht1, Table, true, 7, 1, 
		"ID,Category", saxlsExclude);

[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataTable(SAWorksheet Worksheet, DataTable DataTable,
		bool ShowFieldNames, int FirstRow, int FirstCol,
		string FieldList, SAXLFieldListMode FieldListMode)

GetDataFromDataTable imports an ADO.NET DataTable into a specified range of cells, and returns a Range object.

• Worksheet
  The DataTable will be imported to this worksheet.
• DataTable
  The ADO.NET DataTable to import to the worksheet.
• ShowFieldNames
  If set to True, DataTable column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataTable.
• FirstCol
  First worksheet column for the imported DataTable.
• FieldList
  DataTable fields to include or exclude in the spreadsheet, depending on the value of FieldListMode. The parameter FieldList is a comma delimited string specifying DataTable fields to include or exclude. They may be referenced by field name or position, or both. The order in which fields are specified in the FieldList parameter is the order in which they will be returned.
• FieldListMode
  Includes or excludes fields listed in FieldList parameter. To include only fields specified by the parameter FieldList, set FieldListMode to saxlsInclude.

A Range object.

SARange Range1 = XlwApp.GetDataFromDataTable(WrkSht1, Table, true, 7, 1, 
		"ID,Category", saxlsExclude);

[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataTable(SAWorksheet Worksheet, DataTable DataTable,
		bool ShowFieldNames, int FirstRow, int FirstCol,
		string FieldList, SAXLFieldListMode FieldListMode)

GetDataFromDataTable imports an ADO.NET DataTable into a specified range of cells, and returns a Range object.

• Worksheet
  The DataTable will be imported to this worksheet.
• DataTable
  The ADO.NET DataTable to import to the worksheet.
• ShowFieldNames
  If set to True, DataTable column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataTable.
• FirstCol
  First worksheet column for the imported DataTable.
• MaxRows
  Specifies the maximum number of rows to import from the data source. To import the maximum rows available, use the constant ExcelApplication.ALL_ROWS. Note: Excel 95 will delete rows after 16,384.
• MaxColumns
  Specifies the maximum number of columns to import from the data source. To import the maximum columns available, use the constant ExcelApplication.ALL_COLUMNS.
• FieldList
  DataTable fields to include or exclude in the spreadsheet, depending on the value of FieldListMode. The parameter FieldList is a comma delimited string specifying DataTable fields to include or exclude. They may be referenced by field name or position, or both. The order in which fields are specified in the FieldList parameter is the order in which they will be returned.
• FieldListMode
  Includes or excludes fields listed in FieldList parameter. To include only fields specified by the parameter FieldList, set FieldListMode to saxlsInclude.

A Range object.

SARange Range1 = XlwApp.GetDataFromDataTable(WrkSht1, Table, true, 7, 1, 
		50, 10, "ID,Category", saxlsExclude);

[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataTable(SAWorksheet Worksheet, DataTable DataTable,
		bool ShowFieldNames, int FirstRow, int FirstCol)

GetDataFromDataTable imports an ADO.NET DataTable into a specified range of cells, and returns a Range object.

• Worksheet
  The DataTable will be imported to this worksheet.
• DataTable
  The ADO.NET DataTable to import to the worksheet.
• ShowFieldNames
  If set to True, DataTable column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataTable.
• FirstCol
  First worksheet column for the imported DataTable.

A Range object.

SARange Range1 = XlwApp.GetDataFromDataTable(WrkSht1, Table, true, 7, 1);