xlwt and xlutils not working while xlrd works all right
NickName:fanny Ask DateTime:2014-01-28T17:48:47

xlwt and xlutils not working while xlrd works all right

I am a Windows user and I have a Python 2.7 version. I would be really grateful if someone helped me on that: I have downloaded, unpacked with 7Zip and installed xlrd, xlwt and xlutils (the installation seemed to be completed all right) but only xlrd works. Even short commands like from xlwt import * result in an error, e.g.:

Traceback (most recent call last):
  File "C:/Users/fanny/Desktop/python/excel_28.01.w.o.utils.py", line 2, in <module>
    from xlwt import *
  File "C:/Users/fanny/Desktop/python\xlwt.py", line 1, in <module>
    from xlutils.copy import copy
  File "C:\Python27\lib\site-packages\xlutils-1.7.0-py2.7.egg\xlutils\copy.py", line 7, in <module>
    from xlutils.filter import process,XLRDReader,XLWTWriter
  File "C:\Python27\lib\site-packages\xlutils-1.7.0-py2.7.egg\xlutils\filter.py", line 17, in <module>
    from xlwt.Style import default_style
ImportError: No module named Style

What could be the problem?

Copyright Notice:Content Author:「fanny」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/21402075/xlwt-and-xlutils-not-working-while-xlrd-works-all-right

More about “xlwt and xlutils not working while xlrd works all right” related questions

xlwt and xlutils not working while xlrd works all right

I am a Windows user and I have a Python 2.7 version. I would be really grateful if someone helped me on that: I have downloaded, unpacked with 7Zip and installed xlrd, xlwt and xlutils (the install...

Show Detail

Alternative to xlrd, xlwt and xlutils in python

Are there any alternative to xlrd, xlwt and xlutils for handling MS Excel in python? As far as I know, their licensing does not allow it to be used for commercial purpose and I was wondering if the...

Show Detail

Including xlrd/xlwt/xlutils with modules outside of python installation

I'm self-taught in the Python world, so some of the structural conventions are still a little hazy to me. However, I've been getting very close to what I want to accomplish, but just ran into a la...

Show Detail

editing existing excel workbook using xlrd, xlwt and xlutils

How to edit and save the data in an existing excel workbook using xlrd, xlwt and xlutils module? could someone please provide a sample code to edit and save the data in excel workbook? I am trying...

Show Detail

Python 3 xlutils+xlrd+xlwt

I'm struggling with editing existing xls workbook with xlrd/xlwt/xlutils I can change values in xlrd workbook, but I need to write them in existing workbook. My code doesn't work, I know that algho...

Show Detail

Preserving styles using python's xlrd,xlwt, and xlutils.copy

I'm using xlrd, xlutils.copy, and xlwt to open up a template file, copy it, fill it with new values, and save it. However, there doesn't seem to be any easy way to preserve the formatting of the c...

Show Detail

How to copy hyperlinks using xlrd, xlwt and xlutils?

Problem: I am trying a simple code for writting excel sheet. The program checks if the Excel sheet already exists, If the file exists, then it append it with the new data. The problem is I am unabl...

Show Detail

Copy Sheets with xlrd/xlutils

I have a folder with many excel files of the same format, with multiple sheets. The goal is to loop through the folder and move one of the sheets in each notebook to an new notebook i.e. ending up ...

Show Detail

How do we preserve Shared Workbook property settings using xlrd,xlwt & xlutils?

When I open a Shared Workbook with Multiple Edit enabled, I loose the settings while saving the file using xlwt. Here is the code which I am trying, but this do not save the shared workbook propert...

Show Detail

How to copy an existing worksheet and multi-paste it in the same workbook using xlrd, xlwt, and xlutils

I have an excel template file dot xlt extension. I want to make a program using python (xlrd, xlwt, and xlutils) where it will copy the existing template to the new workbook (distinct name). Then the

Show Detail