Hasher Posted August 25, 2014 Posted August 25, 2014 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!
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now