Posted Jan 01, 1970 12:00 AM
I have a very strange issue that I cannot seem to find an answer to online.
I have a
VB.NET application that creates an
Excel of data (roughly 42,542 rows in total) and the saves the file to a folder location & opens it on screen for the user.
The onscreen version & folder version is only showing 16,372 rows of data like it is being cut off.
When I go through debug I can see all the rows are being added & if I save manually in debug all the rows save. Some data seems to get lost on the system save.
I am taking data from 4 record sets & writing each set one after the other with specific headers for each block on the Excel sheet.
My save line is:
Would anyone please have any ideas as to what this might be?