Search code examples
excelmatlabstructuredata-import

How do I tell Matlab that some of the data which is being imported is in Hex?

I am trying to import the data from an excel sheet in which there are 3 columns (Time; Id; and Data).

The first column contains time (in seconds) while the next column has numbers (Id). The third column (Data), however, has hexadecimal numbers, therefore Matlab is unable to process that information and shows 'NaN' in the command window/structure whenever I try to retrieve any information from the third column.

I want to create a structure for each Ids and display the respective information inside that Id.

Hence is there anyway to obtain the information from the third column without getting NaN error?

Here's my code:

[dat1, dat2, dat3] = xlsread('1');
flds=dat3(1,:);
bus=cell2struct(dat3(2:end,:),flds,2);

for k=1:length(bus)
 if bus(k).Id == 150

    i=i+1;
    can_bus(k,:)
 end
end
Solution

  • You can get the raw text and do the conversion yourselves:

    To get the text, you have to get other output parameters from xlsread. For example:

    [num,txt,raw] = xlsread('file.xls');

    will return the numeric values in num, the text values in txt, and the raw cell data in raw.

    Source