Click or drag to resize

WorkBookToDataSet Method

Export workbook to a native System.Data DataSet.

Each worksheet represents a DataTable within the DataSet.

Useful when moving data between Excel and SQL.

Namespace:  IronXL
Assembly:  IronXL (in IronXL.dll) Version: 2019.3.2
public DataSet ToDataSet(
	bool useFirstRowAsColumnNames = false


useFirstRowAsColumnNames (Optional)
Type: SystemBoolean
if set to true [use first row as column names].

Return Value

Type: DataSet
A DataSet containing the entire WorkBook.
See Also