[Jprogramming] tara readxlsheets problem

[Bill Harris]

On Tue, June 29, 2010 4:28 pm, bill lam wrote:

> getppssearch is part of ole storage lite that was ported from perl,
> but I have very limited knowledge on both ole and perl.  It failed
> when parsing an ole storage stream, so either the parsing code is buggy
> or the structure of your workbook is mal-format.  How were those excel
> files generated? by real excel program or by other excel file writing
> programs?  I am afraid I cannot help much by not getting a file to test.

Bill,

Thanks.  Quick answer: they were generated by a person using Excel --
either 2003 or 2007.  I think they have a number of macros.  They are all
supposedly the same workbook with different data, although they may be of
different revisions / layouts.

I'm about to give up and capture this bit of data more manually -- I have
limited time to devote to this project, and I've not yet been able to
design a sanitized workbook that fails.  If I think of anything, I'll post
it.  If you or anyone else think of anything, let me know.

Thanks,

Bill