[]
Gets all sheet names and tables names that will be used as the parameter source of ImportData.
If the name is a table name, the worksheet name is qualified before the table name, such as "Sheet1!Table1".
public static string[] GetNames(string fileName)
Public Shared Function GetNames(fileName As String) As String()
| Type | Name | Description |
|---|---|---|
| string | fileName | The path and name for the file. |
| Type | Description |
|---|---|
| string[] | An array of possible import names. |
Gets all sheet names and tables names that will be used as the parameter source of ImportData.
If the name is a table name, the worksheet name is qualified before the table name, such as "Sheet1!Table1".
public static string[] GetNames(Stream fileStream)
Public Shared Function GetNames(fileStream As Stream) As String()
| Type | Name | Description |
|---|---|---|
| Stream | fileStream | The fileStream of a workbook. |
| Type | Description |
|---|---|
| string[] | An array of possible import names. |