Skip to content
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

Closed
sdementen opened this issue Oct 19, 2016 · 2 comments
Closed
Labels
Milestone

Comments

@sdementen
Copy link
Contributor

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
@ghost
Copy link

ghost commented Oct 19, 2016

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

@sdementen
Copy link
Contributor Author

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants