Forum Discussion
Data Streamer Data Out
Possibly a stupid question but here goes: How does one configure data out to only send a single channel? Currently, the datastreamer is sending out the command text from CH0 followed by 9 commas whic...
I'm not sure if I understood it correctly, but here's a quick solution proposal
=IF(LEN(CH0)>0,CH0&CHAR(10),IF(COUNTA(B5:J5)=0,A5,A5&","&B5&","&C5&","&D5&","&E5&","&F5&","&G5&","&H5&","&I5&","&J5))
=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.
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.