How to freeze the top row and the first column using XlsxWriter?

python excel pandas dataframe xlsxwriter
Krzysztof Słowiński picture Krzysztof Słowiński · Jan 30, 2018 · Viewed 9.1k times · Source

I am exporting a pandas DataFrame to Excel, and since it contains a lot of rows and columns, it would be useful to keep the top row and the first column when browsing its contents.

There is a feature present in Excel that allows for freezing the top row and the first column. Is accessible through XlsxWriter when exporting DataFrames to excel?

Answer

Sandeep Lade picture Sandeep Lade · Jan 30, 2018

You can use worksheet.freeze_panes() to achieve this . There are many options for that method. Read http://xlsxwriter.readthedocs.io/worksheet.html#worksheet-freeze-panes to know how to use the method.

Related questions

Putting many python pandas dataframes to one excel worksheet

It is quite easy to add many pandas dataframes into excel work book as long as it is different worksheets. But, it is somewhat tricky to get many dataframes into one worksheet if you want to use pandas built-in df.…

Read More
Using Pandas to pd.read_excel() for multiple worksheets of the same workbook

I have a large spreadsheet file (.xlsx) that I'm processing using python pandas. It happens that I need data from two tabs in that large file. One of the tabs has a ton of data and the other is just …

Read More
Could pandas use column as index?

I have a spreadsheet like this: Locality 2005 2006 2007 2008 2009 ABBOTSFORD 427000 448000 602500 600000 638500 ABERFELDIE 534000 600000 735000 710000 775000 AIREYS INLET459000 440000 430000 517500 512500 I don't want to manually swap the column with the row. Could it be possible to use pandas reading data to a list as this: data['ABBOTSFORD']=[427000,448000,602500,600000,638500] data['ABERFELDIE']=[534000,600000,735000,710000,775000] …

Read More