(continued from previous page +---+---+--- +---+---+---sheetformatting previous section has assumed the data is in the format that you want in realityyou have to manipulate the data types bit to suit your needs henceformatters comes into the scene use format(to apply formatter immediately noteintfloat and datetime values are automatically detected in csv files since pyexcel version convert column of numbers to strings suppose you have the following dataimport pyexcel data ["userid","name"][ ,"adam"][ ,"bella"][ ,"cedar"sheet pyexcel sheet(datasheet name_columns_by_row( sheet column["userid"[ as you can seeuserid column is of int type nextlet' convert the column to string formatsheet column format("userid"strsheet column["userid"[' '' '' 'cleanse the cells in spread sheet sometimesthe data in spreadsheet may have unwanted strings in all or some cells let' take an example suppose we have spread sheet that contains all strings but it as random spaces before and after the text values some field had weird characterssuch as "&nbsp;&nbsp;"data [version"comments"author &nbsp;"][ "release versions",&nbsp;eda"]["&nbspv ""useful updates &nbsp&nbsp;"&nbsp;freud"sheet pyexcel sheet(datasheet content +++version comments author &nbsp+++(continues on next page support the project