Extremely slow performance with getCellByPosition

Scott Deerwester <[email protected]>
Newsgroups gmane.comp.openoffice.devel.api
Message-ID <[email protected]>
The following code (in Python):

for r in range(dataRange.StartRow, dataRange.EndRow):
    for c in range(dataRange.StartColumn, dataRange.EndColumn):
        cell = sheet.getCellByPosition(c,r)


takes nearly two hours to run on a reasonably fast workstation for a
spreadsheet with 32 columns and ~27,000 rows (about .2 seconds per row). By
comparison, opening the file takes about 8 seconds and saving the file to a
CSV (which is functionally equivalent to the above) takes a few seconds. The
original file was written in Excel as an XLS (not XLSX). This seems
impossibly slow. Am I misusing the API somehow? What can I do to speed it
up?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.