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

when passing large numbers to excel from a pandas dataframe, xlwings truncates the values #35

Closed
littlea1 opened this Issue Jun 24, 2014 · 1 comment

Comments

Projects
None yet
2 participants
@littlea1

littlea1 commented Jun 24, 2014

I tried to send a pandas dataframe to excel using xlwings and the elements of the dataframe are getting truncated. Here is a toy example:

import pandas as pd
from xlwings import Workbook, Range

wb = Workbook()

mydata = {'00': [0.000000e+00, 1.133106e+08, 1.112194e+08], '01': [0.000000e+00, 1.125851e+08, 1.104678e+08], '02': [0.000000e+00, 1.118832e+08, 1.113757e+08]}
mymonth = [0, 1, 2]
mydf = pd.DataFrame(data=mydata, index=mymonth)

Range("A1").value = mydf

I'm using:

  • python 2.7.6 32bits
  • xlwings 0.1.0
  • pandas 0.13.1
  • numpy 1.8.0
  • MS Excel 2007

@fzumstein fzumstein added the bug label Jun 24, 2014

@fzumstein

This comment has been minimized.

Member

fzumstein commented Jun 24, 2014

This was an xlwings bug for the same reason as #31 that has been resolved by commit 08324da. xlwings v0.1.1 that includes this bugfix should be released during the next couple of days.

@fzumstein fzumstein closed this Jun 24, 2014

@fzumstein fzumstein added this to the v0.1.0 milestone Jun 25, 2014

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