New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

writing a Series with a multindex header does not write the header #572

sdementen opened this Issue Oct 19, 2016 · 2 comments


None yet
2 participants

sdementen commented Oct 19, 2016

Range("A1").value = df[column_name]
(with df having a multiindex) leaves empty the header while
Range("A1").value = df[[column_name]] writes the header properly

@fzumstein fzumstein added the bug label Oct 19, 2016


This comment has been minimized.

ghost commented Oct 19, 2016

Can you attach a snippet we can run that will reproduce the bug?


This comment has been minimized.


sdementen commented Oct 19, 2016

here you are

import pandas
import xlwings

df = pandas.DataFrame(data=1, index=[1, 2, 3, 4], columns=pandas.MultiIndex.from_tuples([("A", "foo"), ("B", "baz")]))
wb = xlwings.books.add()
wb.sheets[0].range("A1").value = df[("A", "foo")]   # bug, no header
wb.sheets[0].range("E1").value = df       # ok, header there

@fzumstein fzumstein added this to the v0.10.1 milestone Dec 5, 2016

@fzumstein fzumstein closed this Dec 5, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment