'DeclarationPublic Function ImportData( _ ByVal data As Object, _ Optional ByVal options As ImportOptions _ ) As Integer
'UsageDim instance As Worksheet Dim data As Object Dim options As ImportOptions Dim value As Integer value = instance.ImportData(data, options)
public int ImportData( object data, ImportOptions options )
Parameters
- data
- The data to import.
The data can be of any of the supported types:- Array (like string[], int[], MyProduct[], object[]...)
- 2D-Array (like double[,], string[,], MyProduct[,], object[,])
- ArrayList
- ICollection (like
List<string>, List<MyProduct>, ObservableCollection<MyProduct>, Array<int>, ...) - IDictionary (like Dictionary<int, string>, Dictionary<int, MyProduct>, ...)
- DataTable (with DataColumns and DataRows)
- DataView
- CSV path/stream (a path to a CSV document or a stream based on a CSV document).
- options
The options when importing the data.
These can be any of the following:
Return Value
The number of items imported in the Worksheet.