Pivot table creation from downloaded excel file does not give expected result

Jul 31, 2016 at 2:22 PM
We are allowing user to download the report as an excel format, we are using epplus to provide the end user the download facility. When user download the report as an excel format and try to create a Pivot Table then they empty cells are also consider in the count.

But after downloading the excel and user manually select the excel cell with empty value and press the delete button then pivot table gives the expected result.

I think epplus add an empty value in the cell for the null field but it should keep the cell as blank.

Is there any work around to fix this issue.
Aug 2, 2016 at 5:46 PM
I dont know, how you cook it^

check my sample at :
external link