Mashables : Types of Mashable Information Sources : Spreadsheet Mashables
Spreadsheet Mashables
 
Valid Labels and Values for Spreadsheet/CSV 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. See Configure HTTP Response Header Forwarding and Configure Mashable HTTP Request Timeouts for more information.
See Register an Excel Worksheet File from Presto Hub or The Presto Add-On for Excel for more information about registering spreadsheets. See Valid Labels and Values for Spreadsheet/CSV Mashables also.
Copyright © 2006-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback