How to add multiple tables with dynamic rows.

Posted by: chandana on 2 January 2022, 5:06 pm EST

  • Posted 2 January 2022, 5:06 pm EST

    Case when multiple tables of different column size are to be populated without affecting the rows below.

    Example: A sheet has
    1. Table A with 3 columns
    2. Table B with 4 columns
    3. Table C with 7 columns
    4.Table D with 2 columns
    5. Table E with 5 columns

    All of the above tables have variable number of rows for every input.
    How do we populate them, using template and java API?

    Currently, the tables below the populated one are not getting shifted by the number of rows inserted. The rows look jumbled.
  • Replied 3 January 2022, 6:30 pm EST

    Hello,

    We are discussing this with the developers and will let you know as soon as we get the. update from the developers' end.
    [Internal Tracking Id: DOCXLS-5340]

    Regards,
    Prabhat Sharma.
  • Replied 6 January 2022, 5:01 pm EST

    Hello,

    We do not face the issue at our end. Please find the attached sample where the rows are shifted and the table is not overlapped.

    If you are doing anything else then, please let us know and modify the sample accordingly.

    Regards,
    Prabhat Sharma.
    TemplateDemo.zip
  • Replied 30 January 2022, 9:06 pm EST

    Hi Prabhat,

    Thanks for sharing this. Shall check and get back on this.
  • Replied 31 January 2022, 2:10 am EST

    Please see attached excel docs - template and output received.

    You can see distorted rows from row 25 in the output. Implementation is as per the sample you provided.

    Please point out the error in my case or a work around to get the rows correctly.
    Thank you!

  • Replied 31 January 2022, 2:13 am EST

  • Replied 31 January 2022, 7:14 pm EST

    Hello,

    It is very strange.
    It will not be enough to investigate this issue with the image attachments only.
    Can you please share a stripped-down sample with your template excel file so that we can further investigate this issue?
    You can also update our attached project accordingly to replicate the issue.

    Regards,
    Prabhat Sharma.
  • Replied 1 February 2022, 5:06 pm EST

    gc.zip

    PFA the template and output generated.
  • Replied 2 February 2022, 10:06 pm EST

    Hello Chandana,

    Can you please share the code too that you are using to populate the data in the template so that we can investigate it further?

    Regards,
    Prabhat Sharma.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels