I did say that I believe that you'll have better luck pursuing the answer from MicroSoft (since you have -- I trust -- read S:WE's documentation carefully and followed up with a look at on-line info such as http://homepage.eircom.net/~jmcnamara/perl/WriteExcel.html without finding any clues to implementing your desires).

I have come to that belief because Spreadsheet::WriteExcel was created to replicate (and AFAICT, is limited to) the internal file-writing capabilities of Excel itself. So investigating M$ for hints about how to use both line styles in one file might well tell you whether W:SE is likely to have that ability.

Or, of course, the module's author (jmcnamarra) may spot this thread and offer an authoritative answer (and that, of course, may differ substantially from mine).

Sorry,my mistake.

Yes,great to have the answer from the author too.