How to add a workbook to a spreadsheet

[Josh Sale]

I'm working with OWC11 using ASP.Net on the server and want to create a
second workbook to my spreadsheet. In Excel, I would do a Workbooks.Add and
be on my way.

What do I need to do in OWC?

Once I have the new workbook, I want to load it with XMLSpreadSheet data I
have sitting in one of my variables.

Anybody know what to do?

TIA,

josh

 

[Andy Tischaefer [MS]]

The spreadsheet component only supports having a single
workbook "open" at a time. Basically a given instance of
the component corresponds with one workbook - you can't
close one workbook and open a new one using the
spreadsheet component, like you can in Excel. If you
need to have two workbooks open at the same time, you'll
need two different spreadsheet components to do it.

Loading XMLSpreadsheet data is as simple as:

SpreadsheetObject.XMLData = myXMLVariable

Note that loading new data will wipe out any existing
data in the SpreadsheetObject.

- Andy Tischaefer