There is a time for all good things to come to an end, and the time has come to shut down OpenXmlDeveloper.org.
Screen-casts and blog posts: Content on OpenXmlDeveloper.org will be moving to EricWhite.com.
Forums: We are moving the forums to EricWhite.com and StackOverflow.com. Please do not post in the forums on OpenXmlDeveloper.org. Instead, please post in the forums at EricWhite.com or at StackOverflow.com.
Please see this blog post for more information about my plans moving forward. Cheers, Eric
This page has been moved. You can find this content at the following link: Creating Pivot Tables, Part 3
OpenXmlDeveloper.org is shutting down as an active site. See this blog post at EricWhite.com for more information.
Bob, I'm definitely interested in the code to add rows, columns, filters, and data values. Where can I download a copy of this solution (Part 3) ?
What Visual Studio 2010 PowerTool add-in are you using to view the *.xlsx files ? Where can I get it ?
Hello Bob, thanks for your recent blog posts covering pivot tables. Very useful and interesting! I'm also definitely very interested in the code to add rows, columns and data values. Is there also a way to refresh the pivot table without excel? I have to update the values existing in pivot tables with the values from a xml source file. Another way would also be like you've explained to create new pivot tables.
Thanks in advance!
There is a way to refresh without excel. The records cache would have to be updated after the source data is updated. The difficulty is that Excel encodes all or most of the string values, so the code is more complex than what I have shown so far. However, I would deal with that encoding to do any of the code for adding rows, columns, filters and data values to the pivot table.
Eric White has an excellent screen-cast about getting started with Open XML development. Part 2 mentions how to get the Package Editor for Visual Studio. Here is the link: openxmldeveloper.org/.../getting-started-with-open-xml-development-part-ii-tools.aspx
There was a problem with this example when using Excel 2010. The correction has been made to PowerTools Core 2.2.2. I have a detailed explanation of the problem and correction here: openxmldeveloper.org/.../creating-pivot-tables-updated.aspx
This example looks at a couple of OpenXML spreadsheet topics. I have been working with the cell styles
Could you provide the url where I can found the sample code for creating pivot table(part 3)