Jump to content
Sign in to follow this  
santo

Excel To word

Recommended Posts

santo

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
water

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 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
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  

×