Trey

Reading data from pbBody table / Salesforce

2 posts in this topic

#1 ·  Posted

I am attempting to copy data from a table in Salesforce into Excel (using AutoIT). 

I have no idea where to start in how to do this - the table is in an <div class ="pbBody">

An example row of data looks like this (screenshot attached). 

<!-- ListRow -->
<tr class=" dataRow even first" onblur="if (window.hiOff){hiOff(this);}" onfocus="if (window.hiOn){hiOn(this);}" onmouseout="if (window.hiOff){hiOff(this);}" onmouseover="if (window.hiOn){hiOn(this);}"><td class='actionColumn'><a href="/abcdef" class="actionLink" title="Edit - Record 1 - View">Edit</a></td><th scope="row" class=" dataCell  "><a href="/abcdefghijkl" target="_parent">View</a></th><td class=" dataCell  ">EXAMPLE NAME</td><td class=" dataCell  ">123456</td><td class=" dataCell  ">2345678901</td><td class=" dataCell  ">Not Valid</td><td class=" dataCell  numericalColumn">1.123</td><td class=" dataCell  booleanColumn"><img src="/img/checkbox_unchecked.gif" alt="Not Checked" width="21" height="16" class="checkImg" title="Not Checked" /></td><td class=" dataCell  booleanColumn"><img src="/img/checkbox_unchecked.gif" alt="Not Checked" width="21" height="16" class="checkImg" title="Not Checked" /></td><td class=" dataCell  booleanColumn"><img src="/img/checkbox_checked.gif" alt="Checked" width="21" height="16" class="checkImg" title="Checked" /></td></tr>

 

 

screenshot.png

Share this post


Link to post
Share on other sites



#2 ·  Posted

Welcome, start reading on the _IE* functions in the helpfile to get your script started and report back in case of questions.

Jos


Visit the SciTE4AutoIt3 Download page for the latest versions  - Beta files                                How to post scriptsource        Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

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