Recently in excel file, using streamingreader read large data quantity sheet cycle for each row in the result of the count, found that cycle of count data and documents, the number of rows in several less what was going on, what a big encountered this problem, has a relationship with an empty cell what

CodePudding user response:

Is there a merged cell

CodePudding user response:

Most likely the data format problem, can be a small amount of test data

CodePudding user response:

The

reference new village, 1/f, 0617 response:

have merged cell.

And if so, it will be the whole row skip

CodePudding user response:

refer to the second floor qkniit response:

most likely data format, can be a small amount of data to test the

Thank you, later found that there are multiple lines in file is empty