(continued from previous pagepe save_as(array=datadest_file_name="your_file csv"and let' pretend to read partial datape get_sheet(file_name="your_file csv"start_row= row_limit= your_file csv+---+----+---- +---+----+---- +---+----+---- +---+----+----and you could as well do the same for columnspe get_sheet(file_name="your_file csv"start_column= column_limit= your_file csv+----+---- +----+---- +----+---- +----+---- +----+---- +----+---- +----+----obviousyou could do both at the same timepe get_sheet(file_name="your_file csv"start_row= row_limit= start_column= column_limit= your_file csv+----+---- +----+---- +----+---- +----+----the pagination support is available across all pyexcel plugins noteno column pagination support for query sets as data source formatting while transcoding big data file if you are transcoding big data setconventional formatting method would not help unless on-demand free ram is available howeverthere is way to minimize the memory footprint of pyexcel while the formatting is performed api documentation