# -*- coding:utf-8 -*-
import openpyxl
__author__ = 'yangxin_ryan'
"""
读取Excel报表中指定的单元格数据
其中在Windows与Mac系统下,支持读取带有公式的数值
--- 具体参数:
data_only=True 指定只读取数据
data_only=False 指定只读取公式
"""
class ExcelRead(object):
def run(self):
wb = openpyxl.load_workbook(u"/Users/imac/Desktop/xxx.xlsx", data_only=True)
sheet = wb.worksheets[0]
print(sheet["B13"].value)
print(sheet.cell(13, 2).value)
print(sheet.cell(cell=13, column=2).value)
if __name__ == '__main__':
excel_read = ExcelRead()
excel_read.run()