Wiki source code of Excel to CSV > 2007
Last modified by Erik Bakker on 2023/01/31 10:20
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
2.1 | 1 | {{container}} |
| 2 | {{container layoutStyle="columns"}} | ||
| |
4.1 | 3 | ((( |
| |
7.1 | 4 | == About == |
| |
19.1 | 5 | With the help of this store item, you can transform 'new' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file. |
| |
4.1 | 6 | |
| |
7.1 | 7 | == Documentation == |
| |
4.1 | 8 | |
| |
7.1 | 9 | ==== 1. How to use==== |
| |
19.1 | 10 | With the help of this store item, you can transform 'new' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file. |
| |
2.1 | 11 | |
| |
7.1 | 12 | ==== 2. Keynotes & restrictions==== |
| |
2.1 | 13 | |
| |
19.1 | 14 | * Note that any Excel file with the extension .xsls is considered a 'new' Excel file. |
| |
18.1 | 15 | * Note that these are custom Groovy scripts that work on the current infrastructure of eMagiz. |
| |
15.1 | 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. |
| |
18.1 | 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. | ||
| |
22.1 | 20 | * Please check out the following link to learn a bit more about [[Groovy>>https://www.tutorialspoint.com/groovy/index.htm||target="blank"]]. |
| 21 | |||
| |
7.1 | 22 | ==== 3. License Information==== |
| |
15.1 | 23 | Part of the standard license agreement as agreed upon when using the store for the first time. |
| |
2.1 | 24 | |
| |
10.1 | 25 | ==== 4. Relevant eMagiz Academy Microlearnings==== |
| 26 | |||
| |
22.1 | 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"]] | ||
| |
10.1 | 29 | |
| |
22.1 | 30 | //Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]]))) |
| |
11.1 | 31 | ((())) |
| |
2.1 | 32 | {{/container}} |
| 33 | {{/container}} |