Read Data from Excel and fill that data into other field.

[Tushar]

I want to read data from excel file and put that data into some other desktop automate field....How i do it plzz help

[Jos]

Search function broken?
Did you open the helpfile and search for Excel ? 

Jos

[Tushar]

Yes I open but there is no such function which copy the excel data into field

 

[Jos]

Yes there is: _Excel_RangeRead()  

[Danp2]

Excel_RangeRead() will retrieve the data from Excel. The solution for moving the data into the external application will depend on the target. Can you tell us more about the target application?

[Tushar]

The target location is the mouse coordinates of that position...How will I put that data into that mouse coordinates ? 

RangeRead() function is not helpful in that situation.

 

[Tushar]

This is my sample code to copy the data from excel and paste it into mouse coordinate 

#include<Excel.au3>

Local $oExcel_1= _Excel_Open()
Local $sWorkbook="C:\Users\Tushar Verma\Desktop\AUTO IT\Test.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)

WinActivate($oWorkbook)

Local $read1=_Excel_RangeRead($oWorkbook,Default,"B1")

;Now paste that into some mouse coordinates. How I do it?

 

[Tushar]

is there anyone who solve this query ?

[water]

We do not know which application you want to paste the data to. So I suggest to use _Excel_RangeCopyPast to copy the Excel data to the clipboard and then send the keys to the selected applications to paste the date (like ctrl+v)

[Tushar]

@water

Could you please give me the sample script. I m new into autoit and find it difficult to do.

Thanks in advance.

[water]

I see that you are new here. But you have to show some effort yourself. We do not spoon feed code to users.

First step: Add _Excel_RangeCopyPaste to your script
Second Step: Post your script so we can check the code
Third step: Tell us which application you need to paste the data to. If there are multiple applications then please tell us which application you use most.

[Jos]

1 hour ago, Tushar said:

is there anyone who solve this query ?

Also please be a little patient and do not bump your post within 24 hours unless you have payed for your 1 hour SLA service contract.  

Edited April 14, 2022 by Jos

[Tushar]

@water 

Sorry for this...I m using outlook application to paste my data.

My code is this...

expandcollapse popup

#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_UseX64=n
#EndRegion ;**** Directives created by AutoIt3Wrapper_GUI ****
#include <AutoItConstants.au3>
#include <MsgBoxConstants.au3>

#include<Excel.au3>


Example()

HotKeySet("+!d", "Terminate");  shift-alt-d

Func Example()

Local $oExcel_1= _Excel_Open()
Local $sWorkbook="C:\Users\Tushar Verma\Desktop\AUTO IT\Test.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)

WinActivate($oWorkbook)
Sleep(3000)
$read1=_Excel_RangeCopyPaste($oWorkbook,Default,"B1:B3")
MsgBox(0,"Read",$read1)

   Local $iPID = Run("C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE");
   Sleep(10000);

   MouseClick("left",944,89);

   Sleep(10000);


   MouseClick("left",241,208);
   Sleep(5000);

   MouseClick("left",1148,647,12);
   Sleep(5000);
   MouseClick("left",739,357);
   Sleep(5000);
   MouseClick("left",744,429);
   Sleep(5000);

   ControlFocus("Choose File to Upload","","Edit1");
   ControlSetText("Choose File to Upload","","Edit1","C:\Users\Tushar Verma\Desktop\Add-in File\Pinnable_CRM");
   ControlClick("Choose File to Upload","","Button1");
   Sleep(5000);
   MouseClick("left",638,294);
   Sleep(8000);

   MouseClick("left",1133,71);
   Sleep(5000);
   MouseClick("left",370,686);
   Sleep(10000);
   MouseClick("left",1078,90);
   Sleep(10000);
    MouseClick("left",1097,483);
    Sleep(1000);
    Send("Username");
    Sleep(2000);
    Send("{TAB}");
    Sleep(2000);
    Send("Password");
    Sleep(2000);
    MouseClick("left",1188,655);
    Sleep(10000);
    MouseClick("left",1328,180);
    Sleep(2000);

   MouseClick("left",160,678);  ;Task
   Sleep(2000);

   MouseClick("left",26,88);
   Sleep(2000);

   If WinActivate("Untitled - Task","") Then
        ControlClick("Untitled - Task","","RichEdit20WPT3");
        ;At this location I wanted to paste the copied excel data. and I don't know how I solve this step.

Thanks in advance.

 

how to post code

Edited April 14, 2022 by Jos
Please use Code box for source ;)

[water]

You know that there is an Outlook UDF?
This means you do not have to automate the Outlook GUI but simply call functions as you do with Excel.
What do you try to do with Outlook? Create an email, a contact ...?

Edited April 14, 2022 by water

[Tushar]

I want to automate the outlook with the 3rd party application to create some task in outlook.

 

[water]

Is my understanding correct that you want to

1. Extract data from Excel
2. Create a Task in Outlook with data from Excel
3. I'm not sure about this: Grab some data from Pineapple CRM and add this to the Task. Maybe this is done by a Pineapple Outlook Add in?

1. and 2. can easily be done using the Excel and OutlookEX UDF. But I'm not sure about 3.

Can you please tell us if I'm correct and what Pineapple exactly does in creating a Task?

 

[Tushar]

Yes Pinnable CRM is an add-in file which I used to add in Outlook. How I achieve the Part-2 Could you please tell me.

Thanks in advance.

[water]

If the Pineapple Outlook addin provides a COM interface I suggest to use COM to create a task.
Else I suggest to use AutoIt's Control* functions to automate the Outlook GUI. Send and Mouse* functions are not very reliable as they depend on screen resolution, window position and might interfere with user actions.

[Nine]

Or you could use UIAutomation  to perform the action in Pineapple OUtlook...