Multiple worksheets

Aug 2, 2007 at 11:00 AM
What is the best way to add mutiple worksheets
because I can't get it to work just to use
Dim worksheet As ExcelWorksheet = xlPackage.Workbook.Worksheets.Add(dReader("Omviser").ToString)
several times

app.xml show only one sheet from the template

- <HeadingPairs>
- <vt:vector size="2" baseType="variant">
- <vt:variant>
- <vt:variant>
- <TitlesOfParts>
- <vt:vector size="1" baseType="lpstr">

xl\worksheets contains all sheets
xl\workbook.xml also contains all sheets