#-*- coding:utf-8 -*-

import win32com.client
import time
import serial

ser = serial.Serial('COM6',9600)
ser.readline()
xl_app = win32com.client.GetObject(Class='Excel.Application')

while True:
	val_arduino = ser.readline()
	buf = val_arduino.strip().decode('UTF-8')
	a = buf.split(',')    
	rn = xl_app.Cells(4,2).value
	xl_app.Cells(rn,2).value = a[0]
	xl_app.Cells(rn,3).value = a[1]
	xl_app.Cells(rn,4).value = a[2]
	xl_app.Cells(rn,5).value = a[3]
	xl_app.Cells(rn,6).value = a[4]
	xl_app.Cells(rn,7).value = a[5]
	xl_app.Cells(rn,8).value = a[6]
	xl_app.Cells(rn,9).value = a[7]
	xl_app.Cells(rn,10).value = a[8]
	xl_app.Cells(rn,11).value = a[9]
	xl_app.Cells(rn,12).value = a[10]
	xl_app.Cells(4,2).value = rn + 1
	time.sleep(1)
ser.close

exit()