jsreport forum

ahmettbugra

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

ahmettbugra

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

ahmettbugra

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

ahmettbugra

I have changed but it is not working.
0_1644838542340_Screenshot at Feb 14 14-30-25.png

0_1644838553356_Screenshot at Feb 14 14-30-38.png

0_1644838576453_Screenshot at Feb 14 14-31-58.png

ahmettbugra

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

ahmettbugra

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

ahmettbugra

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

ahmettbugra

v2.11.0

ahmettbugra

I have changed jsreport config but still I get an timeout error 3000ms. What should I do ?
1_1644826742956_Screenshot at Feb 14 11-18-51.png
0_1644826742955_MicrosoftTeams-image (2).png

ahmettbugra

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}}}

0_1644825781528_Screenshot at Feb 14 11-02-42.png

ahmettbugra

@ahmettbugra

Posts made by ahmettbugra