How to remove spaces at the beginning and end of an XLS output

To remove the blanks before and after the text, you can use .strip() .

To print the special characters, you can by .encode('utf-8') .

To put everything in lower case , put a .lower() at the end of the whole sentence.

To change the various spaces in the middle of the string by a single _ , you can make a .split() to separate all words within the string and then merge them with "_".join() .

Putting the four together would look like this:

print "_".join(celula.encode('utf-8').strip().lower().split())

Since celula is an iteration of each element of linha .

Furthermore, you have a logic error in this section:

yield plan.row_values(0)

Where instead of 0 should be i .

Putting it all back in your code would look like this:

import xlrd


def xlread(arq_xls):

    xls = xlrd.open_workbook(arq_xls)
    # Pega a primeira planilha do arquivo
    plan = xls.sheets()[0]

    # Para i de zero ao numero de linhas da planilha
    for i in xrange(plan.nrows):
        # Le os valores nas linhas da planilha
        yield plan.row_values(i)

for linha in xlread("teste.xlsx"):
    for celula in linha:
        print "_".join(celula.encode('utf-8').strip().lower().split())

I believe that spaces can be easily removed as follows:

for linha in xlread("teste.xls"):
    for item in linha:
        print item.strip()

As for the special characters I think you should leave this way, when they are read from the list they should return to their original format.