private void OnGoToExcelExecuted(object p)
{
SkladEntities sklad = new SkladEntities();
var excelApp = new Excel.Application();
excelApp.Workbooks.Add();
Excel.Worksheet worksheet = excelApp.ActiveSheet;
Product[] products = sklad.Products.ToArray();
worksheet.Cells[1][1] = "№";
worksheet.Cells[2][1] = "Описание";
worksheet.Cells[3][1] = "Кол-во";
worksheet.Cells[4][1] = "Дата доставки";
worksheet.Cells[5][1] = "Срок хранения";
worksheet.Cells[6][1] = "Марка";
worksheet.Cells[7][1] = "Тип продукта";
worksheet.Cells[8][1] = "Цена";
worksheet.Cells[9][1] = "Ед.из";
worksheet.Cells[10][1] = "Наименовние";
for (int x = 2; x < products.Length + 2; x++)
{
worksheet.Cells[1][x] = products[x - 2].Id;
worksheet.Cells[2][x] = products[x - 2].Descriotion;
worksheet.Cells[3][x] = products[x - 2].Qty;
worksheet.Cells[4][x] = products[x - 2].DateDelivery;
worksheet.Cells[5][x] = products[x - 2].DateExpiration;
worksheet.Cells[6][x] = products[x - 2].MarksProduct;
worksheet.Cells[7][x] = products[x - 2].TypeProduct.TypeName;
worksheet.Cells[8][x] = products[x - 2].Cost;
worksheet.Cells[9][x] = products[x - 2].Unit.UnitsName;
worksheet.Cells[10][x] = products[x - 2].Name;
}
excelApp.Visible = true;
}
