C# excel. Collapsing pivot table fields

Question

0.00/5 (No votes)

See more:

Hello Guys :)

I got another issue with C# - I am looking for a way of collapsing pivot table fields. Generally situation is as follows:

http://i45.tinypic.com/cnx37.jpg[^]

I know that in VBA it can be done by this peace of code:

VB

ActiveSheet.PivotTables("PivotTableName").PivotFields("PivotFieldName").ShowDetail = False

Does anyone have an idea how it can be done with a C#?

I've already looked at MSDN, but it hardly gives a good example. Other sources also gave nothing to kick-start...

Thanks a lot in advance!

Posted 4-Apr-13 20:43pm

MK-Gii

Updated 4-Apr-13 21:35pm

Maciej Los

v4

Add a Solution

Comments

Maciej Los 5-Apr-13 3:34am

What have you done till now?

MK-Gii 5-Apr-13 3:51am

I have read a bunch of pages in MSDN and other forums. Looks like nobody has been trying to do this before... Overarly it looks like a simple tasks, but still strugling to find the right function to do it...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kenneth Haugland · Accepted Answer · 2013-04-04T22:09:00

Solution 1

Since you gave the VBA code im going to assume that it can be done this way:

        Excel.Application oXL;
	Excel._Workbook oWB;
	Excel._Worksheet oSheet;
	Excel.Range oRng;

	try
	{
		//Start Excel and get Application object.
		oXL = new Excel.Application();
		oXL.Visible = true;

		//Get a new workbook.
		oWB = (Excel._Workbook)(oXL.Workbooks.Add( Missing.Value ));
		oSheet = (Excel._Worksheet)oWB.ActiveSheet;
                oSheet.PivotTables("PivotTableName").PivotFields("PivotFieldName").ShowDetail = False
/pre>

Posted 4-Apr-13 22:09pm

Kenneth Haugland

Comments

MK-Gii 5-Apr-13 5:20am

Worked like a charm - you're 'ma man!

Kenneth Haugland 5-Apr-13 5:57am

If you have the VBA code you can, at leat to my knowlage, always solve the problems using simular techniques:-)

MK-Gii 5-Apr-13 6:12am

Good hint. Didn't even thought about this actually ;] Now I'll try that approach in the future before overburding you guys with dummy questions x]