I have info that I need to export now to excel file. Is there a way to set data types in columns from python? For example I need one of the columns to be with dates in US format only.
There are pretty much two options for getting data into excel.
Save the data as a csv with common data formats and use the excel importers to auto-recognize and set the datatypes.
Use a python library that can write excel files and set the datatypes directly.
For the 2nd option
XlsxWriter is an excellent library that can write excel files and set the datatypes and formats for each cell.