You have to login in order to post a reply to this topic.

4 replies [Last post]
Thyzor
Thyzor's picture
User offline. Last seen 19 hours 51 min ago. Offline
Joined: 02/26/2010
Posts: 27

I recieve several E-mail with attached exel docs. And I want to get the content from diffrent cells and store it in a variable to paste it in a Log program that I use. How do I do this?  I have attached a excel doc so you can see how it looks. The cells can containe 1 row or more... but the cells that i have filled with Yellow is the the one i want to get

Br// Michael

__________________

 //Best Regards Michael

AttachmentSize
excel_test.xls24.5 KB
__________________

 //Best Regards Michael

D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204
Re: Excel question

 The following blog posts might help you:

http://winautomation.com/blog/using-data-excel-part-i
http://winautomation.com/blog/using-data-excel-par...

The 2 essential differences between your job and the job that is being built in these 2 posts are the following:

1) The "Read from Excel" action, should be changed to read from Row no.15 to FirstFreeRow-1, and from Column no.2 to no.9 (of course all modifications should be made accordingly)

2) Instead of placing a "Send Email" action inside the for each loop, you will have to use a Set Clipboard action to set the contents of the various variables into the clipboard and the Send Keys action to send various keystrokes, like {Control}({V}) that allows you to paste the contents of the clipboard.

__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==

Thyzor
Thyzor's picture
User offline. Last seen 19 hours 51 min ago. Offline
Joined: 02/26/2010
Posts: 27
Re: Excel question

Great and thank you for the reply! =)
I will try this method at once

Forgot something. What should i name the Variable to store the content. Can´t use the Launch Excel action bec it´s not a local stored document. I open them directly from Outlook, so the problem is the "Excel Instance" variable ?

__________________

 //Best Regards Michael

__________________

 //Best Regards Michael

D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204
Re: Excel question

 I have just seen the question in your post and I didn't want to leave it unanswered. If you do not use the "Launch Excel" action to open your Excel file, you cannot use any of the actions under the "Excel" category of actions. All actions under "Excel" category require that you specify the "Excel Instance" variable and you can only create the specific variable through the "Launch Excel" action.

If you cannot save the excel file locally, you will have to select the contents of the Excel file store them into the Clipboard and then probably write them in a blank Excel file that you opened through "Launch Excel"

__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==

Thyzor
Thyzor's picture
User offline. Last seen 19 hours 51 min ago. Offline
Joined: 02/26/2010
Posts: 27
Re: Excel question

Thank you for the reply!
Thats what I thought to. Maby the function will be added in a later version of WinAutomation.

__________________

 //Best Regards Michael

__________________

 //Best Regards Michael