Automating Pivot Table Excel

Hello everybody!

Can you help me?

I’m trying to integrate ruby with excel’s pivot table, and i’m failing,
because i don’t know how to do that. I’ve done a lot of research, and
nothing seems to help.

Could you guys provide any documentation where i can find anything
related to pivot tables?

I’m using win32ole class.

The only thing i wanna do is change a pivot table’s datasource.

Thanks since now.

Daniel Sanches.