Wiki source code of Excel to CSV < 2007
Last modified by Erik Bakker on 2023/01/31 10:20
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{container}} | ||
| 2 | {{container layoutStyle="columns"}} | ||
| 3 | ((( | ||
| 4 | == About == | ||
| 5 | With the help of this store item, you can transform 'old' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file. | ||
| 6 | |||
| 7 | == Documentation == | ||
| 8 | |||
| 9 | ==== 1. How to use==== | ||
| 10 | With the help of this store item, you can transform 'old' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file. | ||
| 11 | |||
| 12 | ==== 2. Keynotes & restrictions==== | ||
| 13 | |||
| 14 | * Note that any Excel file with the extension .xsl is considered an 'old' Excel file. | ||
| 15 | * Note that these are custom Groovy scripts that work on the current infrastructure of eMagiz. | ||
| 16 | * Any custom additions that are needed for your specific use cases need to be created by you and eMagiz will not create it for you. | ||
| 17 | * The store item uses external libraries that are not supported by the eMagiz platform nor covered by the eMagiz SLA. | ||
| 18 | * Note that the Groovy script only works for Excel files with one workbook and one sheet. | ||
| 19 | * The store item does not specify where you retrieve the Excel file from nor where the CSV file needs to go. It is up to you to determine this. | ||
| 20 | * Please check out the following link to learn a bit more about [[Groovy>>https://www.tutorialspoint.com/groovy/index.htm||target="blank"]]. | ||
| 21 | |||
| 22 | ==== 3. License Information==== | ||
| 23 | Part of the standard license agreement as agreed upon when using the store for the first time. | ||
| 24 | |||
| 25 | ==== 4. Relevant eMagiz Academy Microlearnings==== | ||
| 26 | |||
| 27 | * [[Handle Groovy Script>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Data Handling.expert-data-handling-groovy-script||target="blank"]] | ||
| 28 | * [[Q&A Question>>https://my.emagiz.com/p/question/172825635700361387||target="blank"]] | ||
| 29 | |||
| 30 | //Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]]))) | ||
| 31 | ((())) | ||
| 32 | {{/container}} | ||
| 33 | {{/container}} |