xlsx template row height

[MuratAkbaba006]

hello everyone, I try to create a report from xlsx report template. my question about the rows height. my template second row have height approximately 87px but I can't see this height in in my report. how to handle it? I attached photos and playground link

https://playground.jsreport.net/w/anon/Lp36V3DA

[jan_blaha]

You can use xlsxMerge to update just value but keep style
https://playground.jsreport.net/w/anon/X9BVkpPg

{{#xlsxMerge "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[1].c[0]"}}  
    <c t="inlineStr"><is><t>{{unitName}}</t></is></c>
{{/xlsxMerge}}

Or apply the style s you find in the unzipped Book1.xlsx or by getting it from the template in helper
https://playground.jsreport.net/w/anon/GstjVDad

{{#xlsxReplace "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row[1].c[0]"}}  
    <c t="inlineStr" s="{{style}}"><is><t>{{unitName}}</t></is></c>
{{/xlsxReplace}}

function style() {
    return this.$xlsxTemplate['xl/worksheets/sheet1.xml'].worksheet.sheetData[0].row[1].c[0].$.s
}

[MuratAkbaba006]

this helped a lot, thank you.

[MuratAkbaba006]

hello again, I try to use #xlsxMerge but not working :( . where did i go wrong?. I attached playground link. https://playground.jsreport.net/w/anon/57troEZy

[jan_blaha]

There is just one row in the template.

[MuratAkbaba006]

yes there is just one row in the template. how can I add one row with styles?