Comments by SurbhiA (Top 4 by date)

because it is my requirement and want to show data as pivot table

The values are changed in excel and should be updated in excel.Same for grand totals

Hi,
Thanks for replying.
I have tried Excel.Interop but it doesn't update grand totals automatically on changing value of Data Field.
Now I am trying to use openxml sdk but my excel is not generating properly and I am unable to find sample code for same.

Thanks,
Surbhi