Re^7: How to use win32::OLE with multiple versions of Microsoft Office?

can I use Win32::OLE without installing MS Office??

Sure, for other things, like controlling internet explorer (some versions of), but not for controlling MS Office, you need MS office for that

Kindly suggest me something for this.

I hear ice always helps :)

Comment on Re^7: How to use win32::OLE with multiple versions of Microsoft Office?

Replies are listed 'Best First'.
Re^8: How to use win32::OLE with multiple versions of Microsoft Office? by perl_new_b (Novice) on Jul 23, 2014 at 09:17 UTC
Ok thanks for the reply. :) can I append a row in excel file without parsing it and without using Win32::OLE?	[reply]
Re^9: How to use win32::OLE with multiple versions of Microsoft Office? by Corion (Patriarch) on Jul 23, 2014 at 09:19 UTC
Have you looked at what Excel shows? I recommend Excel::Writer::XSLX, and there also is Spreadsheet::SaveParser::WriteExcel for "modifying" spreadsheets (by loading and then saving them).	[reply]
Re^10: How to use win32::OLE with multiple versions of Microsoft Office? by perl_new_b (Novice) on Jul 23, 2014 at 10:31 UTC
I did looked them. But one requires to parse them before editing. And for large files in this case, memory goes out of bound. Also to add, I used cell handler to minimize the usage but for for excel files which contains tables, cell handler skips the last row. So, I'm sort of stuck here.	[reply]
Re^11: How to use win32::OLE with multiple versions of Microsoft Office? by roboticus (Chancellor) on Jul 23, 2014 at 11:33 UTC


No such thing as a small change
	PerlMonks