public ActionResult TrovaFattureRitardate(string DataInizio, string DataFine) { ALEBLL bll = new ALEBLL(RvlImageSite); FattureRitardateModel model = bll.LeggiFattureRitardate(DataInizio, DataFine, true); return(PartialView("FattureRitardatePartial", model)); }
public ActionResult NascondiRiga(string IDRIPGRATUITA, string DataInizio, string DataFine) { ALEBLL bll = new ALEBLL(RvlImageSite); bll.NascondiRiga(IDRIPGRATUITA); FattureRitardateModel model = bll.LeggiFattureRitardate(DataInizio, DataFine, true); return(PartialView("FattureRitardatePartial", model)); }
public ActionResult EsportaExcel(string DataInizio, string DataFine) { ALEBLL bll = new ALEBLL(RvlImageSite); FattureRitardateModel model = bll.LeggiFattureRitardate(DataInizio, DataFine, true); ExcelHelper excel = new ExcelHelper(); byte[] fileContents = excel.CreaExcelFattureRitardate(model); return(File(fileContents, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "FattureRitardate.xlsx")); }
public byte[] CreaExcelFattureRitardate(FattureRitardateModel FattureRitardate) { byte[] content; MemoryStream ms = new MemoryStream(); //string filename = @"c:\temp\mancanti.xlsx"; using (SpreadsheetDocument document = SpreadsheetDocument.Create(ms, SpreadsheetDocumentType.Workbook)) { WorkbookPart workbookPart = document.AddWorkbookPart(); workbookPart.Workbook = new Workbook(); WorksheetPart worksheetPart = workbookPart.AddNewPart <WorksheetPart>(); worksheetPart.Worksheet = new Worksheet(); // Adding style WorkbookStylesPart stylePart = workbookPart.AddNewPart <WorkbookStylesPart>(); stylePart.Stylesheet = GenerateStylesheet(); stylePart.Stylesheet.Save(); // Setting up columns Columns columns = new Columns( new Column { Min = 1, Max = 1, Width = 40, CustomWidth = true }, new Column { Min = 2, Max = 2, Width = 20, CustomWidth = false }, new Column { Min = 3, Max = 3, Width = 20, CustomWidth = true }, new Column { Min = 4, Max = 4, Width = 20, CustomWidth = false }, new Column { Min = 5, Max = 5, Width = 20, CustomWidth = true }); worksheetPart.Worksheet.AppendChild(columns); Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets()); Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Fatture Ritardate" }; sheets.Append(sheet); workbookPart.Workbook.Save(); SheetData sheetData = worksheetPart.Worksheet.AppendChild(new SheetData()); // Constructing header Row row = new Row(); row.Append( ConstructCell("ODL", CellValues.String, 2), ConstructCell("Data Creazione", CellValues.String, 2), ConstructCell("Utente Inserimento", CellValues.String, 2), ConstructCell("Lavorante", CellValues.String, 2), ConstructCell("Data Scadenza", CellValues.String, 2)); // Insert the header row to the Sheet Data sheetData.AppendChild(row); foreach (FatturaRitardataModel FatturaRitardata in FattureRitardate.FattureRitardate) { row = new Row(); row.Append( ConstructCell(FatturaRitardata.ODL, CellValues.String, 1), ConstructCell(FatturaRitardata.DATA_CREAZIONE.ToShortDateString(), CellValues.String, 1), ConstructCell(FatturaRitardata.UIDUSER_INSERIMENTO, CellValues.String, 1), ConstructCell(FatturaRitardata.LAVORANTE, CellValues.String, 1), ConstructCell(FatturaRitardata.DATA_SCADENZA.ToShortDateString(), CellValues.String, 1)); sheetData.AppendChild(row); } workbookPart.Workbook.Save(); document.Save(); document.Close(); ms.Seek(0, SeekOrigin.Begin); content = ms.ToArray(); } return(content); }