ENH: Set column to work for datetimes for Xlsxwriter
- [x] closes #30275
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] whatsnew entry

Enhancement for Xlsxwriter to enable the usage of `set_column` for datetime columns for setting the format , just like how it can be done for numbers.
Exception includes the datetime columns which already have a formatting, for eg - `DatetimeIndex`

Closing this in favor of another approach.