Importing from excel to matlab

4 views (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.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!