private void BtnGenerateCode_Click(object sender, RibbonControlEventArgs e)
{
Excel.Application app = Globals.ThisAddIn.Application;
Excel.Worksheet sheet = app.ActiveSheet;
if (sheet.UsedRange.Columns.Count < 2 || sheet.UsedRange.Rows.Count < 2)
{
Utils.ShowMessage("시트 데이터가 존재하지 않습니다. 시트 서식화 후 진행하세요.");
}
else
{
string fieldText, columnText;
string code = ColumnGenerator.GenerateCode(sheet, out fieldText, out columnText);
if (!String.IsNullOrEmpty(code))
{
if (this.codeForm == null)
{
codeForm = new CodeForm();
}
codeForm.FieldInfo = fieldText;
codeForm.ColumnInfo = columnText;
codeForm.SourceCode = code;
codeForm.ShowDialog();
}
}
}
private void BtnBuildForm_Click(object sender, RibbonControlEventArgs e)
{
Excel.Application app = Globals.ThisAddIn.Application;
Excel.Worksheet sheet = app.ActiveSheet;
String input = app.InputBox("컬럼 헤더의 세로 개수를 입력하세요", "컬럼 헤더 높이", 1);
int depth = int.Parse(input);
ColumnGenerator.BuildForm(sheet, depth);
}
private void BtnApplyColumnWidth_Click(object sender, RibbonControlEventArgs e)
{
Excel.Application app = Globals.ThisAddIn.Application;
Excel.Worksheet sheet = app.ActiveSheet;
ColumnGenerator.ApplyWidth(sheet);
}
