Exemple #1
0
        private static void Main(string[] args)
        {
            // we can reuse settings so it's a good candidate to be put into DI container
            var builder = ExcelFileGeneratorSettings.Create();

            var generator = builder.CreateGenerator();

            var data = GenerateData().ToArray();

            using (var stream = File.Create("c:\\output.xlsx"))
            {
                var stopwatch = Stopwatch.StartNew();
                generator.GenerateFile(data, stream);
                stopwatch.Stop();

                Console.WriteLine("Elapsed " + stopwatch.ElapsedMilliseconds + " ms.");

                stream.Flush();
            }

            Console.ReadKey();
        }
Exemple #2
0
 protected ExcelFileResultBase(ExcelFileGeneratorSettings settings, string fileName = "Output")
     : base("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
 {
     _settings = settings;
     FileName  = fileName;
 }
Exemple #3
0
 protected ExcelFileResultBase(ExcelFileGeneratorSettings settings, string fileName = "Output")
     : base("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
 {
     _settings = settings;
     FileName = fileName;
 }
Exemple #4
0
 public ExcelFileResult(ExcelFileGeneratorSettings settings, IEnumerable <T> data, string fileName = "Output")
     : base(settings, fileName)
 {
     _data = data;
 }