python操作xlsx文档

import openpyxl


# openpyxl在py2.x上有编码问题，最后是用python3来写
#load_workbook()加载.xlsx文件，返回一个workbook对象

#workbook.get_active_sheet()#返回当前的表,worksheet对象
#worksheet.rows属性返回所有的行的迭代器对象

![这里写图片描述](https://img-blog.youkuaiyun.com/20170609230444578?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvQ29zbW9wb2xpdGFuTWU=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
def     main():

        book = openpyxl.load_workbook('example.xlsx')

        sheet = book.get_active_sheet()

        for line in sheet.rows:#迭代完所有的行
                for item in line:
                        print(item.value,end=" ")

                print("\n")

![这里写图片描述](https://img-blog.youkuaiyun.com/20170609230634021?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvQ29zbW9wb2xpdGFuTWU=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
if      __name__=="__main__":
        main()