internal void add_workbook_top(string wbName, string tmpWbNameA, string tmpWbNameB, ResComp wscomp)
{
body.AppendLine(string.Format("<br><font size=\"2\" ><b>Workbook </b> \"{0}\" :</font> <a target=\"_blank\" href=\"{1}\" >Selection A</a> ({2} Sheets) versus <a target=\"_blank\" href=\"{3}\">Selection B</a> ({4} Sheets)<br>", wbName, tmpWbNameA, wscomp.lenA, tmpWbNameB, wscomp.lenB));
body.AppendLine("<hr NOSHADE size=\"1px\" width=\"75%\" ALIGN=\"left\">");
foreach (ExcelFile wbs in wscomp.Aonly)
{
result.AddDifference("MissingWorsheet", wbName, wbs.Name, " + ", " - ", null, null);
body.AppendLine(" <font color=red><b>• Worksheet </b>'" + wbs.Name + "' is missing in workbook B</font><br>");
}
foreach (ExcelFile wbs in wscomp.Bonly)
{
result.AddDifference("MissingWorsheet", wbName, wbs.Name, " - ", " + ", null, null);
body.AppendLine(" <font color=red><b>• Worksheet </b>'" + wbs.Name + "' is missing in workbook A</font><br>");
}
}
internal void add_Workbook_list(ResComp fileComp)
{
body.AppendLine("<br><font size=\"2\" ><b>Selection</b></font> <i>( " + fileComp.lenAandB + " workbooks )</i><br>");
body.AppendLine("<hr NOSHADE size=\"1px\" width=\"75%\" ALIGN=\"left\">");
foreach (PairFiles wbs in fileComp.AandB)
{
body.AppendLine(" <b>• Workbook</b> '"+wbs.A.Name+"' : <br>");
body.AppendLine(" Selection A : <a target=\"_blank\" href=\"" + wbs.A.ToUri() + "\">" + wbs.A.Object + " (" + wbs.A.ToSize() + " Ko)</a><br>");
body.AppendLine(" Selection B : <a target=\"_blank\" href=\"" + wbs.B.ToUri() + "\">" + wbs.B.Object + " (" + wbs.B.ToSize() + " Ko)</a><br>");
}
foreach (ExcelFile wbs in fileComp.Aonly)
{
result.AddDifference("MissingWorkook", wbs.Name, "", " + ", " - ", null, null);
body.AppendLine(" <font color=red><b>• Workbook</b> '" + wbs.Name + "' is missing in selection B : </font><br>");
body.AppendLine(" <font color=red>Selection A : <a target=\"_blank\" href=\""+wbs.ToUri()+"\">"+wbs.Object+" ("+wbs.ToSize()+" Ko)</a></font><br>");
}
foreach (ExcelFile wbs in fileComp.Bonly)
{
result.AddDifference("MissingWorkook", wbs.Name, "", " - "," + ", null, null);
body.AppendLine(" <font color=red><b>• Workbook</b> '"+wbs.Name+"' is missing in selection A : </font><br>");
body.AppendLine(" <font color=red>Selection B : <a target=\"_blank\" href=\""+wbs.ToUri()+"\">"+wbs.Object+" ("+wbs.ToSize()+" Ko)</a></font><br>");
}
}