"Object reference not set to an instance of an object." after removing Pivot table source about epplus HOT 3 CLOSED

has it been solved? or not entertaining the issue?

from epplus.

I have an xlsm file with this issue.
It has many sheets and many pivot tables: how can I programmatically check of a pivot table is not ok?
Thank you

from epplus.

i spent a chunk of time wracking my brain over this.. in one script task i delete a template worksheet, referencing the spreadsheet by name. in another script task i get a null pointer exception when attempting to reference a different worksheet by name.

after literally scouring my statements for syntax or logic issue, i came to the deduction that there must be something else going on.

on a hunch... i commented out the delete portion, and then it ran ok... then uncommented it out and moved it after the one that was previously erroring.

it's gotta be something with how EPPLUS accesses and modifies the internal excel worksheet indexing, even though in my case the calls to open and individual variable assignments were by using string literals of named worksheets in completely different script tasks.

if i can advise, try not to delete anything until the very end, after all of the references are completed.

hope that helps anyone else

from epplus.