how to handle pivot table window and its controls using ruby

Discussion in 'Ruby' started by Vamsi Krishna, Aug 20, 2009.

  1. Hi

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

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

    require "win32ole""Excel.Application")
    workbook = excel.Workbooks.Add
    menubar_list=excel.CommandBars("Worksheet Menu Bar").Controls("&Data")
    sleep 1
    pvt=menubar_list.Controls("&PivotTable and PivotChart Report...")

    ******** 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.

    Vamsi Krishna, Aug 20, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.