Esempio n. 1
0
        public IActionResult Excel()
        {
            List <List <string[]> > title = new List <List <string[]> >();

            title.Add(new List <string[]>()
            {
                new string[2] {
                    "XX公司", "@"
                }
            });
            title.Add(new List <string[]>()
            {
                new string[2] {
                    "員工", "@"
                }
            });
            title.Add(new List <string[]>()
            {
                new string[2] {
                    "部門", "@"
                },
                new string[2] {
                    "人事部", "@"
                }
            });

            var dto = DataToExcel.DataToExcelDataType(employees, title, new string[]
                                                      { nameof(Employee.Id),
                                                        nameof(Employee.Name),
                                                        nameof(Employee.Salary),
                                                        nameof(Employee.Seniority),
                                                        nameof(Employee.Currency) });

            return(DataToExcel.ToExcel(this, dto, "XX公司-員工表", "員工表"));
        }