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