====== CreateSoftlinkVariablesFromXLSX ======

==== Description ====

This [[:en:software:tim:actionhandler|Handler]] generates new variables from an XLSX file, which, in combination with the [[:en:software:tim:actionhandler:startsoftlinksfromprocessvariableshandler|StartSoftlinksFromProcessVariablesHandler]] Actionhandler in the sequence [[:software:tim:softlinks|Softlinks]], could start.

----

==== Class ====

<code>
com.dooris.bpm.actionhandler.CreateSoftlinkVariablesFromXLSX
</code>

----

==== Event Type ====

Any

==== Action Name ====

Any

==== Mandatory Fields ====

empty

----

==== Parameter ====

== docName ==

Specifies from which XLSX file variables are to be generated.

>> This parameter could also be specified as a process variable. (see [[#example|Example]])

== softLinkSuffix ==

Here a suffix can be specified.

>> That can be empty. (see [[#example|Example]])

== softLinkCount ==

In this parameter a process variable is given, which saves the number of lines in Excel. This can then be used in [[:en:extended_domrepeater|DomRpeater]].

----


==== Example ====

{{  :software:tim:actionhandler:createsoftlinkvariablesfromxlsx.png?1324x610  |/lib/exe/fetch.php?media=software:tim:actionhandler:createsoftlinkvariablesfromxlsx.png}}

{{  :software:tim:actionhandler:createsoftlinkvariablesfromxlsxexamplexlsx.png?nolink&  |/lib/exe/fetch.php?media=software:tim:actionhandler:createsoftlinkvariablesfromxlsxexamplexlsx.png}}

=== Example 1 ===

Parameter in the Actionhandler:
softLinkSuffix=_softLink;

Variables in the process after running the Actionhandler:\\
user_email_softLink[0]=Hans.Mueller@tim.com\\
user_email_softLink[1]=Marta.Meier@tim.com\\
user_email_softLink[2]=Max.Muster@tim.com\\
user_name_softLink[0]=Hans\\
user_name_softLink[1]=Marta\\
user_name_softLink[2]=Max\\
user_nachname_softLink[0]=Mueller\\
user_nachname_softLink[1]=Meier\\
user_nachname_softLink[2]=Muster\\
\\
softLinkCount=3;

=== Example 2 ===

Parameter in the Actionhandler:\\
softLinkSuffix=;

Variables in the process after running the Actionhandler:\\
user_email[0]=Hans.Mueller@tim.com\\
user_email[1]=Marta.Meier@tim.com\\
user_email[2]=Max.Muster@tim.com\\
user_name[0]=Hans\\
user_name[1]=Marta\\
user_name[2]=Max\\
user_nachname[0]=Mueller\\
user_nachname[1]=Meier\\
user_nachname[2]=Muster

\\
softLinkCount=3;

----

====   ====