Data table

[deviprasad]

i am using a window based application.auto it spy is able to spy the datatable control but i dont know how to retrive the data from the data table. i need to select a value from the data table.

following are the summry of the cotrol

==============================

>>>> Window <<<<
Title:    Archive List
Class:    #32770
Position:    455, 143
Size:    594, 386
Style:    0x94CC004C
ExStyle:    0x00010100
Handle:    0x00000000000711CA

>>>> Control <<<<
Class:    DataTbl
Instance:    1
ClassnameNN:    DataTbl1
Name:    
Advanced (Class):    [CLASS:DataTbl; INSTANCE:1]
ID:    503
Text:    
Position:    7, 81
Size:    555, 217
ControlClick Coords:    189, 73
Style:    0x500301FD
ExStyle:    0x00000004
Handle:    0x00000000004308B2

>>>> Mouse <<<<
Position:    659, 327
Cursor ID:    0
Color:    0xFFFFFF

>>>> StatusBar <<<<

>>>> ToolsBar <<<<

>>>> Visible Text <<<<
Company

 

it will be llay help ful if any body can help me on this

[water]

Welcome to AutoIt and the forum!

What have you coded so far?

[deviprasad]

nothing, i am not finding any idea how to do a action on this table

[water]

Try

ControlGetData("Archive List", "", " [CLASS:DataTbl; INSTANCE:1]")

Do you want to retrieve the whole datatable or only a selected item?

[deviprasad]

can i retrive every row from data table and can i select a specific row ?

please help

[water]

What application do you try to automate? Is it an application with a database in the background? It might be easier to directly access the database.

[deviprasad]

no database , actually i need to very the contents of the table each time.

[water]

I searched the forum but didn't find a working solution.

Can you manually copy and paste the content of the datatable to Excel or Notepad?

[deviprasad]

Policy#  Name Status 1 X Active 2 Y Inactive 3 Z Expired            

 

here is the similar kind of structure present in my table application, can i retrive this and write is a exce file?

[deviprasad]

Policy#  Name Status

1            X        Active

2            Y       Inactive

3            Z           Expired 

 

please follw this, ignore the above one

[water]

There are two possible solutions to your problem:

1. Access the datatable control and extract the required data
   Haven't found a way yet. Might not be possible
2. You copy/paste the content of the table to another application and then AutoIt process this data

Have you tried to copy/paste the data from your application?

[deviprasad]

ControlGetData("Archive List", "", " [CLASS:DataTbl; INSTANCE:1]")

this is not working and controlgetdata is not a valid one.

first solution is not working,can we go ahead with solution 1

[deviprasad]

Can any one got the solution for the above concern.Please do help.i stuck from that place

[deviprasad]

IS THERE ANY ALTERNATIVE OF DOING IT

[deviprasad]

THE ALTERNATIVE WAY OF DOIN IS TO GO FOR COORDINATES WILL DO THE ACTION, BUT I DO NT THINK IT WILL BE A BEST PRACTICE

[JLogan3o13]

HOW ABOUT YOU NOT POST IN ALL CAPS

 

Can you please post a screenshot of the policy application, to give us an idea of what you're seeing? That will help us help you. Blank out any sensitive data if you need to.

[deviprasad]

i have attached a data table of the application, which has mulitple records with the chek boxes. and the check boxes are also part of data table. which autoit spy not able to identify individually.do let me know how can i select a check box based on the my prameters.

[deviprasad]

Any updates?

[deviprasad]

Any updates guys