怎么判断Excel表格的颜色?(20分)

C

caoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-08

• #1

一个Excel表,怎么把有颜色填充的几行挑选出来?

 

S

starpc

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-23

• #2

if Excel.Worksheets[1].cells[3,1].Interior.ColorIndex:=41 then //如果第三行为蓝色
ColorIndex可查help

 

C

caoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-02-05

• #3

接受答案了.