Formatting a pivot table

[Erick D Tinajero]

Hi everyone.

I'm having two problems:

A) I've been developing a pivot table over the past few days, and I've come
across the problem of formatting it. Unlike Excel's Dynamic Tables, I've not
been able to set a background color to certain cells in the pivot table,
like the Totals.

Is there any possible way to do that?

B) Assuming there is no way to format said pivot tablet, I've thought of a
possible solution but I am not sure if this particular scenario is actually
possible. I've got a dynamic table that represents what I want to get from
the pivot table. The difference being that the dynamic table was made
directly over Excel, while the pivot table is dinamically populated with
ASP.NET. This dynamic table is correctly formatted, though.

Is there any way to load up that dynamic table, either with a Spreadsheet or
a Pivottable control?

Thanks in advance for any help.

 

[Alvin Bruney [MVP]]

Have a look at the pivotcell object to see if it contains a writable
background color setting, you can use that if it does.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley