private void FillPharmacotraffickingDataRow(ExcelWorksheet ws, int rowIndex, vw_TPL_Assays item)
        {
            int colIndex = 1;

            SetCellValue(ws, rowIndex, colIndex, item.TARGET, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.DESCRIPTION, ExcelHorizontalAlignment.Left);

            SetCellValue(ws, rowIndex, ++colIndex, item.CellLinePN);
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT != null && item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT == "gpcrELECT") ? "X" : "");
        }
        private void FillInCELLHunterDataRow(ExcelWorksheet ws, int rowIndex, vw_TPL_Assays item)
        {
            int colIndex = 1;

            SetCellValue(ws, rowIndex, colIndex, item.TARGET, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.DESCRIPTION, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.CellPoolPN);
            SetCellValue(ws, rowIndex, ++colIndex, item.CellLinePN);
            SetCellValue(ws, rowIndex, ++colIndex, item.ExpressKitPN);
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT != null && item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT.Contains("ICH ELECT")) ? "X" : "");
        }
        private void FillNHRDataRow(ExcelWorksheet ws, int rowIndex, vw_TPL_Assays item)
        {
            int colIndex = 1;

            SetCellValue(ws, rowIndex, colIndex, item.TARGET, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.DESCRIPTION, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.CellBackGround);
            SetCellValue(ws, rowIndex, ++colIndex, item.CellLinePN);
            SetCellValue(ws, rowIndex, ++colIndex, item.ExpressKitPN);
            SetCellValue(ws, rowIndex, ++colIndex, item.PROF_COMMERCIAL_NAME_PANEL == "nhrMAX" ? "X" : "");
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT != null && item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT == "nhrELECT") ? "X" : "");
        }
        private void FillPathwayDataRow(ExcelWorksheet ws, int rowIndex, vw_TPL_Assays item)
        {
            int colIndex = 1;

            SetCellValue(ws, rowIndex, colIndex, item.TARGET, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.DESCRIPTION, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.Assay_Measures, ExcelHorizontalAlignment.Left);

            SetCellValue(ws, rowIndex, ++colIndex, item.CellLinePN);
            SetCellValue(ws, rowIndex, ++colIndex, item.ExpressKitPN);
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT != null && item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT == "pathELECT") ? "X" : "");
        }
        private void FillOrphanGPCRDataRow(ExcelWorksheet ws, int rowIndex, vw_TPL_Assays item)
        {
            int colIndex = 1;

            SetCellValue(ws, rowIndex, colIndex, item.TARGET, ExcelHorizontalAlignment.Left);
            SetCellValue(ws, rowIndex, ++colIndex, item.GenBankAccessionNumber);
            SetCellValue(ws, rowIndex, ++colIndex, item.CellBackGround);

            SetCellValue(ws, rowIndex, ++colIndex, item.CellLinePN);
            SetCellValue(ws, rowIndex, ++colIndex, item.Ligand);
            SetCellValue(ws, rowIndex, ++colIndex, item.ExpressKitPN);
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PANEL != null && item.PROF_COMMERCIAL_NAME_PANEL == "orphanMAX") ? "X" : "");
            SetCellValue(ws, rowIndex, ++colIndex, (item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT != null && item.PROF_COMMERCIAL_NAME_PRIMARY_ELECT == "gpcrELECT") ? "X" : "");
        }