looking at the following architectural diagrampyexcel hosts plugin interfaces for data sourcedata renderer and data parser pyexcel-pygalpyexcel-matplotliband pyexcel-handsontable extend pyexcel using data renderer interface pyexcel-io package takes away the responsibilities to interface with excel librariesfor examplexlrdopenpyxlezodf as in list of file formats supported by external pluginsthere are overlapping capabilities in reading and writing xlsxods files because each third parties express different personalities although they may read and write data in the same file formatyou as the pyexcel is left to pick which suit your task best dotted arrow means the package or module is loaded later new tutorial one liners this section shows you how to get data from your excel files and how to export data to excel files in one line read from the excel files get list of dictionaries suppose you want to process history of classical musiclet' get list of dictionary out from the xls filerecords get_records(file_name="your_file xls"and let' check what do we havefor row in recordsprint( "{row['representative composers']are from {row['name']period ({row'-'period']})"machautlandini are from medieval period ( - gibbonsfrescobaldi are from renaissance period ( - js bachvivaldi are from baroque period ( - joseph haydnwolfgan amadeus mozart are from classical period ( - chopinmendelssohnschumannliszt are from early romantic period ( - wagner,verdi are from late romantic period ( - sergei rachmaninoff,calude debussy are from modernist period ( th centuryget two dimensional array insteadwhat if you have to use pyexcel get_array to do the samefor row in get_array(file_name="your_file xls"start_row= )print( "{row[ ]are from {row[ ]period ({row[ ]})"machautlandini are from medieval period ( - gibbonsfrescobaldi are from renaissance period ( - js bachvivaldi are from baroque period ( - joseph haydnwolfgan amadeus mozart are from classical period ( - chopinmendelssohnschumannliszt are from early romantic period ( - (continues on next page new tutorial