Hawkwing Posted May 29, 2009 Share Posted May 29, 2009 _excelwritesheetfromarray gives me an error when writing this array to an excel file. a1 a2, b2 a3, b3, c3 a4, b4, c4, d4 This is the error C:\Program Files\AutoIt3\beta\Include\Excel.au3 (571) : ==> The requested action with this object has failed.: $oExcel.Activesheet.Cells($iStartRow, $iCurrCol).Value = $aArray[$r][$c] $oExcel.Activesheet.Cells($iStartRow, $iCurrCol)^ ERROR Can I fix this, or is there an alternative way to write a 2 dimensional array to excel? The Wheel of Time turns, and Ages come and pass, leaving memories that become legend. Legend fades to myth, and even myth is long forgotten when the Age that gave it birth comes again. Link to comment Share on other sites More sharing options...
Malkey Posted May 30, 2009 Share Posted May 30, 2009 _excelwritesheetfromarray gives me an error when writing this array to an excel file. a1 a2, b2 a3, b3, c3 a4, b4, c4, d4 This is the error C:\Program Files\AutoIt3\beta\Include\Excel.au3 (571) : ==> The requested action with this object has failed.: $oExcel.Activesheet.Cells($iStartRow, $iCurrCol).Value = $aArray[$r][$c] $oExcel.Activesheet.Cells($iStartRow, $iCurrCol)^ ERROR Can I fix this, or is there an alternative way to write a 2 dimensional array to excel?The example from the help with your array works ok. ; *************************************************************** ; Example 1 - After opening a workbook and returning its object identifier. Declare a 2-D Array, then input the Array ; ***************************************************************** #include <Excel.au3> Local $oExcel Local $oExcel = _ExcelBookNew();Create new book, make it visible ;Declare the Array Local $aArray[4][4] = [["a1", "", "", ""],["a2", "b2", "", ""],["a3", "b3", "c3", ""],["a4", "b4", "c4", "d4"]];0-Base Array _ExcelWriteSheetFromArray($oExcel, $aArray, 1, 1, 0, 0);0-Base Array parameters MsgBox(0, "Exiting", "Press OK to Exit") ;_ExcelBookSaveAs($oExcel, @TempDir & "\Temp.xls", "xls", 0, 1); Now we save it into the temp directory; overwrite existing file if necessary _ExcelBookClose($oExcel); And finally we close out ; Link to comment Share on other sites More sharing options...
Hawkwing Posted May 30, 2009 Author Share Posted May 30, 2009 (edited) Hmm, that works for me too. Is there an error in this script thats making it not work then?http://www.autoitscript.com/forum/index.php?showtopic=95618 Edited June 2, 2009 by pigeek The Wheel of Time turns, and Ages come and pass, leaving memories that become legend. Legend fades to myth, and even myth is long forgotten when the Age that gave it birth comes again. Link to comment Share on other sites More sharing options...
Hawkwing Posted June 2, 2009 Author Share Posted June 2, 2009 bump The Wheel of Time turns, and Ages come and pass, leaving memories that become legend. Legend fades to myth, and even myth is long forgotten when the Age that gave it birth comes again. Link to comment Share on other sites More sharing options...
PsaltyDS Posted June 2, 2009 Share Posted June 2, 2009 Note the remarks in the help file about row and column 0 not being used in the array, because Excel uses 1-based numbering. Also, you created the workbook invisible, so how did you expect to debug it? With all the irrelevant stuff removed, this works: #include <Array.au3> #include <Excel.au3> Dim $array[5][5] = [[5, 5], ["", "a1"], ["", "a2", "b2"], ["", "a3", "b3", "c3"], ["", "a4", "b4", "c4", "d4"]] _ArrayDisplay($array, "Debug: $array") arraytoexcel() Func arraytoexcel() $excelfile = _ExcelBookNew() _ExcelWriteSheetFromArray($excelfile, $array, 1, 1) EndFunc ;==>arraytoexcel Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
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