In [2]:

    

import os
import numpy as np
import openpyxl as op


    

In [4]:

    

path = "/Users/clinpsywoo/github/Stats_2017Fall/data"
os.chdir(path)


    

In [14]:

    

wb = op.load_workbook('health_data.xlsx')


    

In [15]:

    

print(wb)


    

    




<openpyxl.workbook.workbook.Workbook object at 0x115fd5fd0>

In [16]:

    

wb.get_sheet_names()

#sheet.cell(row=1, column=2).value


    

    
Out[16]:





[u'sheet1']

In [17]:

    

sheet = wb.get_sheet_by_name('sheet1')


    

In [28]:

    

sheet.cell(row=3,column=2).value


    

    
Out[28]:





81L

In [ ]: