Hi,
I am having a problem trying to sort a 1D array of data into different columns in excel. Right now what I have is two arrays - one containing the name of the data and the other containing the data itself. I send the name to a case structure where the respective data is sorted and manipulated. The individual data is then written to the file through concatenate strings. The column headers in the file are already written in a previous file and the rest of the data is appended later.
My problem is that I just want to be able to read the header and put my data in that column accordingly without using concatenate strings. Is there a way to do this?
As I am dealing with CAN messages here so data needs to be sent in the corr
ect order. I can have timestamps appended to the data to form a cluster of name,data and timestamp.
I have attached a file to show how I am writing to file.
Please help.
Thanks
Shruti