Landray RDM 183281 Convert Effect

cells source code:
src.zip (1.6 KB)

origin cells:
2023华宇监理安培第一批名单.xlsx.zip (12.1 KB)

before converted:
image.jpg (522.2 KB)

after converted:
image.jpg (346.4 KB)

Please have a check.

@hucq_landray_com_cn,

In your source code you specified the region as USA when loading the workbook. So when you saving the workbook, the formatting settings of USA region will be used to format cells. If the formatted result of date time is separated by ‘-’ for the default region of your environment/application, you may just remove the line of code where setting region USA to the load options. Otherwise you need to specified another region which can format date time as “yyyy-m-d” for the load options.