Jump to content

excel documents


Recommended Posts

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

Link to comment
Share on other sites

#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)

:D

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

Edited by Aceguy
Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...