[C#] Excel 다루기 - 셀 크기 조절, 색 입히기, 셀 선택

Colored By Color Scripter™

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

/*          * 함수명 Select_Cell          * 하나의 셀만 선택하기 위함          */         public void Select_Cell(string cell)         {             xlRng = xlWorkSheet.Range[cell, misValue];         }           /*          * 함수명 Select_Cell          * 여러 셀 범위 선택위한 함수로써 시작 cell부터 마지막 cell 까지ㅊ          */         public void Select_Cell(string strcell, string endcell)         {             xlRng = xlWorkSheet.Range[strcell, endcell];         }           /*          * 함수명 Set_CellColor          * 선택한 셀이 존재할때 색을 지정하는 함수          * 원하는 색의 칼라를 입력한다.          */         public void Set_CellColor(Color color, int row, int col)         {             xlRng = xlRng.get_Resize(row, col);             xlRng.Interior.Color = ColorTranslator.ToOle(color);         }           /* 함수명 SetColWidth          * 입력인자 : range의 범위 2개, 열의 너비          */         public void SetColWidth(string left_up, string right_dn, double col_width)         {             xlRng = xlWorkSheet.get_Range(left_up, right_dn);             xlRng.ColumnWidth = col_width;         }           /* 함수명 SetRowHeight          * 입력인자 : range의 범위 2개, 행의 높이          */         public void SetRowHeight(string left_up, string right_dn, double row_height)         {             xlRng = xlWorkSheet.get_Range(left_up, right_dn);             xlRng.ColumnWidth = row_height;         }