hyoioioo - 経済統計練習帳

import requests
 
code="1uzhQYfrOMsY0C-svvEGDZpF8tHVpo0be9NIpY1p_p-E"
 
web="https://spreadsheets.google.com/feeds/worksheets/"+code+"/public/basic"
r = requests.get(web)
m=r.text
 
x=m.split("</entry>")
 
str=x[0]
 
p1=str.index("<entry>")
str=str[p1:]
 
p1=str.index("<id>")
p2=str.index("</id>")
str=str[p1:p2]
p1=str.index("/basic/")
z=str[p1:]
ws=z.replace("/basic/","")
 
web="https://spreadsheets.google.com/feeds/cells/"+code+"/"+ws+"/public/values"
 
r = requests.get(web)
m=r.text
 
de=m.split("</gs:cell")
 
for i in range(len(de)):
    q1=de[i].find("<gs:cell")
    de[i]=de[i][q1:]
 
y=[]
x=[]
v=[]
 
for i in range(len(de)-1):
    r1=de[i].find("row=")
    r2=de[i].find("'",r1+5)
    r=de[i][r1+5:r2]
    c1=de[i].find("col=")
    c2=de[i].find("'",c1+5)
    c=de[i][c1+5:c2]
    v1=de[i].find(">")
    vv=de[i][v1+1:]
    y.append(int(r))
    x.append(int(c))
    v.append(vv)
 
lastrow=1
for i in range(len(y)):
    if y[i] > lastrow:
       lastrow=y[i]
 
lastcol=1
for i in range(len(x)):
    if x[i] > lastcol:
       lastcol=x[i]
 
print(lastrow)
print(lastcol)
 
for u in v:
    print(u)