Valid Spreadsheet Mashables
Workbooks or cell ranges should be limited to the following to create valid Presto mashables:
Formulas in spreadsheets are valid, but the formula itself is not exported to the mashable in
Presto. 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, Presto 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,
Presto 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 Presto to generate column labels or simplify your worksheet.
Cannot span two or more cells in a spreadsheet.
Presto treats the second and subsequent columns as missing labels. You can allow
Presto 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
Presto.
Charts, images or other objects in spreadsheets are ignored and not saved in mashable data.
