public static void StockRequestsToExcel(string filename = "stockRequests.xlsx") { string sheetName = "StockRequests"; List <StockRequest> requests = StockRequest.GetAllShelfRestockRequests(); var workbook = new XLWorkbook(); workbook.AddWorksheet(sheetName); var ws = workbook.Worksheet(sheetName); int row = 1; ws.Cell("A" + row.ToString()).Value = "Name"; ws.Cell("B" + row.ToString()).Value = "Description"; ws.Cell("C" + row.ToString()).Value = "Quantity"; ws.Cell("D" + row.ToString()).Value = "QuantityInDepot"; ws.Cell("E" + row.ToString()).Value = "QuantityInStore"; row++; foreach (StockRequest item in requests) { ws.Cell("A" + row.ToString()).Value = item.Name; ws.Cell("B" + row.ToString()).Value = item.Description; ws.Cell("C" + row.ToString()).Value = item.Quantity; ws.Cell("D" + row.ToString()).Value = item.QuantityInDepot; ws.Cell("E" + row.ToString()).Value = item.QuantityInStore; row++; } workbook.SaveAs(filename); }
public ShelfRestockRequests() { InitializeComponent(); List <StockRequest> requests = StockRequest.GetAllShelfRestockRequests(); shelfRestockView.Items.Clear(); foreach (StockRequest request in requests) { shelfRestockView.Items.Add(new ListViewItem(new[] { "[WIP, in later phase]", request.Name, request.Description, request.Quantity.ToString() })); } }