Use yellow reward excel export, the datetime format export is 12 hours, want to guide into 24-hour what method?

After I put the date are transformed into character, export to the results of the 24 hours can be

But couldn't display the content in dw form, click on each row can be displayed, but the bank loses focus, sometimes see a blank, the export is content, don't have the show can't do check in the data window

You have any good export excel function or method, also in baidu to find a lot of do not conform to the requirements, some are not able to export the title, is the field name, after some export excel column width is very narrow, manual tuning

CodePudding user response:

The system locale for 24-hour a try, maybe the date column format mask is set to "YYYY - MM - DD", if not, estimate, you will need to convert the string

CodePudding user response:

Miss huang export, do more perfect, which version you use pb, I 9.0 no problem,

CodePudding user response:

refer to the second floor xiaocaoya response:

yellow teacher's export, do more perfect, which version you use pb, I 9.0 no problem,

O share the source code