Convert <TGroup>
(
ICollection <TGroup> groups,
GroupToGroupVertices <TGroup> groupToGroupVertices
)
{
Debug.Assert(groups != null);
Debug.Assert(groupToGroupVertices != null);
// These columns are needed:
//
// * Group name on the group worksheet.
//
// * Vertex color on the group worksheet.
//
// * Vertex shape on the group worksheet.
//
// * Collapsed flag on the group worksheet.
//
// * Group name on the group-vertex worksheet.
//
// * Vertex name on the group-vertex worksheet.
//
// * Vertex ID on the group-vertex worksheet. This gets copied from
// the hidden ID column on the Vertex worksheet via an Excel
// formula.
List <GraphMetricValueOrdered> oGroupNamesForGroupWorksheet =
new List <GraphMetricValueOrdered>();
List <GraphMetricValueOrdered> oVertexColorsForGroupWorksheet =
new List <GraphMetricValueOrdered>();
List <GraphMetricValueOrdered> oVertexShapesForGroupWorksheet =
new List <GraphMetricValueOrdered>();
// This column is empty.
GraphMetricValueOrdered [] aoCollapsedFlagsForGroupWorksheet =
new GraphMetricValueOrdered[0];
List <GraphMetricValueOrdered> oGroupNamesForGroupVertexWorksheet =
new List <GraphMetricValueOrdered>();
List <GraphMetricValueOrdered> oVertexNamesForGroupVertexWorksheet =
new List <GraphMetricValueOrdered>();
// This column contains a constant value, which is a formula.
GraphMetricValueOrdered [] aoVertexIDsForGroupVertexWorksheet =
{
new GraphMetricValueOrdered(
GroupManager.GetExcelFormulaForVertexID())
};
Int32 iGroups = groups.Count;
Int32 iGroup = 0;
ColorConverter2 oColorConverter2 = new ColorConverter2();
VertexShapeConverter oVertexShapeConverter =
new VertexShapeConverter();
foreach (TGroup oGroup in groups)
{
String sGroupName = 'G' + (iGroup + 1).ToString(
CultureInfo.InvariantCulture);
Color oColor;
VertexShape eShape;
GroupManager.GetVertexAttributes(iGroup, iGroups, out oColor,
out eShape);
GraphMetricValueOrdered oGroupNameGraphMetricValue =
new GraphMetricValueOrdered(sGroupName);
oGroupNamesForGroupWorksheet.Add(oGroupNameGraphMetricValue);
// Write the color in a format that is understood by
// ColorConverter2.WorkbookToGraph(), which is what
// WorksheetReaderBase uses.
oVertexColorsForGroupWorksheet.Add(
new GraphMetricValueOrdered(
oColorConverter2.GraphToWorkbook(oColor)));
oVertexShapesForGroupWorksheet.Add(
new GraphMetricValueOrdered(
oVertexShapeConverter.GraphToWorkbook(eShape)));
Int32 iVertices = 0;
foreach (IVertex oVertex in groupToGroupVertices(oGroup))
{
oGroupNamesForGroupVertexWorksheet.Add(
oGroupNameGraphMetricValue);
oVertexNamesForGroupVertexWorksheet.Add(
new GraphMetricValueOrdered(
ExcelUtil.ForceCellText(oVertex.Name)));
iVertices++;
}
iGroup++;
}
return(new GraphMetricColumn [] {
new GraphMetricColumnOrdered(WorksheetNames.Groups,
TableNames.Groups,
GroupTableColumnNames.Name,
ExcelUtil.AutoColumnWidth, null, CellStyleNames.Required,
oGroupNamesForGroupWorksheet.ToArray()
),
new GraphMetricColumnOrdered(WorksheetNames.Groups,
TableNames.Groups,
GroupTableColumnNames.VertexColor,
ExcelUtil.AutoColumnWidth, null, CellStyleNames.VisualProperty,
oVertexColorsForGroupWorksheet.ToArray()
),
new GraphMetricColumnOrdered(WorksheetNames.Groups,
TableNames.Groups,
GroupTableColumnNames.VertexShape,
ExcelUtil.AutoColumnWidth, null, CellStyleNames.VisualProperty,
oVertexShapesForGroupWorksheet.ToArray()
),
new GraphMetricColumnOrdered(WorksheetNames.Groups,
TableNames.Groups,
GroupTableColumnNames.Collapsed,
ExcelUtil.AutoColumnWidth, null, CellStyleNames.VisualProperty,
aoCollapsedFlagsForGroupWorksheet
),
new GraphMetricColumnOrdered(WorksheetNames.GroupVertices,
TableNames.GroupVertices,
GroupVertexTableColumnNames.GroupName,
ExcelUtil.AutoColumnWidth, null, null,
oGroupNamesForGroupVertexWorksheet.ToArray()
),
new GraphMetricColumnOrdered(WorksheetNames.GroupVertices,
TableNames.GroupVertices,
GroupVertexTableColumnNames.VertexName,
ExcelUtil.AutoColumnWidth, null, null,
oVertexNamesForGroupVertexWorksheet.ToArray()
),
new GraphMetricColumnOrdered(WorksheetNames.GroupVertices,
TableNames.GroupVertices,
GroupVertexTableColumnNames.VertexID,
ExcelUtil.AutoColumnWidth, null, null,
aoVertexIDsForGroupVertexWorksheet
),
});
}
WriteGraphMetricColumnOrderedToWorkbook
(
GraphMetricColumnOrdered oGraphMetricColumnOrdered,
ListObject oTable
)
{
Debug.Assert(oGraphMetricColumnOrdered != null);
Debug.Assert(oTable != null);
AssertValid();
Range oVisibleColumnData;
// Get the specified column.
if (!TryGetRequiredColumnInformation(oGraphMetricColumnOrdered,
oTable, out oVisibleColumnData))
{
return;
}
// Copy the graph metric values to an array.
GraphMetricValueOrdered [] aoGraphMetricValuesOrdered =
oGraphMetricColumnOrdered.GraphMetricValuesOrdered;
Int32 iRows = aoGraphMetricValuesOrdered.Length;
Object [,] aoValues = ExcelUtil.GetSingleColumn2DArray(iRows);
Boolean bStyleSpecified = false;
for (Int32 i = 0; i < iRows; i++)
{
GraphMetricValueOrdered oGraphMetricValueOrdered =
aoGraphMetricValuesOrdered[i];
aoValues[i + 1, 1] = oGraphMetricValueOrdered.Value;
if (oGraphMetricValueOrdered.Style != null)
{
// A style was specified for this row. It will need to be
// applied later. (It should be possible to apply the style
// here, but that does not work reliably when values are
// written to the cells afterwards, as they are after this
// loop.)
bStyleSpecified = true;
}
}
// Write the array to the column.
ExcelUtil.SetRangeValues(oVisibleColumnData, aoValues);
if (bStyleSpecified)
{
for (Int32 i = 0; i < iRows; i++)
{
String sStyle = aoGraphMetricValuesOrdered[i].Style;
if (sStyle != null)
{
// This row has a style. Apply it.
ExcelUtil.SetRangeStyle(
(Range)oVisibleColumnData.Cells[i + 1, 1], sStyle);
}
}
}
}
