How to retrieve objects from merged cells or save them to Excel?

mganss / ExcelMapper

An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.

MIT License

793 stars 122 forks source link

How to retrieve objects from merged cells or save them to Excel? #281

Open ReallyCreep opened 1 year ago

ReallyCreep commented 1 year ago

mganss commented 1 year ago

There is no specific support for reading merged cells. The value will be present only in the first row of the merged range. For saving there is no specific support, either, but you can subscribe to the Saving event and manipulate the saved sheet, setting the IsMergedCell property to true on the cells you want to merge.

Contributions for support of merged cells are very welcome.