Skip to Content

Changes for page Excel to CSV > 2007

Last modified by Erik Bakker on 2023/01/31 10:20
From version 11.1
edited by Erik Bakker
on 2022/05/02 09:39
Change comment: There is no comment for this version
To version 18.1
edited by Erik Bakker
on 2022/05/02 10:14
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -If then else - SpEL
1 +Excel to CSV < 2007
Content
... ... @@ -2,26 +2,31 @@
2 2  {{container layoutStyle="columns"}}
3 3  (((
4 4  == About ==
5 -With the help of this store item, you can easily execute an if then else statement with the help of a SpEL expression to filter out messages.
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 6  
7 7  == Documentation ==
8 8  
9 9  ==== 1. How to use====
10 -With the help of this store item, you can easily execute an if then else statement with the help of a SpEL expression to filter out messages.
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 11  
12 12  ==== 2. Keynotes & restrictions====
13 13  
14 -* Note that this is an example of how you can use the SpEL expression within eMagiz.
15 -* The crucial part of this SpEL expression is the comparison between the input value (mainly a header) and a property list.
16 -
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
21 +
17 17  ==== 3. License Information====
18 -To use this store item you need to secure an additional license on the eMagiz platform. If you are interested in such a license please contact us at productmanagement@emagiz.com.
23 +Part of the standard license agreement as agreed upon when using the store for the first time.
19 19  
20 20  ==== 4. Relevant eMagiz Academy Microlearnings====
21 21  
22 -[[https:~~/~~/emagiz.github.io/docs/microlearning/advanced-data-handling-spel-expressions>>url:https://emagiz.github.io/docs/microlearning/advanced-data-handling-spel-expressions]]
27 +[[https:~~/~~/my.emagiz.com/p/question/172825635700361387>>url:https://my.emagiz.com/p/question/172825635700361387]]
23 23  
24 -Would you please consult the privacy policy of eMagiz at the following link: [[https:~~/~~/www.emagiz.com/privacy-policy/?>>url:https://www.emagiz.com/privacy-policy/?]])))
29 +//Would you please consult the privacy policy of eMagiz at the following link:// [[https:~~/~~/www.emagiz.com/privacy-policy/?>>url:https://www.emagiz.com/privacy-policy/?]])))
25 25  
26 26  
27 27