} // end of Main()
/// <summary>
/// ParseWrokbooks constructor does all the work.
/// </summary>
/// <param name="teamNumberString"></param>
///
ParseWorkbooks( string teamNumberString )
{
int teamNumber = TeamWorkbook.GetTeamNumber( teamNumberString );
DirectoryInfo topDir = new DirectoryInfo( Environment.CurrentDirectory ); // directory we are in
string topDirName = topDir.FullName; // full path
string teamWorkbookPath = TeamWorkbook.GetTeamPath( topDirName, teamNumberString ); // make the path to our team workbook
Excel.Application excelApp = new Excel.Application(); // Creates a new Excel Application
excelApp.Visible = false; // Makes Excel invisible to the user.
TeamWorkbook twb = new TeamWorkbook( excelApp, teamWorkbookPath ); // open our team workbook (must use full path)
FileInfo[] studentFiles = topDir.GetFiles( "*.xlsx" ); // find all the student assessments
if ( studentFiles.Length != 0 )
{
foreach ( FileInfo fileinf in studentFiles ) // for each student assessment
{
StudentWorkbook swb = new StudentWorkbook( excelApp, fileinf.FullName ); // parse the Excel file
if ( swb.TeamNumber == teamNumber ) // if it's the correct team number
{
Console.WriteLine( fileinf.Name );
twb.PasteScores( swb.Scores ); // paste scores in the team workbook
twb.PasteComments( swb.Comments ); // paste comments in teh team workbook
}
swb.Close(); // close the student assessment
}
}
twb.Close(); // close the team workbook
excelApp.Application.DisplayAlerts = false; // no nanny
excelApp.Quit(); // close the Excel app
} // end of ParseWorkbooks
} // end of Main()
/// <summary>
/// ParseWrokbooks constructor does all the work.
/// </summary>
/// <param name="teamNumberString"></param>
///
ParseWorkbooks(string teamNumberString)
{
int teamNumber = TeamWorkbook.GetTeamNumber(teamNumberString);
DirectoryInfo topDir = new DirectoryInfo(Environment.CurrentDirectory); // directory we are in
string topDirName = topDir.FullName; // full path
string teamWorkbookPath = TeamWorkbook.GetTeamPath(topDirName, teamNumberString); // make the path to our team workbook
Excel.Application excelApp = new Excel.Application(); // Creates a new Excel Application
excelApp.Visible = false; // Makes Excel invisible to the user.
TeamWorkbook twb = new TeamWorkbook(excelApp, teamWorkbookPath); // open our team workbook (must use full path)
FileInfo[] studentFiles = topDir.GetFiles("*.xlsx"); // find all the student assessments
if (studentFiles.Length != 0)
{
foreach (FileInfo fileinf in studentFiles) // for each student assessment
{
StudentWorkbook swb = new StudentWorkbook(excelApp, fileinf.FullName); // parse the Excel file
if (swb.TeamNumber == teamNumber) // if it's the correct team number
{
Console.WriteLine(fileinf.Name);
twb.PasteScores(swb.Scores); // paste scores in the team workbook
twb.PasteComments(swb.Comments); // paste comments in teh team workbook
}
swb.Close(); // close the student assessment
}
}
twb.Close(); // close the team workbook
excelApp.Application.DisplayAlerts = false; // no nanny
excelApp.Quit(); // close the Excel app
} // end of ParseWorkbooks
