excel documents

[Aceguy]

how do i write to an existing (already opened) excel document....

becase all the examples in the helpfile just manipulate new() or open() one......

_ExcelWriteCell($oExcel, "I Wrote to This Cell", 1, 1)

$oExcel wont exist...

TY

[Authenticity]

Hmm..

Dim $oExcel = _ExcelBookAttach()

..and then maybe

Dim $oSheet = $oExcel.ActiveSheet

depending if _ExcelBookAttach() could successfully attach to the Excel instance.

[Aceguy]

Great, TY....

$oExcel = _ExcelBookAttach("Microsoft Excel - Book1", "Title")

worked for me.....

i must have an outdated Scite helpfile... _ExcelBookAttach didnt show up..

[Authenticity]

Man, I must say that I don't think it should match exactly the title. Why not using just StringInStr, more flexibility in my opinion. Oh, by the way, it returns __Workbooks, so to get the sheet use $oSheet = $oExcel.Application.ActiveSheet.

[Aceguy]

#include <Excel.au3>
$title=WinGetTitle("Microsoft Excel","")

if not $title=0 then
$oExcel = _ExcelBookAttach($title, "Title")

Else
    $oExcel=_excelbooknew()
EndIf

$d=0
Do
$d+=1
$read=  _excelreadcell($oExcel,$d,1)
until $read=""
ConsoleWrite("end of row is "&$d&@lf)

used this to find the last entry in colomn 1..... TY Authenticity

Edited April 2, 2009 by Aceguy