Can a single worksheet be exported?

[Carl Rapson]

I am working with the OWC10 (Office XP) spreadsheet control, and I have a
workbook that contains multiple worksheets. I would like to be able to save
each sheet as a separate XML file, if possible. I know I can save the entire
workbook using the Export method of the spreadsheet object, but is there a
way to save an individual worksheet? I haven't been able to find any method
that would let me do this.

Any information is greatly appreciated,

Carl Rapson

 

[Alvin Bruney]

That's not available out of the box. One possible work around is
programmatically remove all the sheets you don't need in the workbook and
then do an export. That way, your export will now consist of only the
worksheet you want. It agree it's not pretty but it will work.

 

[Carl Rapson]

Thanks, I hadn't thought of that. I guess as long as I don't save it to the
original file name, I'll be OK.

Carl Rapson