Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import openpyxl
- wb = openpyxl.load_workbook('example.xlsx') #getting name of specified file
- sheet = wb['Sheet1']
- print(sheet)
- print(sheet.title)
- print(sheet['A1'].value)
- print(sheet['b1'].value)
- c = sheet['b1']
- print('Row' + str(c.row) + ', Column' + c.column + ' is ' + c.value)
- print('Row' + str(c.row) + ', Column' + c.column + ' is ' + c.value)
- TypeError: can only concatenate str (not "int") to str
- A B C
- 1 2015-04-05 13:34 jabłka 73
- 2 2015-04-05 13:34 wiśnie 85
- 3 2015-04-06 12:46 gruszki 14
- 4 2015-04-08 08:59 pomarańcze 52
- 5 2015-04-10 02:07 jabłka 152
- 6 2015-04-10 18:10 banany 23
- 7 2015-04-10 02:40 truskawki 98
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement