+- Form Tools (https://forums.formtools.org)
+-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8)
+--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16)
+--- Thread: Excel Export Manager (/showthread.php?tid=21020)
Excel Export Manager - kampers - Feb 6th, 2017
Hey I'm new here
I'm from Germany sorry for my bad englich.
Ok now my question.
It's possible to use a <br> in the {foreach} Loop
to create more lines in the Excel sheet ?
<table>
<tr>
{foreach from=$display_fields item=column}
<th>{$column.field_title}</th>
{/foreach}
</tr>
{foreach from=$submissions item=submission}
{assign var=submission_id value=$submission.submission_id}
<tr>
{foreach from=$display_fields item=field_info}
{assign var=col_name value=$field_info.col_name}
{assign var=value value=$submission.$col_name}
<td>
{smart_display_field form_id=$form_id view_id=$view_id
submission_id=$submission_id field_info=$field_info
field_types=$field_types settings=$settings value=$value
escape="excel"}
</td>
{/foreach}
</tr>
{/foreach}
</table>
RE: Excel Export Manager - nelsondcosta - Aug 25th, 2017
Never tested, but i think you can.