search

tgui78 / excellibrary

Automatically exported from code.google.com/p/excellibrary
0 stars 0 forks source link

Need "DataSetHelpter" for worksheet also #68

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
When using ExcelLibrary.DataSetHelper.CreateWorkbook("Test.xls", ds) I am 
unable to add worksheets to "Test.xls" it seems.  Trying to use Workbook.Load 
throws an error saying the stream is not writeable.  What I'd like to do is:

Dim ws(3) As ExcelLibrary.SpreadSheet.Worksheet
ws(0) = New ExcelLibrary.SpreadSheet.Worksheet("Title")
ws(0).DataSetHelper(dataSet1)
ws(1) = New ExcelLibrary.SpreadSheet.Worksheet("Parts")
ws(1).DataSetHelper(dataSet2)
ws(2) = New ExcelLibrary.SpreadSheet.Worksheet("Analysis")
ws(2).DataSetHelper(dataSet3)
Dim wb As ExcelLibrary.SpeadSheet.Workbook = New 
ExcelLibrary.SpreadSheet.Workbook()
wb.Worksheets.AddRange(ws)
wb.Save("Test.xls")

Original issue reported on code.google.com by xstream....@gmail.com on 20 Sep 2010 at 3:33

GoogleCodeExporter commented 8 years ago 
Sorry, but this should have been marked as a Task, not a defect.

Original comment by xstream....@gmail.com on 20 Sep 2010 at 3:34

GoogleCodeExporter commented 8 years ago 
Can you not add all the "sheets" as datatables to the dataset?

Original comment by garethte...@gmail.com on 26 Oct 2010 at 2:11