private void setDataForExcelSpreadsheet(string store, int rowToUpDate, IXLWorksheet worksheet, double hours, PersonnelScheduleDetail wSD) { worksheet.Cell("A13").SetValue(wSD.GETemployeeName() + " " + wSD.GETemployeeNumber()); worksheet.Cell("AH38").SetValue(wSD.GETemployeeName()); worksheet.Cell("AM13").SetValue(figureOutClient(wSD)); worksheet.Cell("X13").SetValue(wSD.GETpayPeriod()); //each of the worked days: worksheet.Cell("A" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GETscheduledWorkDate().ToShortDateString()); worksheet.Cell("E" + Convert.ToString(rowToUpDate + 19)).SetValue(store); worksheet.Cell("I" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GETinTime().ToString("H:mm")); worksheet.Cell("V" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GEToutTime().ToString("H:mm")); worksheet.Cell("AI" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GEThours().ToString()); worksheet.Cell("AI35").SetValue(Convert.ToString(hours)); }