in reply to Detecting and Deleting empty rows and cols in excel using win32::OLE
Disclaimer: I don't have a Win box at hand now, so I can't verify what I'm saying.
I think that if you give a "select all" command and then examine the selection object, you should be able to determine the last used column and row. After that, it's only a matter of iterating through rows and columns to find the empty ones.
Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."
|
|---|