The CsvExcel plugin offers functions to import and convert CSV and Excel files.

===============================

Changes made in version 4.00

programmer D.Deneer
date: 02 jul 2014
TypeDescription

----

-----------------

added Created a new plugIn that covers all functions related to CSV and Excel.
update To be more compatible with the other actions, CSV to XML will now output <table> as root element in stead of <csvToXml>
update CSV to XOG is renamed to "CSV to XML using a template" and this function is moved from the Clarity menu to the Conversion menu.
added Added new import function Excel to XML to import an Excel file in the XML editor.
This function is quite similar to Csv to XML.
added Added new conversion function "Excel to XML using a template".
This function is quite similar to "CSV to XML using a template" (formerly çalled CSV to XOG).

===============================

Changes made in version 3.00

programmer D.Deneer
date: 09 jul 2013
TypeDescription

----

-----------------

update CSV to XML using a template: Transformation with a xslt stylesheet will be done against a xml row element that contains the columns and values of the csv record. Calling the stylesheet with the values as parameters is still supported but not obvious, because now you can select the values by selecting them from the input xml which will have the stucture:
 <table>
      <row>
          <col1>value</col1>
          <col2>value</col2>
      </row>
 </table>

 So to get the value of col1 you can use : <xsl:value-of select="/table/row/col1">
 
  
add CSV to XML using a template: Grouping of csv records is possible when using a xslt stylesheet. The stylesheet can use a construction like <xsl:for-each select="table/row"> to get the values in each row.
add CSV to XML using a template: Escape values in the csv records are processed conform standards