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


Ignore:
Timestamp:
09/19/13 10:57:13 (8 years ago)
Author:
Dominic König
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/Importer/Excel

    v8 v9  
    2525=== xls2tree ===
    2626
    27 Xls2tree is the back-end method to parse Excel sheets.
     27{{{S3XML.xls2tree()}}} is the back-end method to parse Excel sheets.
    2828
    29 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.
     29  '''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.
    3030
    31 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.
     31The {{{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.
    3232
    3333This 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.