ひょうけい - 経済統計練習帳

import os
import shutil
import requests
import numpy as np 
 
r = requests.get('https://spreadsheets.google.com/feeds/cells/1sfntkvedmvx2a-bWl2WXVoX-9FbdDbbq8RwBDQ216q0/od6/public/values')
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)
 
print(y)
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)