[crazy123]

How do I open a .xls file with python? I use Windows

My goal is to read each column of the spreadsheet and save it in a vector. It's possible?

[Atli]

I usually don't post "Just Google it" responses, but seriously, you could have found multiple valid ansvers to this question by just putting it in a search engine.

The most promising answers on that first Google page (to my non-Python developer eyes) are:
- Read Excel files from Python
- Working with Excel files in Python (PDF)


If you've already tried some of those methods and failed to make it work, say so. Show us what didn't work, and perhaps we may be able to help you fix it.

[atraub]

Yeah, I probably would have posted a lmgtfy link as I did with this post earlier this week

[crazy123]

Atli, on 18 May 2012 - 04:06 PM, said:

I usually don't post "Just Google it" responses, but seriously, you could have found multiple valid ansvers to this question by just putting it in a search engine.

The most promising answers on that first Google page (to my non-Python developer eyes) are:
- Read Excel files from Python
- Working with Excel files in Python (PDF)


If you've already tried some of those methods and failed to make it work, say so. Show us what didn't work, and perhaps we may be able to help you fix it.

I've searched on the internet but do not have the module xlrd for windows and trying to open direct with open() does not work

[atraub]

So, you need to download files for reading and writing to excel? Did you try using the googles?

This post has been edited by atraub: 18 May 2012 - 04:54 PM
Reason for edit:: you left me no choice

[crazy123]

atraub, on 18 May 2012 - 04:36 PM, said:

So, you need to download files for reading and writing to excel? Did you try using the googles?

I'm sorry, I'm sleeping.
I found xlrd1 for windows
I tried a program to print the cell A1

import xlrd1

wb = xlrd1.open_workbook('file.xls')

sh = wb.sheet_by_index(0)

print sh.cell(0,0).value

Output:

Traceback (most recent call last):
  File "file.py", line 3, in <module>
    wb = xlrd1.open_workbook('file.xls')
  File "C:\Python27\xlrd1\__init__.py", line 431, in open_workbook
    on_demand=on_demand,
  File "C:\Python27\xlrd1\__init__.py", line 899, in biff2_8_load
    f = open(filename, open_mode)
IOError: [Errno 22] invalid mode ('rb') or filename: 'file.xls'

What am I doing wrong?

[atraub]

Are you sure file.xls is in the same directory as the script you're running?

[crazy123]

atraub, on 18 May 2012 - 05:00 PM, said:

Are you sure file.xls is in the same directory as the script you're running?

Yes. I've also tried specifying the path

I used \\ and work. But now gave the following error

raise XLRDError('Unsupported format, or corrupt file: ' + msg)
XLRDError: Unsupported format, or corrupt file: Expected BOF record; found 'ABCD\t'

[atraub]

it says your file format is bad, are you sure that it's a valid xls file?

[crazy123]

atraub, on 18 May 2012 - 05:18 PM, said:

it says your file format is bad, are you sure that it's a valid xls file?

Yes is a xls with more than 2GB. I tried to read the cell A1 to test. My goal is to store each column in a vector

[crazy123]

The problem is that my Excel file have more rows than allowed. As I have split this file into smaller pieces?

[atraub]

I dunno, that could be it. Give it a try and let us know what happens.

[crazy123]

atraub, on 18 May 2012 - 07:23 PM, said:

I dunno, that could be it. Give it a try and let us know what happens.

I do not know how to divide a file .xls
If the reports that Excel can not open all the lines which program can?

[atraub]

Probably a .net language would be better suited for this.

[Dogstopper]

crazy123, on 18 May 2012 - 10:45 PM, said:

atraub, on 18 May 2012 - 07:23 PM, said:

I dunno, that could be it. Give it a try and let us know what happens.

I do not know how to divide a file .xls
If the reports that Excel can not open all the lines which program can?

To divide an xls, simply take a certain amount of the file, push ctrl-x, open another file and push ctrl-v.
You will want to divide it by rows and not by columns.