Sign in to follow this  
Followers 0
deviprasad

Data table

19 posts in this topic

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

Share this post


Link to post
Share on other sites



Welcome to AutoIt and the forum!

What have you coded so far?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Try

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

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

please help

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Policy#  Name Status

1            X        Active

2            Y       Inactive

3            Z           Expired 

 

please follw this, ignore the above one

Share this post


Link to post
Share on other sites

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?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

IS THERE ANY ALTERNATIVE OF DOING IT

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

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.

post-80835-0-45175000-1373606638_thumb.p

Share this post


Link to post
Share on other sites

Any updates?

Share this post


Link to post
Share on other sites

Any updates guys

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0