Spreadsheet Mashables
You can use Excel spreadsheets as a mashable information source in Presto by registering cell ranges as:
A snapshot of data for Excel spreadsheets on your local computer or any accessible network drive. With local spreadsheets, you must reregister to update the spreadsheet mashable in
Presto if you update spreadsheet data and want that information to be accessible in
Presto.
A dynamic source of data for Excel spreadsheets that are accessible remotely via HTTP. Remote access allows
Presto to retrieve current data whenever the mashable information source is used.For example, spreadsheets hosted in SharePoint can be registered remotely.
Note: | Remote spreadsheet mashables are handled as REST mashables in Presto. With remote spreadsheet mashables, Presto administrators can also control HTTP response headers and timeouts for connections. |