dfinke/ImportExcel

Feature Request: Support for Treemap Chart in ImportExcel

Closed this issue · 1 comments

Currently, ImportExcel does not support Treemap charts when using Add-ExcelChart. Treemap is a useful visualization type for hierarchical data representation, commonly used in Excel. I attempted to create a Treemap chart using the eChartType enumeration, but it appears to be unsupported.

I would like to request support for Treemap charts in Add-ExcelChart. This would allow users to generate Treemap visualizations directly from PowerShell, similar to how other chart types (e.g., ColumnClustered, Doughnut) are implemented.

I attempted to use eChartType::Treemap, but it is not recognized as a valid option.
As a workaround, I used ColumnClustered or Doughnut charts, but they do not provide the same hierarchical visualization that Treemap does.

I'm using ImportExcel version 7.8.10, which I believe is the latest available.
EPPlus (which ImportExcel depends on) does support Treemap charts, so it may be possible to implement this feature.

If there is a technical limitation preventing this from being added, I’d appreciate any insight into it.

Thank you for maintaining this fantastic module!

@b82klo thanks for trying ImportExcel.

Yes, the EPPlus version does not have Treemaps, so ImportExcel doesn't.

I don't update the source for that and would not support updates from folks other than the reccent developers.
They moved on to a new version of EPPlus, made lots of updates that created expected breaking changes and now require a paid license.

Sorry