[C#/COMMON] 엑셀 템플릿(EXCEL Template) 로드하기

■ 엑셀 템플릿(EXCEL Template)을 로드하는 방법을 보여준다.

▶ 예제 코드 (C#)


using Excel = Microsoft.Office.Interop.Excel;

...

string excelTemplateFilePath = @"C:\Templates\TestTemplate.xlt";

Excel.Application excelApplication = null;
Excel._Workbook   excelWorkBook    = null;

excelApplication = new Excel.Application();

excelWorkBook = excelApplication.Workbooks.Open
(
    excelTemplateFilePath,
    0,
    false,
    5,
    "",
    "",
    false,
    Excel.XlPlatform.xlWindows,
    "",
    true,
    false,
    0,
    true,
    false,
    false
);

...

Excel._Worksheet excelWorkSheet = null;

excelWorkSheet = excelWorkBook.ActiveSheet as Excel._Worksheet;

excelWorkSheet.Cells[2, 2] = "Text";

using Excel = Microsoft.Office.Interop.Excel;

...

string excelTemplateFilePath = @"C:\Templates\TestTemplate.xlt";

Excel.Application excelApplication = null;

Excel._Workbook excelWorkBook = null;

excelApplication = new Excel.Application();

excelWorkBook = excelApplication.Workbooks.Open

(

excelTemplateFilePath,

false,

"",

false,

Excel.XlPlatform.xlWindows,

"",

true,

false,

true,

false,

false

);

...

Excel._Worksheet excelWorkSheet = null;

excelWorkSheet = excelWorkBook.ActiveSheet as Excel._Worksheet;

excelWorkSheet.Cells[2, 2] = "Text";

※ 참조 관리자 대화 상자에서 COM / 형식 라이브러리에서 "Microsoft Excel 14.0 Object Library"를 참조한다.