Help with pasting data to excel from notepad - (Moved)

[Rskm]

Hi, I have 5 notepad files with lot of data in each of it. The data are arranged in lines and i wish to get it pasted/copied into excel.  Say, i need to read notepad1 and paste the contents into sheet1 of excel and notepad2 to sheet2 and so on.  If i read the notepad and paste it line by line, it is taking lot of time.  Is there a way by which i can paste the whole of notepad file into excel sheet(and get it pasted line by line as shown in the attached excel), instead of using code to write it line by line?.. I was using Filewriteline(data, line i) initially to write to excel.  The 'i' value was incremented with for loop and the excel was updated, but this takes lot of time.  The expected excel format is attached here.  any help is appreciated.  thanks

Tmp.xlsFetching info...

[water]

It's as simple as this:

#include <Excel.au3>
Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookNew($oExcel)
$aData = FileReadToArray("C:\Local\Test\Test.txt")
_Excel_RangeWrite($oWorkbook, 1, $aData)

Replace _Excel_BookNew with _Excel_BookOpen to open your existing workbook.
In _ExcelRangeWrite you can specify where to write the data to.

[Jos]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

  Quote

General development and scripting discussions.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Expand  

Moderation Team

[Rskm]

thanks.. it is solved