'How to remove the border of Pandas dataframe?

When I use pandas dataframe to excel, the border of the header will be generated automatically. When I use styleframe to excel, the border of the whole table will be generated automatically. I can not use pandas.io.formats.excel.header_style = None to remove the border of dataframe and styleframe.

pandas.io.formats.excel.header_style = None



Solution 1:[1]

Try this.

import pandas.io.formats.style

pandas.io.formats.excel.ExcelFormatter.header_style= None

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Carlost