exporting to multiple sheets in XLS format
- To: mathgroup at smc.vnet.net
- Subject: [mg87422] exporting to multiple sheets in XLS format
- From: "Russo, Peter (10170)" <peter.russo at protiviti.com>
- Date: Thu, 10 Apr 2008 02:12:45 -0400 (EDT)
Is there a way to export to multiple worksheets in excel XLS format=3F
When importing, you can choose which sheet to import from, for example:
Import["sample.xls",{"Data",2}]
will import the data fields from worksheet 2.
However, is there a way to do the same sort of thing with export=3F
Or even better, write to many worksheets all at once (in the same XLS
object ) or the ability to append worksheets to already created XLS
document.