// --------------------------------------------------------------------------------------------------------------------------------------

// Export to excel

// --------------------------------------------------------------------------------------------------------------------------------------

private string ExportAdmissionForm(ArrayList resTesters, string fileTemplate, string testName) {
    Excel.Application objExcel = null;
    Excel.Workbook objBook = null;
    Excel.Worksheet objSheetAdminForm = null;
    int error = 0;
    int success = 0;
    try
    {
       objExcel = new Microsoft.Office.Interop.Excel.Application();
       objExcel.Visible = false;
       objExcel.DisplayAlerts = false;
       objBook = (Excel.Workbook)objExcel.Workbooks.Open(fileTemplate, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 0, true);
       objSheetAdminForm = (Excel.Worksheet)objBook.Sheets["Sheet1"];

       for (int i = 0; i < resTesters.Count; i++) {
          int col = 1;
          int rowAdminNo = 10;

          if (string.IsNullOrEmpty(tester.administration_code)){
              continue;
           }
           string fileExport = Path.GetFullPath(Properties.Settings.Default.ReportDir + "/" + testName + @"\Admission_Forms");
           if (!Directory.Exists(fileExport)) { Directory.CreateDirectory(fileExport); }
           fileExport += @"\" + tester.administration_code + ".xls";
           objSheetAdminForm.Cells[rowAdminNo, col] = "Administration No.: " + tester.administration_code;
           success++;
           objBook.SaveAs(fileExport, Excel.XlFileFormat.xlWorkbookNormal, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
}
}
catch (Exception ex)
{
     error++;
     _logger.Debug("ADMISSION FORM: ", ex);
}
finally
{
     objExcel.Workbooks.Close();
     objSheetAdminForm = null;
     objBook = null;
     objExcel.Quit();
     objExcel = null;
    GC.Collect();
}
string res = string.Format(" {0} sucess. {1} error.", success, error);
return res;
}