Posts made by hernglx

I'm still getting a 413 + CORS error... This is my code:

var jsReportPDF = await this.$axios.post('https://playground.jsreport.net/...', {
          template: { shortid: '{{shortid}}' },
          data: excel,
          options: { "reportName": "myfilename.xlsx",'Content-Disposition': 'attachment;filename=report.xlsx', "reports": { "async": true, "blobName": "myfilename" } }
        }, {
          responseType: 'arraybuffer',
          maxContentLength: Infinity,
          maxBodyLength: Infinity,
          express: {
            "inputRequestLimit": "300mb"
           }
          }
        );

Does it run smoothly on your side?

I'm not sure where to add the two lines of code you mentioned.

Is this for remote jsreport server? Is there a way to do this if I want to use JSreport Online?

Hi, I want to pass a set of data containing 33 rows of records to the JSReport API to generate an xlsx file. Each row contains 17 columns and an image.

The error below is thrown when I try to pass 14 records. Everything works fine with 13 records.[Error from Chrome Inspect tool]( image url)
[Error from console]( image url)
Code:

var jsReportPDF = await this.$axios.post('https://playground.jsreport.net/w/.......', {
          template: { shortid: '{{shortid}}' },
          data: excel,
          options: { "reportName": "myfilename.xlsx",'Content-Disposition': 'attachment;filename=report.xlsx', "reports": { "async": true, "blobName": "myfilename" } }
        }, {
          responseType: 'arraybuffer',
          express: {
            "inputRequestLimit": "300mb"
           }
         }
        );

My initial guess is that the request limit has to be increased but it did not work.
for 13 records, the content length is 8860574 (which is approx. 9Mb?).

Playground: https://playground.jsreport.net/w/hernglx/fkqo1UQc
The same data format can be found here, only that the number of data amounts to 33 on my side.
How do I solve this?

Thanks for the reply! I am able to control the height of each row successfully now.

As for the data, it just wouldn't loop properly in the template. I think its probably because the data wasn't in object format. I was able to get it to work like this:

//API data = excel
//change array to object
    var rv = {};
    for (var i = 0; i < excel.length; ++i)
     { rv[i] = excel[i];}

    excel = {rv};

Once again, thanks a lot for your help !

https://playground.jsreport.net/w/hernglx/fkqo1UQc
this is the demo. An example of data that I want to pass to the API request can be seen in the sample data.
If possible, I would like to know how to control the height of the cells as well.

I tried assigning the data array into a variable like this:

var excelData = {"print":data} ;

but I get a network error. The response from the API fails to load as well

Oh! okay, i think i understand now, Thanks!
But what if I want to pass data such as below? (I have a set of data in this format returned by another API call)
[{"name":"James","age":12},
{"name":"Chloe", "age": 5}]

Hi, I want to access data that is passed to the POST request in a loop within an xlsx recipe. There wasn't any issue passing the data outside the loop, only within a loop. Below is a sample of what I'm working on:

{{#each data}}
{{#xlsxAdd "xl/worksheets/sheet1.xml" "worksheet.sheetData[0].row"}}
<row>
    <c t="inlineStr"><is><t>{{ #}}</t></is></c>
    <c t="inlineStr"><is><t>{{ name}}</t></is></c>
</row>
{{/xlsxAdd}}
{{/each}}

The data passed into the request body is as such:

{
    "docs":[
        {
            "#":"2",
            "Name":"James"
        },
        {
            "#":"23",
            "Name":"Chloe"
        }
    ]
}

Thanks