ClosedXML / ClosedXML/ClosedXML.Report

Working with ExpandoObject supported?

Open
#299 7 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
C#
Stars
647
Forks
122
PR merge metrics
No merged PRs in 30d

Description

I currently try to create a report generator with completely flexible data structures.
These are generated by a supplied xml structure that is converted into a ExpandoObject. (http://www.itdevspace.com/2012/07/parse-xml-to-dynamic-object-in-c.html)

Xml Sample

```

Company
01.01.2022 - 31.12.2022


35
1993-03-29
Beitrag 5
Kamera 72
Stunden
7
90
90
47
82
106


1
1981-07-31
Beitrag 23
Kamera 26
Stunden
6
27
265
179
155
61


55
1996-02-13
Beitrag 35
Kamera 12
Stunden
3
31
94
21
470
272


97
1998-03-22
Beitrag 63
Kamera 14
Stunden
8
52
247
94
251
0

```

This dynamic object is then put into the report generation with AddVariable but then I fail to use the generated properties in my excel template.
![image](https://user-images.githubusercontent.com/1926992/208932052-58dfb340-e3ef-4e31-ae87-67023449fa07.png)

The ExpandoObject has i.e. a property for `lv.Firma` but I still receive "Unknown identifier 'lv'"

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reported failure when an ExpandoObject is passed to AddVariable and its properties are referenced in the Excel template. Use the supplied XML-derived object and template expression as the test case; done means the expected dynamic properties resolve, or the supported limitation is clearly documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
tooling
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.