Implement Formatter.TimeFormat for Excel Dataplugin.
Workbook.Formatter.TimeFormat = "YYYY-MM-DD hh:mm:ss"
Block = Sheet.GetCellBlock(2+clOriginRow-1, clOriginCol)
Block.Channels.Add(sChnName, eTime)
Channel.Formatter.TimeFormat = "fff"
The Formatter.TimeFormat are both in CodeCompletion, but not actually valid when using an XLS Dataplugin method.
The best way to get milliseconds from a separate column into your time format right now is to run a separate script after import, OR do row by row and add it along the way.
Just asking for the same functionality on Excel import as on CSV import.
Thank you.
Hello
Thank you for your request. R&D has read this suggestion and it will be included in feature planning discussions for future DIAdem versions.
Greetings
Walter