Jump to content
Sign in to follow this  
Hasher

Open Office _OOoCalc_WriteCell Problem

Recommended Posts

Hasher

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!

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  

×