public void WriteMeeting(ExcelMeetingDataRequest request) { var sheet = (Worksheet)excelApp.Sheets .First(o => ((Worksheet)o).Name == request.SheetDestination); // Write Header var header = new List <object> { "Name", "Date", "Start", "End" }; var destination = sheet.get_Range("A1", Type.Missing); WriteListHorizontally(destination, header); // find the next empty cell from column A var nextRow = 2; if (!string.IsNullOrEmpty(sheet.Cells[2, 1]?.Value?.ToString())) { var lastCell = sheet.Cells[1, 1].End(XlDirection.xlDown); nextRow = lastCell.Row + 1; } var entry = new List <object> { request.Data.Name, request.Data.Date.Date.ToString("d"), request.Data.StartingTime.ToString("hh:mm"), request.Data.EndTime.ToString("hh:mm") }; destination = sheet.Cells[nextRow, 1]; WriteListHorizontally(destination, entry); }
private void WriteMeetingData(ExcelMeetingDataRequest obj) { logger.Debug("Write Meeting data"); try { excelOperation.WriteMeeting(obj); eventAgg.GetEvent <PubSubEvent <ExcelMeetingDataResponse> >() .Publish(new ExcelMeetingDataResponse { ProcessCompletedSuccessfully = true }); } catch (Exception) { eventAgg.GetEvent <PubSubEvent <ExcelMeetingDataResponse> >() .Publish(new ExcelMeetingDataResponse { ProcessCompletedSuccessfully = false }); } }