I'd use Spreadsheet::WriteExcel and it's add_worksheet method. If you must use OLE then I suggest reading the FAQ and using the macro recorder in Excel and (How do I convert a VBA macro to Perl? to figure out what you have to do.