column column column update one row of data file suppose you have the same data fileexample xls row row row and you want to update the second row with these data[ here is the codefrom pyexcel cookbook import update_rows custom_row {"row ":[ ]update_rows("example xls"custom_row"output xls"pyexcel get_sheet(file_name="output xls"pyexcel sheet++----+----+----row ++----+----+----row ++----+----+----row ++----+----+----merge two files into one suppose you want to merge the following two data filesexample csv column column column example xls column column the following code will merge the tow into one filesay "output xls" cook book