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));
}
