c#
c# - exel write시 셀서식 지정
관절분리
2016. 1. 28. 11:26
반응형
Excel.Range range = xlApp.get_Range("A2", Type.Missing);
range.NumberFormatLocal=@"@";
Excel.Style style=xlBook.Styles.Add("NewStyle",Type.Missing);
style.Interior.ColorIndex=15;
style.Interior.Pattern=Excel.XlPattern.xlPatternSolid;
style.Interior.PatternColorIndex=Excel.XlBackground.xlBackgroundAutomatic;
range.Style=style;
Excel.Range oRange;
oRange = worksheet.get_Range("A1:A300", "C1:C300");
oRange.Cells.NumberFormat = "@";
반응형