Changing Cell Format for Excel using MATLAB
22 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Walter Roberson
le 2 Juil 2012
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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!