private void CopyToClipboardButton_Click(object sender, EventArgs e) { if (EmailResultTextBox.Text.Length == 0) { return; } Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); excelApp.Visible = true; _Workbook workbook = (_Workbook)(excelApp.Workbooks.Add(Type.Missing)); _Worksheet worksheet = (_Worksheet)workbook.ActiveSheet; TicketRepository ticketRepo = new TicketRepository(); List<TicketResource> listOfTickets = ticketRepo.GetDistinctEmailAddressBetweenDates(StartingDatePicker.Value, EndingDatePicker.Value); for (int i = 0; i < listOfTickets.Count; i++) { TicketResource ticket = listOfTickets[i]; int row = i + 1; worksheet.Cells[row, "A"] = ticket.LastName; worksheet.Cells[row, "B"] = ticket.FirstName; worksheet.Cells[row, "C"] = ticket.Email; } worksheet.Columns["A:C"].AutoFit(); }
private void GetEmailsButton_Click(object sender, EventArgs e) { TicketRepository ticketRepo = new TicketRepository(); List<TicketResource> listOfTickets = ticketRepo.GetDistinctEmailAddressBetweenDates(StartingDatePicker.Value, EndingDatePicker.Value); String emailString = ""; for (int i = 0; i < listOfTickets.Count; i++) { TicketResource ticket = listOfTickets[i]; if (i == 0) { emailString += ticket.Email; } else { emailString += ", " + ticket.Email; } } EmailResultTextBox.Text = emailString; }