# How to handle pivot table window and its controls using ruby

**URL:** <https://www.ruby-forum.com/t/how-to-handle-pivot-table-window-and-its-controls-using-ruby/174072>\
**Category:** Ruby\
**Created:** [August 20, 2009, 11:57am UTC](https://www.ruby-forum.com/t/how-to-handle-pivot-table-window-and-its-controls-using-ruby/174072 "2009-08-20T11:57:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vamsi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b38774/32.png) [@vamsi](https://www.ruby-forum.com/u/vamsi)\
**Post date:** [August 20, 2009, 11:57am UTC](https://www.ruby-forum.com/t/how-to-handle-pivot-table-window-and-its-controls-using-ruby/174072/1 "2009-08-20T11:57:00Z")

</div>

Hi

i want to handle the PivotTable window and its controlls like radio  
buttons and buttons in excel using ruby.

i tried but no luck.is there any tutorial or can any one help me out.

require “win32ole”  
excel=WIN32OLE.new(“Excel.Application”)  
excel.visible=true  
workbook = excel.Workbooks.Add  
menubar\_list=excel.CommandBars(“Worksheet Menu Bar”).Controls("&Data")  
menubar\_list.Execute  
sleep 1  
pvt=menubar\_list.Controls("&PivotTable and PivotChart Report…")  
pvt.Execute

\*\*\*\*\*\*\*\* Need to handle the PivotTable and PivotChart Report window and  
its controls (radio buttons and buttons )for the 3 steps of PivotTable  
and PivotChart Report window.

Thanks  
Vk.