[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataReader(SAWorksheet Worksheet, IDataReader DataReader,
		bool ShowFieldNames, int FirstRow, int FirstCol)

GetDataFromDataReader imports an IDataReader into a specified range of cells, and returns a Range object

• Worksheet
  The DataReader will be imported to this worksheet.
• DataReader
  This parameter must be an instance of System.Data.SqlClient.SqlDataReader or System.Data.OleDb.OleDbDataReader, or GetDataFromDataReader will throw an exception.
• ShowFieldNames
  If set to True, DataReader column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataReader.
• FirstCol
  First worksheet column for the imported DataReader.

A Range object.

SARange Range3 = XlwApp.GetDataFromDataReader(WrkSht3, Reader, true, 7, 1);

[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataReader(SAWorksheet Worksheet, IDataReader DataReader,
		bool ShowFieldNames, int FirstRow, int FirstCol, int MaxRows, int MaxColumns)

GetDataFromDataReader imports an IDataReader into a specified range of cells, and returns a Range object.

• Worksheet
  The DataReader will be imported to this worksheet.
• DataReader
  This parameter must be an instance of System.Data.SqlClient.SqlDataReader or System.Data.OleDb.OleDbDataReader, or GetDataFromDataReader will throw an exception.
• ShowFieldNames
  If set to True, DataReader column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataReader.
• FirstCol
  First worksheet column for the imported DataReader.
• 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.

A Range object.

SARange Range3 = XlwApp.GetDataFromDataReader(WrkSht3, Reader, true, 
		7, 1, 50, 10);

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

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

• Worksheet
  The DataReader will be imported to this worksheet.
• DataReader
  This parameter must be an instance of System.Data.SqlClient.SqlDataReader or System.Data.OleDb.OleDbDataReader, or GetDataFromDataReader will throw an exception.
• ShowFieldNames
  If set to True, DataReader column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataReader.
• FirstCol
  First worksheet column for the imported DataReader.
• FieldList
  DataReader fields to include or exclude in the spreadsheet, depending on the value of FieldListMode. The parameter FieldList is a comma delimited string specifying DataReader 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 Range3 = XlwApp.GetDataFromDataReader(WrkSht3, Reader, true, 7, 1
		"ID,Category", saxlsExclude);

[C#]
public SARange ExcelApplicationDotNet.GetDataFromDataReader(SAWorksheet Worksheet, IDataReader DataReader,
		bool ShowFieldNames, int FirstRow, int FirstCol, int MaxRows, int MaxColumns, 
		string FieldList, SAXLFieldListMode FieldListMode)

GetDataFromDataReader imports an IDataReader into a specified range of cells, and returns a Range object.

• Worksheet
  The DataReader will be imported to this worksheet.
• DataReader
  This parameter must be an instance of System.Data.SqlClient.SqlDataReader or System.Data.OleDb.OleDbDataReader, or GetDataFromDataReader will throw an exception.
• ShowFieldNames
  If set to True, DataReader column headers will be imported to the first row.
• FirstRow
  First worksheet row for the imported DataReader.
• FirstCol
  First worksheet column for the imported DataReader.
• 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
  DataReader fields to include or exclude in the spreadsheet, depending on the value of FieldListMode. The parameter FieldList is a comma delimited string specifying DataReader 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 Range3 = XlwApp.GetDataFromDataReader(WrkSht3, Reader, true, 7, 1,
		50, 10, "ID,Category", saxlsExclude);