コード例 #1
0
ファイル: ExcelExporter.cs プロジェクト: youmery/longomatch
    public void Export()
    {
        FileInfo newFile = new FileInfo(filename);

        if (newFile.Exists)
        {
            newFile.Delete();              // ensures we create a new workbook
            newFile = new FileInfo(filename);
        }

        using (package = new ExcelPackage(newFile)) {
            TimelineSheet       timeline;
            TeamStatsSheet      teamStats;
            GameUnitsStatsSheet gu;
            ProjectStats        stats = new ProjectStats(project);

            ws = CreateSheet(package, Catalog.GetString("Project statistics"));
            var statsSheet = new ProjectStatsSheet(ws, project);
            statsSheet.Fill(stats);

            ws = CreateSheet(package, project.LocalTeamTemplate.TeamName +
                             "(" + Catalog.GetString("Local Team") + ")");
            teamStats = new TeamStatsSheet(ws, stats, Team.LOCAL);
            teamStats.Fill();

            ws = CreateSheet(package, project.VisitorTeamTemplate.TeamName +
                             "(" + Catalog.GetString("Visitor Team") + ")");
            teamStats = new TeamStatsSheet(ws, stats, Team.VISITOR);
            teamStats.Fill();

            ws       = CreateSheet(package, Catalog.GetString("Timeline"));
            timeline = new TimelineSheet(ws, project);
            timeline.Fill();

            ws = CreateSheet(package, Catalog.GetString("Game units"));
            gu = new GameUnitsStatsSheet(ws, stats);
            gu.Fill();

            package.Save();
        }
    }
コード例 #2
0
ファイル: ExcelExporter.cs プロジェクト: GNOME/longomatch
    public void Export()
    {
        FileInfo newFile = new FileInfo(filename);
        if (newFile.Exists)
        {
            newFile.Delete();  // ensures we create a new workbook
            newFile = new FileInfo(filename);
        }

        using (package = new ExcelPackage(newFile)) {
            TimelineSheet timeline;
            TeamStatsSheet teamStats;
            GameUnitsStatsSheet gu;
            ProjectStats stats = new ProjectStats(project);

            ws = CreateSheet(package, Catalog.GetString("Project statistics"));
            var statsSheet = new ProjectStatsSheet(ws, project);
            statsSheet.Fill(stats);

            ws = CreateSheet(package, project.LocalTeamTemplate.TeamName +
                "(" + Catalog.GetString("Local Team") + ")");
            teamStats = new TeamStatsSheet(ws, stats, Team.LOCAL);
            teamStats.Fill();

            ws = CreateSheet(package, project.VisitorTeamTemplate.TeamName +
                "(" + Catalog.GetString("Visitor Team") + ")");
            teamStats = new TeamStatsSheet(ws, stats, Team.VISITOR);
            teamStats.Fill();

            ws = CreateSheet(package, Catalog.GetString("Timeline"));
            timeline = new TimelineSheet(ws, project);
            timeline.Fill();

            ws = CreateSheet(package, Catalog.GetString("Game units"));
            gu = new GameUnitsStatsSheet(ws, stats);
            gu.Fill();

            package.Save();
        }
    }