(continued from previous pagefor file in sorted(outputfiles)print(filesheet _output xls sheet _output xls sheet _output xls for the output fileyou can specify any of the supported formats extract just one sheet from book suppose you just want to extract one sheet from many sheets that exists in work book and you would like to separate it into single sheet excel file you can easily do thisfrom pyexcel cookbook import extract_a_sheet_from_a_book extract_a_sheet_from_a_book("megabook xls""sheet ""output xls"if os path exists("sheet _output xls")print("sheet _output xls exists"sheet _output xls exists for the output fileyou can specify any of the supported formats stream apis for big file set of two liners when you are dealing with big excel filesyou will want pyexcel to use constant memory this section shows you how to get data from your big excel files and how to export data to excel files in two lines at mostwithout eating all your computer memory two liners for get data from big excel files get list of dictionaries suppose you want to process the following coffee datalet' get list of dictionary out from the xls filerecords iget_records(file_name="your_file xls"and let' check what do we havefor in recordsprint( "{ ['serving size']of { ['coffees']has { ['caffeine (mg)']mg"venti( ozof starbucks coffee blonde roast has mg large( oz of dunkindonuts coffee with turbo shot has mg grande( oz of starbucks coffee pike place roast has mg regular( oz of panera coffee light roast has mg please do not forgot the second line to close the opened file handlep free_resources( new tutorial