Ler arquivos do Excel

[guilherme.sistemas]

Tenho uma planilha em Excel com mais de 5mil linhas e precisava ler ela de 1000 em 1000 existe a possibilidade de criar um loop para fazer isso?

[ppr (Peter Preuss)]

@guilherme.sistemas
Welcome to the forum

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …