Cool. That's one I've not tried yet but sounds like a slick solution and one I could make use of fairly soon.
I've only just read both your posts, and when I saw your comment about option 1, the first thing I wanted to know was "did you check the whole sheet?". As you now realise, there are some quirks about how the sheet is handled.
I've been caught out like that. I set up a template with a sheet containing just headings, saw the package write a few hundred rows, opened the workbook and all I got was the headings. However, scroll down, and there's my data at row 5000 or somewhere near. When I create a template now, I make sure I've deleted all empty rows, and then put the headings in.