Why are the hour portions of my GMT times not being shown when I export data to Excel?

2 ビュー (過去 30 日間)
Brad
Brad 2016 年 2 月 6 日
回答済み: Brad 2016 年 2 月 9 日
I'm attempting to export some GMT time tagged data to Excel, that looks like this;
21:48:52.03 78532.0390000000 0
21:48:52.80 78532.8050000000 0
21:48:53.55 78533.5550000000 1
But when I export it to Excel, the result is this;
48:52.03 78532.0390000000 0
48:52.80 78532.8050000000 0
48:53.55 78533.5550000000 1
I'm attempting to format column E's number format with the following:
Activesheet.Columns.Item('E').NumberFormat='hh:mm:ss.000';
I'm using MATLAB 2015A and Excel 2010.
In looking at the on-line documentation, this should work - and does with older versions of MATLAB (2010a) and Excel (2003).
I've tried different number format combinations. None of which work and I get the exact result (above) every time.
Am I missing something subtle or just implementing this incorrectly?
Thank you.

採用された回答

Brad
Brad 2016 年 2 月 9 日
For unknown reasons, I had to add the following 2 lines of code to solve this problem;
RangeObject = ActiveSheet.Range('CELL:CELL');
RangeObject.cells.EntireColumn.NumberFormat = 'hh:mm:ss.000');
I've never had to do this using previous versions of EXCEL. But for EXCEL 2010 it appears to solve the problem.

その他の回答 (1 件)

Chad Greene
Chad Greene 2016 年 2 月 7 日
It looks like exporting dates and times to Excel might require special treatment.
  1 件のコメント
Brad
Brad 2016 年 2 月 9 日
Definitely requires some kind of treatment. But I've found nothing definitive yet.

サインインしてコメントする。

Community Treasure Hunt

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

Start Hunting!

Translated by