First, I would make sure that you can do this manually in Excel. If you can't, I'm not sure how to help you get Win32::OLE to do it. (By the way, I believe that I have seen this before Excel spreadsheets, so I think it is possible.)

Secondly, I would try to look at the OLE browser that is part of the Win32::OLE module and look specifically at the Excel library. Given that I don't have a good Basic/VB background, I admit that it's about like reading Greek for me.

Third, try to record a macros to do what you want and then look at its source code. I don't translate the VB to Perl line by line, but it should give you an idea what needs to be done. (For example, I usually ignore the select and activation lines.)

I'm out of town right now without a system that has both Excel and Perl, so I can't try testing/creating codes to help you right now. If I don't get swamped with other things, I'll try to look at this again in a few days and post some suggested code, but I make no promises. In the mean time, I hope that this information might help you down the right path to finding a solution.