(continued from previous page+===+===+===+=== +---+---+---+---what if the headers are in different row suppose you have the following datasheet pyexcel sheet+++ +++column column column +++ +++the way to name your columns is to use index sheet name_columns_by_row( here is what you getsheet pyexcel sheet+++column column column +==========+==========+========== +++ +++row manipulation suppose you have the following datasheet pyexcel sheet+---+---+---+ row +---+---+---+ row +---+---+---+ row +---+---+---+you can name your rows by column index at sheet name_rows_by_column( sheet pyexcel sheet(continues on next page new tutorial