i am facing some problems with opening an excel file. I am using XLRD
I am getting

XLRDError: Can't find workbook in OLE2 compound document


CompDocError: Not a whole number of sectors

exceptions in seperate try on different files.

1.Does any one know anout these exceptions? what is the cause?

2. what I should do to resolve these problems.?

Thank you,

I have not used the Microsoft Excel data extractor module, but I know it will not work with password protected spreadsheets. That could be the problem.

Also sudhir, it would be nice if you could display some of your code.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.