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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
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() |