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:lpstr>Regneark</vt:lpstr>
</vt:variant>
- <vt:variant>
<vt:i4>1</vt:i4>
</vt:variant>
</vt:vector>
</HeadingPairs>
- <TitlesOfParts>
- <vt:vector size="1" baseType="lpstr">
<vt:lpstr>Template</vt:lpstr>
</vt:vector>
</TitlesOfParts>

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