Rishav Posted October 15, 2009 Posted October 15, 2009 Hido folks I know how to get the excel color index on a cell by cell basis. I was currently trying to get the color index off a whole excel range and put it in an array #include <Array.au3> #include <Excel.au3> $File1 = FileOpenDialog("Select Excel", "", "xls (*.xls)") $oExcel1 = _ExcelBookOpen($File1, 0) $ExcelArray1 = _ExcelReadSheetToArray($oExcel1) ; Create new array with proper size. Dimensions are same as the array created from the excel Dim $ArrayColor1[$ExcelArray1[0][0] + 1][$ExcelArray1[0][1] + 1] $ArrayColor1 = $oExcel1.Activesheet.Range("A1:T20").Interior.ColorIndex _ArrayDisplay($ArrayColor1) _ExcelBookClose($oExcel1, 0) But my code is not working. Any help?
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