Support for copying 'What-if Analysis' Data Table {TABLE()} functionality between workbooks?

[ses4j]

Hi -

I have a use case where I need to copy Excel sheets from one workbook to another, and preserve everything. It works quite well, using:

outputPackage.Workbook.Worksheets.Add(workSheetName, sourceSheet);  

However, it makes use of a somewhat-obscure feature:

in the source cell it looks like

but in the output cell it has lost the TABLE() and is just a calculated result.

Is there anything I can do? Is this something that can be supported?

Thanks!!

[JanKallman]

Hello, EPPlus currently don't support the forumula type "dataTable", so we will have to implement it. I'll see if I can add it to the next version.

[JanKallman]

EPPlus 6.1.1. will preserve attributes used by the Table function