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); }
internal static void Add_TestVariables(Excel.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "AllowedValues"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision"); insertAt.IncrementRows(); }
internal static void Add_TestSuite_Entry(Excel.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Configurations"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "EntryType"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PointAssignments"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCase"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestObject"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestSuite"); insertAt.IncrementRows(); }
internal static void Add_TestSettings(Excel.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Id"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "IsAutomated"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdated"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdatedBy"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "MachineRoles.Count"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Name"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Settings"); insertAt.IncrementRows(); }
internal static void Add_TestSuites(Excel.XlLocation insertAt) { XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TeamProject"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "ID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Title"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Description"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "State"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdated"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "LastUpdatedBy"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCaseCount"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestSuiteType"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "TestCasesCount"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "Revision"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PlanID"); XlHlp.AddColumnHeaderToSheetX(insertAt.AddOffsetColumnX(), 20, "PlanName"); insertAt.IncrementRows(); }
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); }