public ActionResult GetExport(int count = 0) { var productFaker = new Faker <Product>() .CustomInstantiator(f => new Product()) .RuleFor(p => p.Id, f => f.IndexFaker) .RuleFor(p => p.Ean, f => f.Commerce.Ean13()) .RuleFor(p => p.Name, f => f.Commerce.ProductName()) .RuleFor(p => p.Description, f => f.Lorem.Sentence(f.Random.Int(5, 20))) .RuleFor(p => p.Brand, f => f.Company.CompanyName()) .RuleFor(p => p.Category, f => f.Commerce.Categories(1).First()) .RuleFor(p => p.Price, f => f.Commerce.Price(1, 1000, 2, "€")) .RuleFor(p => p.Quantity, f => f.Random.Int(0, 1000)) .RuleFor(p => p.Rating, f => f.Random.Float(0, 1)) .RuleFor(p => p.ReleaseDate, f => f.Date.Past(2)); var excelProvider = new ExcelProvider(); excelProvider.Generate(productFaker.Generate(count), null, "Sheet 1"); return(File(excelProvider.File, "application/octet-stream")); }
private void ExportToExcelInner(List <Header> headers, List <List <string> > data) { var table = new ExportTable("", headers, data); ExcelProvider.Generate(table); }