First problem: xlutils-1.7.0 would not install no matter what I did. I used the command prompt and installed it the same way as all of the other packages, but it returned an error. Feeling that I did not need it yet I moved on.
Second problem: Using xlrd, I can not import an .xls or xlsx file in any meaningful way. I have tried verifying encoding, but even when I change encoding I seem to get the same output. Example output as seen in Python 3.3.3 Shell:
<xlrd.book.Book Object at 0x0108DF90>
What I have:
Calling from PyExcelerate I can write, manipulate and save .xlsx files with no problem. I just need to figure how to import the data from .xlsx files in a way that I can assign cell by cell block values as variables and rewrite them onto another file. I am compiling information from a list of excel files and want to arrange data for a report that will be saved as an excel file. I have just began to get all of this together, but here is what I have so far:
- Code: Select all
from mmap import mmap,ACCESS_READ
from xlrd import open_workbook
with open('simple.xls','rb') as f:
The above code seems to output a similar value to the shell as I listed above, twice. As you can see this is adjusted code from the python-excel.org examples, adjusted for python 3 syntax. I have gone through tutorials, and the library for literally every term in the code to verify all input methods and conditions. I don't know what I am seeing, and being new to the language I am having a hard time decoding what the output is derived from. Thanks in advance for you help.