private void getMailingAddressesButton_Click(object sender, EventArgs e) { 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.GetDistinctMailingAddressBetweenDates(StartingDatePicker.Value, EndingDatePicker.Value); //change the getDistintMailing to not accept "" as a unique address. then we can remove this row checking int row = 1; for (int i = 0; i < listOfTickets.Count; i++) { TicketResource ticket = listOfTickets[i]; if (ticket.Address == "") { continue; } worksheet.Cells[row, "A"] = ticket.LastName; worksheet.Cells[row, "B"] = ticket.FirstName; worksheet.Cells[row, "C"] = ticket.Address; worksheet.Cells[row, "D"] = ticket.City; worksheet.Cells[row, "E"] = ticket.State; worksheet.Cells[row, "F"] = ticket.Zip; row++; } worksheet.Columns["A:F"].AutoFit(); }