Posts made by shmili

Yes, thanks that answered my question.

Can I span a header cell on multiple columns?

I know it could be done with the html-to-xlsx recipe like this

<th colspan="2">...</th>

but my file is too large to process with that recipe.

Is there a way to achieve the same thing with the xlsx recipe?

Not sure if it is the same issue but I recently had an xlsx corrupt file issue just posting in case anybody else has the same issue

I amusing html to-xlsx recipe with ejs templating, I figured it out that I was missing the <tbody> tag around the table body and adding that fixed it for me

That solved my problem.

Thanks for your quick response.

I am trying to render my report in my react app this is my component

import jsreport from "jsreport-browser-client-dist";

componentDidMount() {
    jsreport.serverUrl = "http://localhost:5488";
    let reportRequest = {
      template: {
        shortid: "rkJTnK2ce",
        recipe: "html"
      },
      data: {
        lines: [
          {
            "Employee Id": 1,
            "First Name": "Eric",
            "Last Name": "Lastname",
            "Record Category": "Earning",
            "Record Amount": "$100.00",
            "Record Hours": "10"
          },
         {
            "Employee Id": 2,
            "First Name": "Jack",
            "Last Name": "Lastname",
            "Record Category": "Earning",
            "Record Amount": "$100.00",
            "Record Hours": "12"
          }
        ]
      }
    };
    jsreport.render(this.reportPreview, reportRequest);
}  

--

render() {
    return (
        <div
            style={{ height: "700px" }}
            ref={el => (this.reportPreview = el)}
       ></div>
   )
}

This works well the data gets displayed in the page, however if I change recipe: "html" to recipe: "html-to-xlsx" it doesn't display the report in the page but it downloads it, is there a way to display the xlsx report in the page?