Incorporing data to Excel with perl/html

[Roxxien]

Hello everyone,

I'm currently using a cloud ERP with an option to create correspondance with Template Toolkit. This software uses perl to extract information from the database and some "kind" of html for the format.

My problem is the following : I need to have my information writed on multiple line in 1 Excel cell. However, it can't changes line at any place but at specific place (when encounter this character •). My initial logic is then to replace that character by a jump line.

For the moment, I'm able to replace the character any other that I want even chr(10) which normally create what I want. But, for now, Excel consider it like a space. If someone have any idea on how to solve this, it will really help me.

Here is my code that I currently have.

[% descriptif= line_item.product.description |xml %]
[% descriptif= descriptif.replace([B]'•'[/B], [B]"\n"[/B]) %]
<cell text=[B]"[% line_item.product.description |xml %]"[/B]/>

 

[Roxxien]

I found a solution after 2 days of work on that problem.

Instead of creating some "jump line" with an Ascii character, I'm pasting each string in a different row/cell

Here is the solution if someone want it.

        [% descriptif= line_item.product.description |xml %]
        [% descriptifarray = descriptif.[COLOR=#0000FF]split[/COLOR]([B]'•'[/B]) %]
        [% n = [COLOR=#800000]0[/COLOR] %]
        [% [COLOR=#0000FF]FOREACH[/COLOR] descriptif.[COLOR=#0000FF]split[/COLOR]([B]'•'[/B]) %]
            [% [COLOR=#0000FF]IF[/COLOR] descriptifarray.[COLOR=#800080]$n[/COLOR] != [B]""[/B] %]
                <row>
                    <cell></cell>
                    <cell text=[B]"[% descriptifarray.$n %]"[/B]/>
                </row>
            [% END %]
            [% n = n + [COLOR=#800000]1[/COLOR] %]
        [% END %]