search

EPPlusSoftware / EPPlus

EPPlus-Excel spreadsheets for .NET
https://epplussoftware.com
Other
1.79k stars 272 forks source link

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

Open ses4j opened 2 years ago

ses4j commented 2 years ago

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:

image

in the source cell it looks like

image

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 commented 2 years ago

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 commented 1 year ago

EPPlus 6.1.1. will preserve attributes used by the Table function