PY
py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
from openpyxl import load_workbook
#https://docs.google.com/spreadsheets/d/1UrIn1e0zUUgdRrhx8L54_l27FUCKnEqp/edit?usp=drivesdk&ouid=117694618489943964006&rtpof=true&sd=true
workbook=load_workbook("/storage/emulated/0/Download/Studybot Template Spreadsheet - Make a Copy!.xlsx")
sheet=workbook.active
x=[1,2,3,4,5,6,7,8,9,10]
def add(data,col_range):
for col in sheet[col_range]:
for item,cell in zip(data,col):
print(f"{item}) {cell}")
print("item executed....")
add(x,'A2:A11')
'''
Output :
1) <Cell 'Template'.A2>
item executed....
1) <Cell 'Template'.A3>
item executed....
1) <Cell 'Template'.A4>
Enter to Rename, Shift+Enter to Preview
OUTPUT
Run