Change Excel Number Format From Matlab
21 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi
How to change excel number format to 2 decimal places from matlab using actxserver?
For example:
e = actxserver('Excel.Application');
eWorkbook = e.Workbooks.Add;
e.Visible = 1;
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item', 1);
eSheet1.Activate;
eActivesheetRange = e.Activesheet.get('Range', 'A1');
eActivesheetRange.Value = 0.022432;
eActivesheetRange.NumberFormat = ????
I want excel to displa 0.02
Thanks
George
3 commentaires
Fangjun Jiang
le 7 Oct 2011
When you post your question, look at the {}Code button above the text box.
Réponse acceptée
Fangjun Jiang
le 7 Oct 2011
eActivesheetRange.NumberFormat='0.00'
6 commentaires
Fangjun Jiang
le 7 Oct 2011
Okay, maybe that's a MS Office version thing.
I never had experience plot to Excel via MATLAB.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Use COM Objects in MATLAB 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!