private void HyperLinkWriteWellData_Click(object sender, RoutedEventArgs e) { if (this.m_CaseList != null) { if (this.m_WorkBook != null) { Microsoft.Office.Interop.Excel.Worksheet workSheet = this.m_WorkBook.Sheets["SamplePlacement"]; workSheet.Select(Type.Missing); TecanSamplePlacementQueue tecanSamplePlacementQueue = new TecanSamplePlacementQueue(); for (int i = this.m_CaseList.Count - 1; i >= 0; i--) { if (tecanSamplePlacementQueue.Queue.Count != 0) { TecanSample tecanSample = tecanSamplePlacementQueue.Queue.Dequeue(); workSheet.Cells[tecanSample.WellCell.RowIndex, tecanSample.WellCell.ColumnIndex] = TecanSample.GetWellCellValue(this.m_CaseList[i].ReportNo, this.m_CaseList[i].PLastName); } } } else { MessageBox.Show("The spread sheet doesn't appear to be open."); } } else { MessageBox.Show("The well data cannot be written in this mode."); } }
private void HyperLinkWriteWellData_Click(object sender, RoutedEventArgs e) { if (this.m_CaseList != null) { if (this.m_WorkBook != null) { Microsoft.Office.Interop.Excel.Worksheet workSheet = this.m_WorkBook.Sheets["SamplePlacement"]; workSheet.Select(Type.Missing); TecanSamplePlacementQueue tecanSamplePlacementQueue = new TecanSamplePlacementQueue(); for (int i = this.m_CaseList.Count - 1; i >= 0; i--) { if (tecanSamplePlacementQueue.Queue.Count != 0) { TecanSample tecanSample = tecanSamplePlacementQueue.Queue.Dequeue(); workSheet.Cells[tecanSample.WellCell.RowIndex, tecanSample.WellCell.ColumnIndex] = TecanSample.GetWellCellValue(this.m_CaseList[i].ReportNo, this.m_CaseList[i].PLastName); } } } else { MessageBox.Show("The spread sheet doesn't appear to be open."); } } else { MessageBox.Show("The well data cannot be written in this mode."); } }