darknessomi / darknessomi/excellibrary

Need "DataSetHelpter" for worksheet also

Open
#68 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
Dominant language
C#
Stars
22
Forks
8
PR merge metrics
No merged PRs in 30d

Description

```
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

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing ExcelLibrary.DataSetHelper.CreateWorkbook, Workbook.Load, Worksheet, and Workbook.Save to understand how datasets and worksheet collections are handled. Reproduce the writeability error with the example, then verify that multiple worksheets can be populated from separate datasets and saved to Test.xls.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
tooling
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.