Register an Excel Worksheet File from MashZone NextGen Hub
Use this procedure for Excel spreadsheets that are located on your computer or a network drive.
1. Select Connect > Excel File in the MashZone NextGen Hub main menu.
3. Set Upload File as the location of the spreadsheet.
4. Click Browse and find the Excel spreadsheet you want to use.
5. 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".
6. 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. Click Register.
MashZone NextGen uploads a snapshot of the spreadsheet data, 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.
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.
Note: Some groups or users may already be listed as Principals with permissions. These users and groups have been defined by a MashZone NextGen administrator to grant permission automatically.