Register a Range of Cells From the Current Worksheet
If needed, set connection information to the
MashZone NextGen Server where you want to register a mashable for this worksheet. See
Configuring the Connection to
MashZone NextGen for instructions. See
Register a Worksheet as a Spreadsheet Mashable in
MashZone NextGen for basic information about registering mashables for worksheets.
1. Open the workbook and worksheet you want to register as a mashable.
2. Click 
Register/Update a Spreadsheet Mashable in the MashZone NextGen Toolbar. 3. Click Next in the welcome window of the Register Wizard.
4. In the Choose Data Source window:
a. Set the From a Range in the Current Worksheet option.
b. Click Select Range.
c. In the worksheet, select the range of cells you want to export.
d. In the Wizard, click Done once the range of cells is correct.
e. Click Next.
5. Select the option to use for column names in the spreadsheet mashable:
Use first row of range as column names is the default.
Pick a row number for column names set this option and enter the number of the row within your range of cells that contains column names.
Select a range for column names set this option and click
Select Columns. In the worksheet, select a range of cells within
one row that you want to use as column names and click
Done.
If any cell in this row is empty, the MashZone NextGen Add-On for Excel will generate simple column names, such as Column1, Column2 and so on.
6. Click Next.
7. Review the range selected in the Data Preview window and click Next if this is correct.
8. Complete information for the mashable you are publishing:
a. Enter a unique Name for this mashable.
MashZone NextGen uses the mashable name to assign a unique identifer to mashables. Mashable names can contain characters from the character sets supported by theMashZone NextGenRepository, numbers, spaces, tabs, line ends and these common symbols: _ ~ - * ' .
b. Optionally, select a Provider for this mashable, add Tags or enter a Description for this mashable.
You can also use the built-in provider: NONE.
c. Click Next.
9. Click OK once all information is correct.
Excel confirms that the mashable is successfully registered.
