Feb-03-2022, 04:58 PM
Here is a sample code is written for pyserial. I need some help in improvising the code.
WSt will have
systemdate
systemtime
Serial data received in the format
data1: value \n
data2: value \n
data3: value \n
data4: value \n
This value to be read and written in excel sheet
WSt will have
systemdate
systemtime
Serial data received in the format
data1: value \n
data2: value \n
data3: value \n
data4: value \n
This value to be read and written in excel sheet
import serial import csv import os import time def main(): pass if __name__ == '__main__': main() COUNT=0 ser=serial.Serial() ser.port=2 ser.baudrate=9600 foo=open("new.csv","ab"); result=csv.writer(foo,delimiter=',') result_statement=("date","time","data1","Data2","Data3","Data4") result.writerow(result_statement) foo.close() while(COUNT<300): ser.open() str=ser.read(500)# character are 115 val=str.split(":") print "value is",val lines=str.split("\r\n") wst=[] for line in lines[:-1]: parts=line.split(":") #print parts for p in parts[1:]: wst.append(p) #print "wst is", wst foo=open("new.csv","a+"); result=csv.writer(foo,delimiter=',') result_statement=wst result.writerow(result_statement) COUNT=COUNT+1 print COUNT foo.close() ser.close()