Posts made by ahmettbugra

Hello Sir ,
I want to change comma separator "114968.00" to "114968,00". We are using "," for separator. How can I change ?

Hello,
When we change version v2.5.0 to v3.2.0, our xlsx template is not coming. We exported all files from v2.5.0 for v3.2.0 as a zip file but zip file doesn't include xlsx template. Could you help me please ?

Thank you for your interest

Hello,

You said that it wasn't possible to remove a sheet from the template with html-to-xlsx recipe. Can we remove or hide sheet in jsreport 3 version.

Thank you for your interest

I have changed but it is not working.

Our template has gridlines. I added template and code url above also I said that I want to add data A17 and A18. (Merge cell). I didin't do it How can I do that ?
Thanks

I have created on playground. I shared with you. I want to add data A17 and A18. (Merge cell). Please run BillReport(Clone).
https://playground.jsreport.net/w/anon/9~DxUjVd

Thank's for your interest , I will change and inform you.

v2.11.0

I have changed jsreport config but still I get an timeout error 3000ms. What should I do ?

Hello ,

I have an problem. If I add a row , gridlines are gone. What is the problem ? I added code below.

{{!-- Sheet 1 --}}


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

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

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

{{#xlsxReplace "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row[2].c[1]"}}
    <c t="inlineStr"><is><t>{{period}}</t></is></c>
{{/xlsxReplace}}

{{xlsxRemove "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 5}}

{{#each data }}
{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 5}}
<row>
    <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t>{{companyName}}</t></is></c>
    <c s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{subscriptionType}}</t></is></c>
    <c s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{contractPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[3].$.s}}"><is><t>{{transformerPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[4].$.s}}"><is><t>{{meterSerialNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[5].$.s}}"><is><t>{{meterMultiplier}}</t></is></c>
    <c s="{{@root.$removedItem.c.[6].$.s}}"><is><t>{{impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[7].$.s}}"><is><t>{{impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[8].$.s}}"><is><t>{{impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[9].$.s}}"><is><t>{{impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[10].$.s}}"><is><t>{{impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[11].$.s}}"><is><t>{{impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[12].$.s}}"><is><t>{{impactiveIndexDemand}}</t></is></c>
    <c s="{{@root.$removedItem.c.[13].$.s}}"><is><t>{{expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[14].$.s}}"><is><t>{{expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[15].$.s}}"><is><t>{{expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[16].$.s}}"><is><t>{{expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[17].$.s}}"><is><t>{{expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[18].$.s}}"><is><t>{{expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[19].$.s}}"><is><t>{{expactiveDemand}}</t></is></c>
    
</row>
{{/xlsxAdd}}
{{/each}}

{{!-- Sheet 2 --}}

{{xlsxRemove "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row" 7}}
{{#each data }}
{{#xlsxAdd "xl/worksheets/sheet2.xml" "worksheet.sheetData[0].row" 7}}
<row>
    <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t>{{companyName}}</t></is></c>
    <c s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{installationNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[2].$.s}}"><is><t>{{subscriptionType}}</t></is></c>
    <c s="{{@root.$removedItem.c.[3].$.s}}"><is><t>{{contractPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[4].$.s}}"><is><t>{{transformerPower}}</t></is></c>
    <c s="{{@root.$removedItem.c.[5].$.s}}"><is><t>{{meterSerialNumber}}</t></is></c>
    <c s="{{@root.$removedItem.c.[6].$.s}}"><is><t>{{meterMultiplier}}</t></is></c>
    <c s="{{@root.$removedItem.c.[7].$.s}}"><is><t>{{firstIndex.impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[8].$.s}}"><is><t>{{firstIndex.impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[9].$.s}}"><is><t>{{firstIndex.impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[10].$.s}}"><is><t>{{firstIndex.impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[11].$.s}}"><is><t>{{firstIndex.impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[12].$.s}}"><is><t>{{firstIndex.impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[13].$.s}}"><is><t>{{firstIndex.expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[14].$.s}}"><is><t>{{firstIndex.expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[15].$.s}}"><is><t>{{firstIndex.expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[16].$.s}}"><is><t>{{firstIndex.expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[17].$.s}}"><is><t>{{firstIndex.expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[18].$.s}}"><is><t>{{firstIndex.expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[19].$.s}}"><is><t>{{lastIndex.impactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[20].$.s}}"><is><t>{{lastIndex.impactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[21].$.s}}"><is><t>{{lastIndex.impactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[22].$.s}}"><is><t>{{lastIndex.impactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[23].$.s}}"><is><t>{{lastIndex.impactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[24].$.s}}"><is><t>{{lastIndex.impactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[25].$.s}}"><is><t>{{lastIndex.expactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[26].$.s}}"><is><t>{{lastIndex.expactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[27].$.s}}"><is><t>{{lastIndex.expactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[28].$.s}}"><is><t>{{lastIndex.expactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[29].$.s}}"><is><t>{{lastIndex.expactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[30].$.s}}"><is><t>{{lastIndex.expactiveCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[31].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[32].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[33].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[34].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[35].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[36].$.s}}"><is><t>{{monthlyTotal.totalImpactiveIndexCapacitive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[37].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT0}}</t></is></c>
    <c s="{{@root.$removedItem.c.[38].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT1}}</t></is></c>
    <c s="{{@root.$removedItem.c.[39].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT2}}</t></is></c>
    <c s="{{@root.$removedItem.c.[40].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexT3}}</t></is></c>
    <c s="{{@root.$removedItem.c.[41].$.s}}"><is><t>{{monthlyTotal.totalExpactiveIndexInductive}}</t></is></c>
    <c s="{{@root.$removedItem.c.[42].$.s}}"><is><t>{{monthlyTotal.totalExpactiveCapacitive}}</t></is></c>

</row>
{{/xlsxAdd}}
{{/each}}

{{!-- Sheet 3 --}}


{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}
{{xlsxRemove "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 13}}

{{#xlsxAdd "xl/worksheets/sheet3.xml" "worksheet.sheetData[0].row" 2}}
<row>
        <c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is>asda<t></t></is></c>
        <c t="inlineStr" s="{{@root.$removedItem.c.[1].$.s}}"><is><t>deneme</t></is></c>
        <c t="inlineStr" s="{{@root.$removedItem.c.[2].$.s}}"><is><t>deneme</t></is></c>

</row>
{{/xlsxAdd}}
{{{xlsxPrint}}}

Hello,
How can I insert data into specific column using xlsx. I have attached example about it. I cannot insert "daily" data into row 2 column 2. My code is below. "Daily" data is shown always row 13.

{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row" 2}}
<row>
<c t="inlineStr" s="{{@root.$removedItem.c.[0].$.s}}"><is><t></t></is></c>
<c t="inlineStr" s="{{@root.$removedItem.c.[1].$.s}}"><is><t>{{period}}</t></is></c>

</row>
{{/xlsxAdd}}


I mean that , background is white in my example . There is no gridlines. How can I do that ?
Thank you for your interest.

Can we disable background gridlines in excel using html to xlsx ? I attched one example.
Thank you for your interest.

We are colleages in Inavitas company. We cannot add screen shot this issue. how can we share to you ?