#coding=utf-8
from qgb import U,T
import xlrd
U.helphtml(xlrd)
fn=r"E:\HT\Hacked Team\Amministrazione\08 - VIAGGI\3 - Note Spese\2013\Costi 2013.xlsx"
# fn=r"C:\RaLC三维仿真软件\实用工具\LOG分析工具\LOG分析工具2.xls"
# fn=r"E:\HT\Hacked Team\Amministrazione\01 - CLIENTI\7 - Difensiva\ANAGRAFICA FORNITORE x Trentino Trasporti.xls"
# fn=r"E:\HT\Hacked Team\Amministrazione\01 - CLIENTI\6 - Offensiva\OLD\Budget_Business Plan_2014-2018_Template - USA - SGP.xlsx"
# fn=r"C:\RaLC三维仿真软件\实用工具\XML変換工具\XML変換工具.xls"
fn=r"D:\Test\te.xls"
data = xlrd.open_workbook(fn)
# U.helphtml(data)
ctype = 1
value = 'aaaaaa'
ss=data.sheets()
for table in ss:
for i in range(table.nrows ):
table.put_cell(0, 0, ctype, value, 0)
# U.helphtml(table.put_cell);exit()
print str(table.row_values(i)).decode().encode('gbk')
# U.pln(url)
# fh=open('%s.html'%i,'wb')
# fh.write(urllib2.urlopen(url).read())
# fh.close
cmd='''Zcolcurl.bat %s'''%(i)
# cmd=T.batencode(cmd)
# print cmd
os.system(cmd)
# exit()
# if(os.path.getsize(fn)<5):i-=1;continue
# sh=open(fn).read()
# if(sh.find("answer-date-link-wrap")==-1):break
U.pln(i)
if(i>16):exit()
i=0
while(True):
st=''
i+=1
try:st=U.read('%s.json'%i)
except:break
exec('''st=%s'''%st)
st=st['msg'][1]
print i,st[233:311]
U.helphtml(str(''))
os.system('start http://www.qq.com/')
exit()