Importing from excel to matlab

1 view (last 30 days)
Danielle Leblanc
Danielle Leblanc on 8 Aug 2011
Hi,
I am trying to import a table from excel to matlab but I am facing many problems:
1.R (superscript) 2 (i.e. r square) becomes R2
2.α and β disappeared
3.Merged cells that are underlined return back to multiple cell where the first one contains the string of the merged cells and the underline disappear.
Is there a way to overcome these problems when importing from excel to matlab?

Answers (1)

Oleg Komarov
Oleg Komarov on 8 Aug 2011
Those issues pertain to the format which is not preserved when importing. I guess you could use ActiveX to parse the excel and retrieve the various formats and apply them to the data once imported but it's not a trivial task.
  2 Comments
Danielle Leblanc
Danielle Leblanc on 8 Aug 2011
Is there at least a way to write them in a cell array using matlab.I mean can I write aplha , beta and superscripts in matlab?
Oleg Komarov
Oleg Komarov on 8 Aug 2011
Not that I know of.
You can display as a text label:
text(.5,.5,'a','FontN','symbol')

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!