Sign in to follow this  
Followers 0
santo

Excel To word

2 posts in this topic

Hi,

I am fairly new to autoit aswellas programming

#include <Excel.au3>

Global $i=1,$j

$path=@ScriptDir & "\Book1.csv"

$sFilePath1 = "C:\autoit\Book1.csv" ;This file should already exist

$oExcel = _ExcelBookOpen($path)

Sleep(5000)

If @error = 1 Then

MsgBox(0, "Error!", "Unable to Create the Excel Object")

Exit

ElseIf @error = 2 Then

MsgBox(0, "Error!", "File does not exist - Shame on you!")

Exit

EndIf

For $j=1 To 12 Step +1

$val=_ExcelReadCell($oExcel,$i,$j)

Sleep(5000)

$oExcel.visible=0

run("notepad.exe")

sleep(10000)

Send($val)

Send("{ENTER}")

Next

i use this code to read the datas stored in my csv file into notepad but the datas are written one by one on different notepads ,

I want to write all datas into one notepad ,Where i can modify the code for this purpose?please help.

Share this post


Link to post
Share on other sites



You need something like this. Be sure to change variable $sWindowTitle to the title of your Notepad window!

#include <Excel.au3>

Global $i = 1, $j, $sWindowTitle = "Unbenannt - Editor"
$path = @ScriptDir & "\Book1.csv"
$sFilePath1 = "C:\autoit\Book1.csv" ;This file should already exist
$oExcel = _ExcelBookOpen($path, 0)
If @error = 1 Then
    MsgBox(0, "Error!", "Unable to Create the Excel Object")
    Exit
ElseIf @error = 2 Then
    MsgBox(0, "Error!", "File does not exist - Shame on you!")
    Exit
EndIf
Run("notepad.exe")
WinWait($sWindowTitle)
For $j = 1 To 12 Step +1
    $val = _ExcelReadCell($oExcel, $j, $i)
    WinActivate($sWindowTitle)
    Send($val & @LF)
Next

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

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