DataSourceImporter Methods |
The DataSourceImporter type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | FindColumn(ListString, Int32, IEnumerableString) | |
| FindColumn(ListString, Int32, IListString) | |
| FindColumn(ListString, Int32, String) | |
| FindNames | |
| FindTableNames | |
| Get | |
| GetColumnNames | |
| GetColumnNames(String) | |
| GetConnectionStringFromFile(String) | |
| GetConnectionStringFromFile(String, Boolean) | |
| GetDataRows | |
| GetDataRows(String, Boolean) | |
| GetDataTable | |
| GetDataTable(String) | |
| GetTableNames | |
| GetTableNames(String, Boolean) | |
| ReadDataTable |
Read a spreadsheet file straight into a datatable:
http://windowsclient.net/blogs/faqs/archive/2006/05/30/how-do-i-load-a-csv-file-into-a-datatable.aspx
Connection strings:
http://www.connectionstrings.com/
Where sourceString is an Excel file the table name is first checked against any defined names in the workbook and
if there is no defined name then the worksheet matching the tableName is used. Finally the first worksheet is used if
there is no other match.
|
 | ReadDataTableFromTextFile |
Read table data from a file (.txt,.csv,.xls,.xlsx,etc.).
|
| ToString | (Overrides ObjectToString.) |
See Also