Member Avatar for katharnakh

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

XLRDError: Can't find workbook in OLE2 compound document

and

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,
regards,
kath.

  • 2 Contributors
  • 1 Reply
  • 318 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by vegaseat
Member Avatar for vegaseat

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, networking, learning, and sharing knowledge.