Re^3: How to operate on multiple Excel worksheets with variable array

It's been awhile since I went down this road but doesn't is still show up in the task bar? Sure it's more than one key stroke or if you are an 'alt-tab focus' person then that, but my recollection (and personal frustrating experience) is that the application is still running in a keystroke/mouse accessible way to the user. For any long running parsing your risk of clicking on Excel goes up especially if you use Excel for other purposes.

This wasn't really part of my initial answer but the other risk of using Win32::OLE is that you have available both read and write capabilities for the file. In general this won't be a problem but you risk the case where you overwrite data before you have read it.

Comment on Re^3: How to operate on multiple Excel worksheets with variable array

Replies are listed 'Best First'.

Re^4: How to operate on multiple Excel worksheets with variable array
by davies (Prior) on Aug 09, 2016 at 12:47 UTC

"It's been awhile since I went down this road but doesn't is still show up in the task bar?": not in any Excel / OS combination I've used. The only way to see it is in the task manager, and then I've always had to look in processes rather than applications.

"the other risk of using Win32::OLE is that you have available both read and write capabilities for the file": if you are creating a file that you want to be read only, you can set the OS option accordingly at creation time & Excel will respect it. That applies even if you create the file using Excel.

I'm not trying to suggest that there aren't advantages to doing it your way in some - perhaps many - situations. But when I hack Excel, I'm usually doing something fairly technical that the WriteExcel module & its cousins can't do. So I'm always using Win32::OLE anyway (unless I'm writing directly in VBA) & therefore I'm more familiar with avoiding its dangers than with using other modules.

Regards,

John Davies

[reply]


Perl Monk, Perl Meditation
	PerlMonks