Get Free Trial
Get Free Trial

Sliced rows not separate in to columns in classic type if record data about 1000

posted on December 30th, 2022

Answered
nam asked on December 30, 2022

When export excel file, I used grid type 'classic' but sliced rows not separate if record data about 1000
If I limit data, it separate into column

Attachments:
not_work.zip
work.7z
1.JPG

6 answers

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ December 30, 2022

Hello,

Thank you for providing us with the details.

We could not reproduce the described behavior on our side. Our team has some additional questions:

  1. Do you use the tab on the Toolbar to export the grid? If you use the custom export button, could you please send us the code of your export function?
  2. We would be grateful if you provide us with the report(.json file) you use. 

Looking forward to hearing from you.

Kind regards,
Nadia

Public
nam ⋅ January 4, 2023
  1. I use puppeteer to export excel file, I use exportTo function (code in attach file)
  2. I can't attach data file because it's over 6 million records, if I limit it to 2 million the excel file separate column well 
     

Attachments:
Capture.JPG

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ January 5, 2023

Hello,

Thank you for the response and for providing us with the details.

We suppose that the grid is switching to the compact form due to the long labels of some members. To avoid automatic switching to the compact form, please consider increasing the size of the HTML container for the pivot table component. This way, the rows will be separated in the export.

Please let us know if such an approach would work for your case. Looking forward to hearing from you.

Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ January 17, 2023

Hello,

Hope you are doing well.

We were wondering if you had a chance to test a suggested approach.

Looking forward to hearing your feedback.

Kind regards,
Nadia

Public
nam ⋅ January 19, 2023

hi Nadia, I change the viewport of html container to 1920*1080 as your suggestion, it work well,  thank you so much

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ January 19, 2023

Hi,

Thank you for the feedback.

We are glad to hear that it works for you!

As always, feel free to contact us if other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer