Changes between Version 9 and Version 10 of BluePrint/Importer/Excel
- Timestamp:
- 09/19/13 11:07:24 (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
BluePrint/Importer/Excel
v9 v10 17 17 Besides .csv files, the interactive importer now also accepts .xls/.xlsx (Excel) files. 18 18 19 If such a file is uploaded, the importer will search for a sheet with the name " SahanaData" (or fall back to the first sheet, of "SahanaData" is not present), and import it under the same formatting rules as the corresponding CSV format.19 If such a file is uploaded, the importer will search for a sheet with the name "!SahanaData" (or fall back to the first sheet, of "!SahanaData" is not present), and import it under the same formatting rules as the corresponding CSV format. 20 20 21 21 The sheet is read from the top left, and the first row interpreted as column names. Else, the sheet is parsed, transformed and imported just like the corresponding CSV format. 22 22 23 The XLS workbook can contain other, more user-friendly sheets with online help, tooltips andor/ validation, and have the " SahanaData" sheet hidden and populated by macros.23 The XLS workbook can contain other, more user-friendly sheets with online help, tooltips andor/ validation, and have the "!SahanaData" sheet hidden and populated by macros. 24 24 25 25 === xls2tree ===