Changing Cell Format for Excel using MATLAB
17 次查看(过去 30 天)
显示 更早的评论
How do I change cell format of Excel cells to Scientific which I need to plot. I use ActiveX Control as following Commands.
set(Excel.Selection.Font,'ColorIndex',7);
set(Excel.Selection,'HorizontalAlignment',3);
set(Excel.Selection.Interior,'ColorIndex',4);
set(Excel.Selection.Font,'Size',13);
set(Excel.Selection.Font,'bold',1);
if I use set(Excel.Selection.Format,'Scientific');
MatLab or excel does not support. pls help
"Thanks in advance"
0 个评论
采纳的回答
Walter Roberson
2012-7-2
It appears to me that you should be setting NumberFormat instead of Format. What you should set it to depends on the details of the display you want.
3 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!