Borland

Excel 셀에 데이터 넣고 색을 바꾸는 방법

leo21c 2010. 1. 19. 15:32 

void __fastcall FillColorCell(int row, int col, int ColorIndex) 
{ 
  try 
  { 
    Variant cell, column, interior; 

    cell = xlSheet.OlePropertyGet("Cells", row, col); 
    column = cell.OlePropertyGet("Columns"); 
    interior = column.OlePropertyGet("Interior"); 
    interior.OlePropertySet("ColorIndex", ColorIndex); 
    interior.OlePropertySet("Pattern", 1); //1 - xlSolid 
  } 
  catch(...) 
  { 

  } 
}




LIST