extractUpdateTime: string | undefined
id: string
isExtract: boolean
isPublished: boolean | undefined
name: string
An array of table summary objects that are currently used in the data source.
An array of descriptions of the connections within this data source.
A data table containing the underlying data of the data source.
An array of logical tables that are currently used in the data source.
The following example uses the getLogicalTablesAsync method to print the names of the the logical tables to the console.
dataSource.getLogicalTablesAsync().then(function (logicalTables) {
// Loop through each table that was used in creating this data source
logicalTables.forEach(function (table) {
console.log(table.caption);
});
});Returns a promise containing a page of data from the underlying data of the data source.
The following example shows use of the getUnderlyingDataAsync() method to get the underlying data from a specific data source. The example uses the JavaScript find() method to select the workbook and data source.
const dataSources = await worksheet.getDataSourcesAsync();
const dataSource = dataSources.find(datasource => datasource.name === "Sample - Superstore");
const dataTable = await dataSource.getUnderlyingDataAsync();
let field = dataTable.columns.find(column => column.fieldName === "Sub-Category");
let list = [];
for (let row of dataTable.data) {
list.push(row[field.index].value);
}
let values = list.filter((el, i, arr) => arr.indexOf(el) === i);
console.log(values);
Promise that resolves when the data source has finished refreshing.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4