While I agree with Jeff that working with Excel using SSIS has a lot of drawbacks, I have done what you are attempting.

You can start writing the rows to the xls connection in SSIS and modify the rows to skip to start where you know the header rows end.

Also bear in mind you need to set the job to run in 32 bit mode.