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 let' continue from previous example suppose we want to transcode "your_file csvto "your_file xlsbut increase each element by what we can do is to define row renderer function as the followingdef increment_by_one(row)for element in rowyield element then pass it onto save_as function using row_rendererpe isave_as(file_name="your_file csv"row_renderer=increment_by_onedest_file_name="your_file xlsx"noteif the data content is from generatorisave_as has to be used we can verify if it was done correctlype get_sheet(file_name="your_file xlsx"your_file csv+---+----+---- +---+----+---- +---+----+---- +---+----+---- +---+----+---- +---+----+---- +---+----+----not all parameters are needed here is table support the project