@echo off
python -c "import sys,json,win32com.client as w
w=w.gencache.EnsureDispatch('Kwps.Application')
w.Visible=True
b=w.Workbooks.Open(r'C:\Users\l1889\Desktop\tank_data.xlsx')
s=b.Sheets('\u8ba1\u7b97\u8868')
r=s.UsedRange.Rows.Count+1
d=json.loads(sys.argv[1])
m={'tank':1,'level':2,'temp':3,'outer_temp':4,'density':5,'pipeline':6,'water':7,'quantity':8,'time':17}
for k in d:
 if k in m:
  s.Cells(r,m[k]).Value=float(d[k]) if k!='tank' and k!='time' and k!='type' else d[k]
b.Save()
print('OK:'+d.get('tank','?'))" "{\"tank\":\"TK2701\",\"level\":12.689,\"temp\":29,\"quantity\":4789.960}"
pause