"be consistent" | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Dear monks! I think the following discovery might be useful for you: I openend an Excel-workbook to extract some data, as instructed in the node above: This worked with some files, but with one I repeatedly got an error-message that the operation could not be done due to some high load in Excel. The resulting investigation showed that this special file contained very complex pivot-tables. As a result, opening it seems not to be finished when I tried to access the worksheet. Strange. Fortunately, this could be solved very easily with the following code:
Hope this node helps you (and saves you some debugging-time) in case you encounter the same situation! RataIn reply to Win32::OLE Excel: script stops due to high excel load
by Ratazong
|
|