Posts made by Ahmed Chraibi

Thank you :)

Thank you, it works !!
But for return to the line have you any idea ?

Hello,

Can we format cell with JSreport ?
For example center the cell content and return to the line in the same cell (first name and last name) ?

Thanks in advance for your help

Perfect !
Thanks to both of you !

Hello,

My question is about exploring JSON data.
Exemple of data:
{
"Depot":[
{
"COL_CODEACTIVITE":"01470",
"ID":5,
"RH":[
{
"COL_CODEACTIVITE":"01470",
"COL_NOM":"AAAA",
"COL_PRENOM":"BBBB",
"TACHE":[{
"TACH_LIBELLETYPE":"Prise de service Matin",
"TACH_DATE_DEBUT":"2018-03-14T08:00:00",
"TACH_DATE_FIN":"2018-03-14T08:00:00"
},
{
"TACH_LIBELLETYPE":"Prise de service Après-midi",
"TACH_DATE_DEBUT":"2018-03-14T14:00:00",
"TACH_DATE_FIN":"2018-03-14T08:00:00"
}]
},
{
"COL_CODEACTIVITE":"01470",
"COL_NOM":"RRRRR",
"COL_PRENOM":"YYYYY",
"TACHE":[{
"TACH_LIBELLETYPE":"Prise de service Matin",
"TACH_DATE_DEBUT":"2018-03-14T08:00:00",
"TACH_DATE_FIN":"2018-03-14T08:00:00"
}]
}
]
}
]
}

when I'm in {{#each RH}} how can i access ID of depot ?
("Depot" is the parent object of "RH")

Thanks in advance :)

Nice !!
Thank you for your help, it takes me two days of work.
I have another questions but i'll do that in another topic.
Thanks again :)

Thanks for your reply,
Yes I mean add sheets on a loop.
Hope that you have a solution :).

Hello,

Can we add multiple sheet on loop ?
Example :

{{#each Depot}}

{{#xlsxAdd "xl/workbook.xml" "workbook.sheets[0].sheet"}}
<sheet name="{{COL_CODEACTIVITE}}" sheetId="{{#rid COL_CODEACTIVITE}}{{/rid}}" r:id="{{#vid COL_CODEACTIVITE}}{{/vid}}"/>
{{/xlsxAdd}}

{{#xlsxAdd "xl/_rels/workbook.xml.rels" "Relationships.Relationship"}}
<Relationship Id="{{#vid COL_CODEACTIVITE}}{{/vid}}" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/>
{{/xlsxAdd}}

{{/each}}

{{{xlsxPrint}}}

This example doesn't work.
Thanks in advance for your help !