Missed rows when large dataset #2617
Unanswered
majid-rafei
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Hello,
I have a dataset of about 32k rows that I get from MongoDB and commit to the worksheet.
I can see that the exact number of rows is committed to the worksheet, but the resultant Excel file has fewer rows (about 2k).
I checked all the rows (buffers) and they did not exceed 65536 Bytes.
Sometimes I have a little more rows and sometimes a little less, but always around 30k.
The general script is as follows:
Thanks for your help.
An update on this
I am using a Windows machine and I have missed rows in the resultant Excel file, but I tested the script on a Linux machine and got all the rows I committed!
Beta Was this translation helpful? Give feedback.
All reactions