Jump to content

Open Office _OOoCalc_WriteCell Problem


 Share

Recommended Posts

Hi All

Trying to use the Open office excel automation include and having trouble with the the _OOoCalc_WriteCell function

#include <OOoCOM_UDF_v08.au3>
; Script Start - Add your code below here

Local $file = @ScriptDir & "\Attrib-Detailed-EP2013.csv" ;This file should already exist
Local $oExcel = _OOoCalc_Open($file)

_OOoCalc_WriteCell($oExcel, 0,"Something to write in cell",1,1)



 _OOoCalc_Close($oExcel)

Get an error of :

$SheetComponent = $Sheets.GetByName($Worksheet)
$SheetComponent = $Sheets.GetByName($Worksheet)^ ERROR

Tried referencing the worksheet as '0' , '1' and 'Sheet1'

What am I doing wrong here ?

Thanks

Paul

Firefox's secret is the same as Jessica Simpson's: its effortless, glamorous style is the result of — shhh — extensions!

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...