how can i write comments on some cells of excel sheet using pandas

I didn’t find anything that enable me to write comments on some specific cell while writing excel sheet using panadas.to_excel . Any help is appreciated.

Answer

After searching for some time, I think the best way to handle comments or other such properties like color and size of text at cell or sheet level is to use XlsxWriter with pandas.

Here is the link to the some nice examples of using XlsxWriter with pandas:

http://xlsxwriter.readthedocs.org/working_with_pandas.html