private VNC.AddinHelper.Excel.XlLocation DisplayListOf_Lists(VNC.AddinHelper.Excel.XlLocation insertAt, IEnumerable <List> lists, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); Worksheet ws = insertAt.workSheet; if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var list in lists) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.Title); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), list.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
private XlHlp.XlLocation DisplayListOf_ContentTypes(XlHlp.XlLocation insertAt, ContentTypeCollection contentTypes, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); Worksheet ws = insertAt.workSheet; if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var cType in contentTypes) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Name); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Group); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), cType.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
internal static void Add_TP_WorkItemTypes(XlHlp.XlLocation insertAt) { long startTicks = Log.APPLICATION("Enter", Common.PROJECT_NAME); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Team Project"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Name"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "Count"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "FieldCount"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastCreateDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastChangedDate"); XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 20, "LastRevisedDate"); // TODO(crhodes) // Since we now can pass in a CellFormatSpecification, might be able to go back to just using insertAt.AddOffsetColumn insertAt.AddOffsetColumnX(); CellFormatSpecification lucidia7 = insertAt.CreateCellFormat("lucidia7", fontSize: 7); lucidia7.Font.Name = "Lucida Sans Typewriter"; XlHlp.AddColumnHeaderToSheetX(insertAt.workSheet, insertAt.RowCurrent, insertAt.ColumnOffset, 180, "Transitions", lucidia7); insertAt.IncrementRows(); Log.APPLICATION("Exit", Common.PROJECT_NAME, startTicks); }
private static void CreateLogWorkSheetHeader(XlHlp.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 8, "ID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TimeStamp"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Category"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Priority"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Severity"); // TODO(crhodes) // Add a UI Config for supporting EventID //XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "EventID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "ProcessName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 12, "ProcessID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 14, "ThreadName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 12, "ThreadID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "UserName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 50, "ClassName.MethodName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Duration"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 100, "Message"); }
private XlHlp.XlLocation DisplayListOf_SiteColumns(XlHlp.XlLocation insertAt, IEnumerable <Field> siteColumns, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); Worksheet ws = insertAt.workSheet; //<Field //ID="{56747800-D36E-4625-ABE3-B1BC74A7D5F8}" //Name="LowerValuesAreBetter" //StaticName="LowerValuesAreBetter" //Description="Whether lower is better or higher is better" //Group="Status Indicators" Type="Boolean" //DisplayName="Lower values are better" //SourceID="http://schemas.microsoft.com/sharepoint/v3" /> //<Field //Type="Lookup" //DisplayName="FA Page Type" //Required="FALSE" //EnforceUniqueValues="FALSE" //List="{b1d6a5ff-876b-4761-a05d-210038e31639}" //WebId="666b287f-2709-476b-a739-e1de9150fb37" //ShowField="Title" //UnlimitedLengthInDocumentLibrary="FALSE" //Group="Custom Columns" //ID="{3090abc3-526c-458f-9c65-302ad853db65}" //SourceID="{666b287f-2709-476b-a739-e1de9150fb37}" //StaticName="FA_x0020_Page_x0020_Type" //Name="FA_x0020_Page_x0020_Type" /> if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "StaticName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 40, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 30, "Group"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 15, "TypeAsString"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "SchemaXml"); insertAt.IncrementRows(); } foreach (var field in siteColumns) { insertAt.ClearOffsets(); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Title); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Group); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.Id.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.TypeAsString.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), field.SchemaXml); insertAt.IncrementRows(); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }
internal static XlHlp.XlLocation DisplayListOf_TeamProjects(XlHlp.XlLocation insertAt, ReadOnlyCollection <CatalogNode> projectNodes, bool displayDataOnly, string tableSuffix) { long startTicks = XlHlp.DisplayInWatchWindow(insertAt); if (!displayDataOnly) { insertAt.MarkStart(XlHlp.MarkType.GroupTable); //XlHlp.AddTitledInfo(insertAt.AddRow(), "Name", teamProjects.Count.ToString()); //XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), Name, 12, XlHlp.MakeBold.Yes); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "DisplayName"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "Identifier"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 35, "ProjectId"); //XlHlp.AddColumnHeaderToSheet(insertAt.AddOffsetColumn(), 25, "ProjectName", 12); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "ProjectState"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 62, "ProjectUri"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 10, "Tfvc Enabled"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 25, "SCC"); //XlHlp.AddTitledInfo(insertAt.AddRow(2), "TP Name", teamProject.Name); //XlHlp.AddTitledInfo(insertAt.AddRow(2), "AbsoluteUri", teamProject.ArtifactUri.AbsoluteUri); //XlHlp.AddTitledInfo(insertAt.AddRow(2), "ServerItem", teamProject.ServerItem); //XlHlp.AddTitledInfo(insertAt.AddRow(2), "VCS ServerQuid", teamProject.VersionControlServer.ServerGuid.ToString()); insertAt.IncrementRows(); } // The columns in this method need to be kept in sync with CreateTeamProjectsInfo() foreach (CatalogNode projectNode in projectNodes.OrderBy(tp => tp.Resource.DisplayName)) { insertAt.ClearOffsets(); try { XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.DisplayName); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Description); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Identifier.ToString()); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectId"]); //XlHlp.AddContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectName"]); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectState"]); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["ProjectUri"]); XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), projectNode.Resource.Properties["SourceControlTfvcEnabled"]); string sccType = "??"; if (projectNode.Resource.Properties.Keys.Contains("SourceControlCapabilityFlags")) { switch (int.Parse(projectNode.Resource.Properties["SourceControlCapabilityFlags"])) { case 0: sccType = "NONE"; break; case 1: sccType = "TFS"; break; case 2: sccType = "GIT"; break; case 3: sccType = "TFS/GIT"; break; default: break; } } XlHlp.AddOffsetContentToCell(insertAt.AddOffsetColumn(), sccType); } catch (Exception ex) { } //projectNode.FullPath // projectNode.Resource.Description // projectNode.Resource.Identifier insertAt.IncrementRows(); } if (!displayDataOnly) { insertAt.MarkEnd(XlHlp.MarkType.GroupTable, string.Format("tblTP_{0}", tableSuffix)); insertAt.Group(insertAt.OrientVertical, hide: true); } XlHlp.DisplayInWatchWindow(insertAt, startTicks, "End"); return(insertAt); }