The following are some of the examples included in the examples directory of the XlsxWriter distribution.
They show how to use XlsxWriter with Pandas.