Valid Spreadsheet Mashables
Workbooks or cell ranges should be limited to the following to create valid MashZone NextGen mashables:
Formulas in spreadsheets are valid, but the formula itself is not exported to the mashable in
MashZone NextGen. The result of the calculation (the data) is exported instead.
Column labels:
Are recommended, but optional, for each column that contains data.
If column labels are missing, MashZone NextGen automatically generates labels in the form Column1, Column2 and so on.
Are limited to letters, numbers and underscores in the ISO-8859-1 character set, also known as Latin 1.
Spaces and most symbols or punctuation characters are either converted to an underscore or ignored.
Must start with a letter (an alphabetical character) although they can contain numbers after that. Column labels that do not start with a letter are altered or overridden.
If a column label starts with a number or is a formatted date,
MashZone NextGen adds a prefix of
Column_ to the label.
Can only be provided by
one row. For CSV files, this must be the first row.
For spreadsheets you can identify which row supplies the column labels when you register the mashable. If your spreadsheet has column names in two or more rows, you must choose a single row, allow MashZone NextGen to generate column labels or simplify your worksheet.
Cannot span two or more cells in a spreadsheet.
MashZone NextGen treats the second and subsequent columns as missing labels. You can allow
MashZone NextGen to generate column names for the second and subsequent columns or you can update your worksheet.
Row labels are not supported. These should be treated as a column of data and have a column label.
Hidden columns are included when you register a mashable in
MashZone NextGen.
Charts, images or other objects in spreadsheets are ignored and not saved in mashable data.
