topic Re: Import Excel Data (hh:mm:ss) in Talend Studio

Import Excel Data (hh:mm:ss)

wueste — Tue, 22 Jun 2021 19:37:12 GMT

Hello,

i try to import an excel sheet with a 'time' field (format hh:mm:ss, not dateTime) into a string field in Talend.

I don't get the same data.

Source Data: 07:16:09

Talend: 0,30288125

Source Data: 02:17:47

Talend: 0,09568800000000001

How can get the right Data (

07:16:09)

in Talend, or what have i to calculate to get the correct result?

Thanks a lot in advance!

Anonymous — Wed, 23 Jun 2021 03:00:07 GMT

In Excel, the cell format should be set to Time. In component, open the Advanced Settings panel, check the 'Convert Date column to string' box.

Regards

Shong

wueste — Wed, 23 Jun 2021 07:55:42 GMT

Dear Shong,

thanks for your answer. Unfortunately there is no change in the result:

source:

result:any idea?

Anonymous — Wed, 23 Jun 2021 09:17:12 GMT

I have made a quick testing and it works on my side. Can you upload a sample excel and for testing?

Regards

Shong

wueste — Wed, 23 Jun 2021 12:59:48 GMT

gjeremy,

sorry, but a short question: how to implement? in tmap?

wueste — Wed, 23 Jun 2021 13:52:45 GMT

Additional Information: The import file is a .xlsm file! maybe is that the problem?

wueste — Wed, 23 Jun 2021 14:40:45 GMT

shong,

attached a sample xlsm.

wueste — Thu, 24 Jun 2021 13:14:38 GMT

any ideas?

Thanks!