Forum Discussion
Data Streamer Data Out
Many thanks for your reply. I'm unsure how that would help. The underlying code takes strings from cells A5 to J5 and concatenates then with a comma between each. If B5 to J5 are empty then you get a string transmitted as: GA00,,,,,,,,, where "GA00" is the contents of cell A5. What I actually need to send is the contents of cell A5
=IF(LEN(CH0)>0,CH0&CHAR(10),IF(COUNTA(B5:J5)=0,A5,A5&","&B5&","&C5&","&D5&","&E5&","&F5&","&G5&","&H5&","&I5&","&J5))
- NikolinoDE
Many thanks for your suggestions. The problem is in relation to the Data Streamer Add In and not any formula in any cell. There seems no way to access teh code.I'm at the end of my wisdom (even if that sometimes doesn't mean much :)).
My final thought on this...
To configure data out to only send a single channel in Data Streamer, you can adjust the parameters for the Data Out function in the Workbook Settings tab when the Data Streamer add-in is enabled.
Adjusting these variables will change the amount of data displayed, the rate data is displayed, and the direction the data flows through the data tables on the Data In and Data Out tabs.
- @ NikolinoDE
Once again, thanks for taking the time and for your suggestion. I did try alterring the number of channels setting to 1 prior to seeking advice here but the setting only seems to inluence the recieved data rather than the send data. I think I need more time to play with it but I'm likely to end up writing some VBA code or doing the serial comms in NodeRed instead.