Hi there,
I'm sort of stuck. What I'm having to do is do read out data from a logging device via a serial port. I have managed to read data from the port into excel, I'm just not sure of the method to use when it comes to evaluation
It's quite a number of values I have to read, about 30000 mostly consisting of three digits and a comma.
I can't read all at once due to the limitation of the buffer size.
My idea of solving the problem is as follows:
1. read out data as long as data are streamed
2. add up the read data into one single large string
3. split into array by comma
4. since the streamed data are representing 6 channels, I'll have to transform that one-dimensoned array into a two-dimensional one with one dimension having 6 values (to become 6 columns later)
Is this a promising way? Can Excel handle string variables and arrays of this size (even excel 2003)?
Thanks for looking at it
Steffen
I'm sort of stuck. What I'm having to do is do read out data from a logging device via a serial port. I have managed to read data from the port into excel, I'm just not sure of the method to use when it comes to evaluation
It's quite a number of values I have to read, about 30000 mostly consisting of three digits and a comma.
I can't read all at once due to the limitation of the buffer size.
My idea of solving the problem is as follows:
1. read out data as long as data are streamed
2. add up the read data into one single large string
3. split into array by comma
4. since the streamed data are representing 6 channels, I'll have to transform that one-dimensoned array into a two-dimensional one with one dimension having 6 values (to become 6 columns later)
Is this a promising way? Can Excel handle string variables and arrays of this size (even excel 2003)?
Thanks for looking at it
Steffen