Aspose.Cells.QueryTables
The Aspose.Cells.QueryTables namespace provides classes to access and update worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database.
Classes
| Class | Description |
|---|---|
| DataMashup | Represents mashup data. |
| PowerQueryFormula | Represents the definition of power query formula. |
| PowerQueryFormulaCollection | Represents all power query formulas in the mashup data. |
| PowerQueryFormulaFunction | Represents the function of power query. |
| PowerQueryFormulaItem | Represents the item of the power query formula. |
| PowerQueryFormulaItemCollection | Represents all item of the power query formula. |
| PowerQueryFormulaParameter | Represents the parameter of power query formula. |
| PowerQueryFormulaParameterCollection |
Enumeration
| Enumeration | Description |
|---|---|
| PowerQueryFormulaType | Represents the type of power query formula. |