CellsImportFromDataReader Method (SqlDataReader, Boolean, Int32, Int32, Boolean, String, Boolean)

Note: This API is now obsolete.

Imports data from a SqlDataReader object.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.9.0.0 (20.9)
Syntax
[ObsoleteAttribute("Use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method, instead.")]
public int ImportFromDataReader(
	SqlDataReader reader,
	bool isFieldNameShown,
	int firstRow,
	int firstColumn,
	bool insertRows,
	string dateFormatString,
	bool convertStringToNumber
)

Parameters

reader
Type: System.Data.SqlClientSqlDataReader
The SqlDataReader object which contains data.
isFieldNameShown
Type: SystemBoolean
Indicates whether the field name of the data reader will be imported to the first row.
firstRow
Type: SystemInt32
The row number of the first cell to import in.
firstColumn
Type: SystemInt32
The column number of the first cell to import in.
insertRows
Type: SystemBoolean
Indicates whether extra rows are added to fit data.
dateFormatString
Type: SystemString
Date format string for cells.
convertStringToNumber
Type: SystemBoolean
Indicates if this method will try to convert string to number.

Return Value

Type: Int32
Total number of rows imported.
Remarks
NOTE: This member is now obsolete. Instead, please use Cells.ImportData(IDataReader, int, int,ImportTableOptions) method. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.
See Also