Skip to content

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

@littlea1

Description

@littlea1

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions