Reading excel is no problem, in excel, there is a cell format for "custom", type "h: mm, excel data as" 1:01:00 ", then the Sh1. OlePropertyGet (" Cells ", 3, 6). OlePropertyGet (" Value ") the data is "0.0423611111111111", expert help, how can I get the original data "1:01:00"??

CodePudding user response:

Yourself, take the 1900-01-01 00:00:00 time, then add double, then take HH: MM: SS can get the original data,

CodePudding user response:

is set to text format is universal