MATLAB: I have a excel file which contains both number and txt, I wanna assign whole values in this excel file to the listbox

listbox

for example,

first column of the excel file includes only txt second column of the excel file includes only num third column of the excel file includes only num

the excel file's size nx3

I wanna assign these nx3 into the list box with both txt and num.

Best Answer

Import data to Matlab by implementing xlsread()
Create a cell variable and assign all the n*3 data to the cell variable

Related Solutions

MATLAB: Write to txt, delimited by char(10)

x = ['a' char(10) 'b'];
fp = fopen('test.txt','w');
fwrite(fp,x);
fclose(fp);

I am on a Mac and using R2018b. That being said the above should work on all OS and most MATLAB releases.

There is also a command in MATLAB called newline (which is the same as char(10)

MATLAB: Excel dates

Use [Num,Txt,Raw]=xlsread() and then "Raw" will keep the "hh:mm" string format, then you can use datenum() to convert it.

If the format of the cells in Excel is "Time", it looks like the numerical value is imported using xlsread(). You can use datestr() to convert it back. For example:

>> [Num,Txt,Raw]=xlsread('test.xls')
Num =
    0.4743
    0.5160
    0.5576
    0.5576
Txt = 
    'Date'          'Time'
    '12/31/1899'        ''
    '1/1/1900'          ''
    '1/2/1900'          ''
    '1/3/1900'          ''
Raw = 
    'Date'          'Time'  
    '12/31/1899'    [0.4743]
    '1/1/1900'      [0.5160]
    '1/2/1900'      [0.5576]
    '1/3/1900'      [0.5576]
>> datestr(Num,'HH:MM')
ans =
11:23
12:23
13:23
13:23

Best Answer

Related Solutions

MATLAB: Write to txt, delimited by char(10)

MATLAB: Excel dates

Related Question