read Chinese character from excel file python3
<p>I have an Excel file that contains two columns, first one in Chinese and the second is just a link.
I tried two methods I found here. but it didn't work and I can't print the value in the console, I changed my encoding variable in settings (pycharm) to U8, still doesn't work.
I used Pandas &amp; xlrd libs, both didn't work while it worked for others who posted.
this is my current code : </p>

<pre><code>from xlrd import open_workbook
class Arm(object):
    def __init__(self, id, dsp_name):
        self.id = id
        self.dsp_name = dsp_name

    def __str__(self):
        return("Arm object:\n"
               "  Arm_id = {0}\n"
               "  DSPName = {1}\n"
               .format(self.id, self.dsp_name))

if __name__ == '__main__':

    wb = open_workbook('test.xls')
    for sheet in wb.sheets():
        print(sheet)
        number_of_rows = sheet.nrows
        number_of_columns = sheet.ncols

        items = []

        rows = []
        for row in range(1, number_of_rows):
            values = []
            for col in range(number_of_columns):
                value = str(sheet.cell(row, col).value)
                for a in value:
                    print('\n'.join([a]))
                values.append(value)

                print(value)
    for item in items:
        print (item)
        print("Accessing one single value (eg. DSPName): {0}".format(item.dsp_name))
        print
</code></pre>

<p>obviously it's not working, I was just messing around with it after giving up.
File : <a href="http://www59.zippyshare.com/v/UxITFjis/file.html" rel="nofollow">http://www59.zippyshare.com/v/UxITFjis/file.html</a></p>

<p>It's not about encoding, you are not access the right rows.</p>

<p>On the line 24<br>
<code>for row in range(1, number_of_rows):</code></p>

<p>why are you want to start with 1 instead of 0.<br>
try<code>for row in range(number_of_rows):</code></p>

python excel