Recently had a system of check on work attendance, export data to Excel, read and write very well, the exported data general type of display is normal, but the date and time is a pile of other digital type, set the cell's properties in the exported Excel for date and time are back to normal again, ask how to set the cell's properties when import?

CodePudding user response:

In the Excel record macro first, then change the format, then look at recording macros associated with format code, the last reference method and parameters of the code in the macro to OLE,