Sign in to follow this  
Followers 0
olo

Open pdf read table of data. Then sort data into 2 rows in excel

4 posts in this topic

Hi,

Im new here and new to scripting altogether...

I have a datasheet for a piece of equipment that I can open using autoit.

But I am having trouble navigating to the "power consumption" table in the document.

After I reach there I have to copy the data into excel. With the captions of the data on top on 1 row, and the actual data on another row below, row 1.

Any suggestions please? As Im really stuck and am not the most competent programmer.... :(

Share this post


Link to post
Share on other sites



any functions or methods that could point me in the right direction?

Share this post


Link to post
Share on other sites

perhaps post some sample code you have written to get the ball rolling here.

you can look at _ExcelBookOpen, _ExcelWriteArray in the help file for those excel command.

Share this post


Link to post
Share on other sites

Maybe you could use some tool like 'pdf2txt'.


Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the Universe
trying to produce bigger and better idiots.
So far, the Universe is winning.

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