How to add multiple tables with dynamic rows

How to add multiple tables with dynamic rows

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

• 

  chandana

  • Post Options:
  • Link
    Copy

  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
  4. 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  chandana

  • Post Options:
  • Link
    Copy

  Posted 30 January 2022, 9:06 pm EST

  Hi Prabhat,

  Thanks for sharing this. Shall check and get back on this.

• 

  chandana

  • Post Options:
  • Link
    Copy

  Posted 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!

• 

  chandana

  • Post Options:
  • Link
    Copy

  Posted 31 January 2022, 2:13 am EST - Updated 29 September 2022, 6:47 am EST

  

  1920×1080 201 KB

  

  1920×1080 221 KB

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  chandana

  • Post Options:
  • Link
    Copy

  Posted 1 February 2022, 5:06 pm EST

  gc.zip

  PFA the template and output generated.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.