Jump to content

getting excel color index of a range onto an array


Rishav
 Share

Recommended Posts

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?

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