I am dividing as A0:K5000 A5000:K10000 in the loop, I want to output this partial excel dataset.
But can’t I continue from where I left off in the same dataset and exit Excel with all parts one under the other?
hi, eg by splitting an excel 5000/5000 that cannot be output to the dataset at once because it exceeds the 64000 limit.
Hello,
Maybe you can do that when you get data from excel to dataset, gathered data can be removed from excel.
Getting size of dataset and removed from excel by row size. You can follow this step every getting data from excel.