book pyexcel get_book(file_name="book xls"book sheet sheet +---+---+--- +---+---+--- +---+---+--- +---+---+---or via array notationsbook["sheet "there is space in the sheet name sheet +---+---+--- +---+---+--- +---+---+--- +---+---+---merge excel books suppose you have two excel books and each had three sheets you can merge them and get new bookyou also can merge individual sheetsbook pyexcel get_book(file_name="book xls"book pyexcel get_book(file_name="book xlsx"merged_book book book merged_book book ["sheet "book ["sheet "merged_book book ["sheet "book merged_book book book ["sheet "manipulate individual sheets merge sheets into single sheet suppose you want to merge many csv files row by row into new sheet import glob merged pyexcel sheet(for file in glob glob("csv")merged row +pyexcel get_sheet(file_name=filemerged save_as("merged csv"how do read bookprocess it and save to new book yesyou can do that the code looks like this new tutorial