create pivot table using openXMl in C# RRS feed

  • Question

  • Hi,

    I have binded the data to worksheet sheet2 (datatable to worksheet) , it have 26 columns and 700 rows.  now i want to create pivot table in sheet1 based on the sheet2 data.  I do want to use column3,column 6 (string data like "red",Blue") as row field in the pivot table and column 9 as data field. Please explain how to do this.

    Also please explain whether i need to insert all the column data in pivotcachedefinition or not


    Elangovan P


    Friday, December 30, 2011 6:44 AM


All replies