MashZone NextGen 10.2 | Appendix | Legacy Presto components | Mashables and Mashups | Mashables | Connect Information Sources as Mashables | Register Spreadsheets as Mashables | Register an Excel Worksheet With a URL from MashZone NextGen Hub
 
Register an Excel Worksheet With a URL from MashZone NextGen Hub
Use this procedure for Excel spreadsheets that are accessible with a URL using HTTP, such as through a content management system.
1. Select Connect > Excel File in the MashZone NextGen Hub main menu.
2. Enter a unique Name for the mashable for this spreadsheet.. MashZone NextGen uses this name to assign a unique ID. For more information, see What are valid artifact names and IDs?.
3. Set Link to URL as the location of the spreadsheet.
4. Enter the full URL to this Excel spreadsheet.
5. If this spreadsheet requires authentication information when you run it, choose the Security Profile to use for authentication and complete the fields for this profile. See Mashable Authentication with Security Profiles for details.
6. Enter the name or tab number for the Worksheet that contains the data you want to use in MashZone NextGen.
For example:
*3 identifies the worksheet in the third tab of this spreadsheet.
*RawData identifies the worksheet with the name "RawData".
7. Enter the Cell Range for the data that you want to use in this mashable in the form: top-left-cell:bottom-right-cell.
For example, A1:G88.
8. Add metadata for this mashable, such as a description or category. For more information, see Descriptions, Providers, Categories and Tags for Artifacts external.
9. Click Register.
MashZone NextGen validates the URL, registers the mashable and turns this mashable information source on (by default). Then, either:
*Grant permissions to run this mashable to other users and groups:
*Choose the mashble-wide Service >> mashable name permissions section to grant run permissions to all operations. Or expand a specific Operation >> operation name section to grant run permissions for just that operation.
*Find Users and Groups for Permissions or Choose MashZone NextGen Built-In Groups for Permissions.
*Click on a user or group in the Search result list to add them to the list of Principals with permissions.
*Save the permissions once the list is complete.
*Or skip permissions for now and click Finish.
To allow other users to work with this mashable, you must grant run permissions at a later time.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release