Changes between Version 8 and Version 9 of BluePrint/Importer/Excel

Timestamp:

09/19/13 10:57:13 (11 years ago)

Author:

Dominic König

Comment:

--

BluePrint/Importer/Excel

@@ -25 +25 @@
 === xls2tree ===
 
-Xls2tree is the back-end method to parse Excel sheets.
+{{{S3XML.xls2tree()}}} is the back-end method to parse Excel sheets.
 
-Note: unlike originally planned, this is not a pre-processor to convert XLS into CSV and then pass into the CSV importer, but just like csv2tree (the CSV parser) it converts the Excel sheet into an ElementTree for import. However, this ElementTree is transformed with the same XSLT stylesheets as the CSV format.
+  '''Note:''' unlike originally planned, this is ''not'' a pre-processor to convert XLS into CSV and then pass into the CSV importer, but just like {{{csv2tree}}} (the CSV parser) it converts the Excel sheet into an !ElementTree for import. However, this !ElementTree is then transformed with the same XSLT stylesheets as the CSV format.
 
-The xls2tree method is much more flexible than the current importer front-end suggests - it can read any sheet in the workbook and a range of rows/columns anywhere on the sheet (i.e. not only top left). It also accepts a column mapping as parameter which allows to specify which column corresponds to which field instead of reading the column headers from the sheet.
+The {{{xls2tree}}} method is much more flexible than the current importer front-end suggests - it can read any sheet in the workbook and a range of rows/columns anywhere on the sheet (i.e. not only top left). It also accepts a column mapping as parameter which allows to specify which column corresponds to which field instead of reading the column headers from the sheet.
 
 This flexibility could be utilized to implement a front-end that allows the user to import from any XLS document even if there is no "SahanaData" sheet in CSV format. These "XLS format configurations" (sheet name, cell range, column mapping) could be saved ("Saved XLS Formats"), and then re-used for other documents - which allows to quickly adapt to various document sources.