MATLAB Answers

Excel formatting using Matlab

137 views (last 30 days)
NIKHIL
NIKHIL on 28 Aug 2020
Commented: dpb on 31 May 2021
I have saved data in excel using xlswrite but i am facing issue with alignment of cells and borders for tables, colouring of titles. can someone help me with formatting excel ? Some useful threads or links will also be helpful.
  2 Comments
NIKHIL
NIKHIL on 29 Aug 2020
Thank you Stozaki for your response. I was mainly looking for creating outline/border for the table data.

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 29 Aug 2020
See my attached Excel_utils class. It lets you format a bunch of things like font, coloring, borders, number of decimal points, etc. It has sample calls at each function.
I'm also attaching a standalone ActiveX demo that I think may do some formatting. And one to let you put a formula into a cell.
  14 Comments
dpb
dpb on 31 May 2021
ADDENDUM/ERRATUM:
NB: Passing an enumeration to get, set with at least certain objects as the above with border index and weight fails as apparently MATLAB passes something more than the integer value of the enumeration.
Had to cast the enumeration variable to a native numeric type to be able to use it -- see the Q? I posted that illustrates problem and the club to get around it...

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!