|
If you replace:
my $sheet= $doc->getTableText("Sheet1", 1000, 1000);
with
my $normsheet = $doc->normalizeSheet("Sheet1", 10, 10);
my $sheet= $doc->getTableText(normsheet, 10, 10);
things will work. Check out the documentation on normalizeSheet. Short version is that staroffice compresses tables, and it takes a long time to decompress them, so rather than doing it fully for you, you have to specify how much to decompress. The main symptom of not decompressing, or 'normalizing', the sheet is that funny things happen to blank cells, especially multiple blank cells in a row. The key is to normalize as small an area as possible, because it really will take a long time to normalize a large area. Try to know the row and column # beforehand, if possible.
Hope that helps,
Matt
|
(4)
]
