Thread Subject: Read data from excel

Hi, I have a problem while reading data from excel.
Every cell in my excel file is in the format:
1234;5678
However, I need to read both numbers, how can I do this?
Is there any formula for this?

"Ying Yap" <yyap1@iit.edu> wrote in message
<g40a3a$lcr$1@fred.mathworks.com>...
> Hi, I have a problem while reading data from excel.
> Every cell in my excel file is in the format:
> 1234;5678
> However, I need to read both numbers, how can I do this?
> Is there any formula for this?


If you excel file has data like 12;34;56, you can try to
save this file as a notepad. then see the format if it is
the same format then import the notepad file in the excel
as comma dilimiter file and save as .csv.
then you can use csvread(filename&path)to open your excel
file.

"Ying Yap" <yyap1@iit.edu> wrote in message
<g40a3a$lcr$1@fred.mathworks.com>...
> Hi, I have a problem while reading data from excel.
> Every cell in my excel file is in the format:
> 1234;5678
> However, I need to read both numbers, how can I do this?
> Is there any formula for this?

[a,b] = xlsread(filename);

Then parse each element of array b using strtok(b{i,';'),
for example. Then you may want to use sscanf. The
possibilities are many.