/// <summary> /// /// </summary> /// <param name="_WorkSheet"></param> public static void WriteDataToExcelFileDasicInput(excel.Worksheet _WorkSheet, CBasicInput g_BasicInput) { _WorkSheet.get_Range("I63", Type.Missing).Value2 = g_BasicInput.get통신사(); _WorkSheet.get_Range("C63", Type.Missing).Value2 = g_BasicInput.get지역(); _WorkSheet.get_Range("E63", Type.Missing).Value2 = g_BasicInput.get대리점(); _WorkSheet.get_Range("G63", Type.Missing).Value2 = g_BasicInput.get마케터(); //도매 _WorkSheet.get_Range("F7", Type.Missing).Value2 = g_BasicInput.get도매_누적가입자수(); _WorkSheet.get_Range("F8", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_신규(); _WorkSheet.get_Range("F9", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_기변(); _WorkSheet.get_Range("F10", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_소계(); _WorkSheet.get_Range("F11", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_LG(); _WorkSheet.get_Range("F12", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_SS(); _WorkSheet.get_Range("F13", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_소계(); _WorkSheet.get_Range("F14", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_개통사무실(); _WorkSheet.get_Range("F16", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_판매점(); _WorkSheet.get_Range("F17", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_소계(); _WorkSheet.get_Range("F18", Type.Missing).Value2 = g_BasicInput.get도매_직원수_간부급(); _WorkSheet.get_Range("F19", Type.Missing).Value2 = g_BasicInput.get도매_직원수_평사원(); _WorkSheet.get_Range("F20", Type.Missing).Value2 = g_BasicInput.get도매_직원수_소계(); //소매 _WorkSheet.get_Range("G8", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_신규(); _WorkSheet.get_Range("G9", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_기변(); _WorkSheet.get_Range("G10", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_소계(); _WorkSheet.get_Range("G15", Type.Missing).Value2 = g_BasicInput.get소매_거래선수_직영점(); _WorkSheet.get_Range("G17", Type.Missing).Value2 = g_BasicInput.get소매_거래선수_소계(); _WorkSheet.get_Range("G18", Type.Missing).Value2 = g_BasicInput.get소매_직원수_간부급(); _WorkSheet.get_Range("G19", Type.Missing).Value2 = g_BasicInput.get소매_직원수_평사원(); _WorkSheet.get_Range("G20", Type.Missing).Value2 = g_BasicInput.get소매_직원수_소계(); //합계 _WorkSheet.get_Range("H7", Type.Missing).Value2 = g_BasicInput.get누적가입자수_합계(); _WorkSheet.get_Range("H8", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_신규_합계(); _WorkSheet.get_Range("H9", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_기변_합계(); _WorkSheet.get_Range("H10", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_소계_합계(); _WorkSheet.get_Range("H11", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_LG_합계(); _WorkSheet.get_Range("H12", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_SS_합계(); _WorkSheet.get_Range("H13", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_소계_합계(); _WorkSheet.get_Range("H14", Type.Missing).Value2 = g_BasicInput.get거래선수_개통사무실_합계(); _WorkSheet.get_Range("H15", Type.Missing).Value2 = g_BasicInput.get거래선수_직영점_합계(); _WorkSheet.get_Range("H16", Type.Missing).Value2 = g_BasicInput.get거래선수_판매점_합계(); _WorkSheet.get_Range("H17", Type.Missing).Value2 = g_BasicInput.get거래선수_소계_합계(); _WorkSheet.get_Range("H18", Type.Missing).Value2 = g_BasicInput.get직원수_간부급_합계(); _WorkSheet.get_Range("H19", Type.Missing).Value2 = g_BasicInput.get직원수_평사원_합계(); _WorkSheet.get_Range("H20", Type.Missing).Value2 = g_BasicInput.get직원수_소계_합계(); }