Support autocompletion/extraction of column names when using an Excel connection.
Display column nodes in the Schema browser when "Table" is expanded.
At the moment in v15.0 we support "Schema" and "Table" but we do not support column name autocompletion.
Keep in mind that some excel files might have multiple areas on the same sheet that could be considered "tables"
- In schema browser, the Columns node is displayed when an Excel table is expanded.
- The Table Properties dialog displays columns for an Excel table.
- Auto-complete for column names is now supported.
- Query Builder has been enhanced to handle column names for Excel tables.
- In the Advanced tab of the Server Registration dialog, there is a new "No Header Row in Worksheet" property which indicates whether the first row in the worksheet should be treated as column names.
- New ExcelSQL command:
SHOW [NO_HEADER_ROW] COLUMNS table_name [database_name schema_name]
>Select * from <tablename>. -- Does not autocomplete
>Select * from <tablename>. -- Does not autocomplete
Issue #12510 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 15.0.9-2 |
No time estimate |
2 issue links |
relates to #11132
Issue #11132In script object option "SELECT" option is missing in MS Excel connection. |
relates to #12584
Issue #12584Improve Excel Show Column Command to make it consistent with other DBs |
- In schema browser, the Columns node is displayed when an Excel table is expanded.
- The Table Properties dialog displays columns for an Excel table.
- Auto-complete for column names is now supported.
- Query Builder has been enhanced to handle column names for Excel tables.
- In the Advanced tab of the Server Registration dialog, there is a new "No Header Row in Worksheet" property which indicates whether the first row in the worksheet should be treated as column names.
- New ExcelSQL command:
SHOW [NO_HEADER_ROW] COLUMNS table_name [database_name schema_name]