/// <summary> /// /// </summary> /// <example> /// viewId;entityLogicalName;viewName;ViewType;Type;LCID1;LCID2;...;LCODX /// </example> /// <param name="languages"></param> /// <param name="file"></param> /// <param name="service"></param> public void Export(List<int> languages, ExcelWorkbook file, IOrganizationService service) { var line = 1; var siteMap = GetSiteMap(service); var siteMapDoc = new XmlDocument(); siteMapDoc.LoadXml(siteMap["sitemapxml"].ToString()); var crmSiteMapAreas = new List<CrmSiteMapArea>(); var crmSiteMapGroups = new List<CrmSiteMapGroup>(); var crmSiteMapSubAreas = new List<CrmSiteMapSubArea>(); #region Export Area var areaNodes = siteMapDoc.SelectNodes("SiteMap/Area"); foreach (XmlNode areaNode in areaNodes) { var area = new CrmSiteMapArea { Id = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in areaNode.SelectNodes("Titles/Title")) { area.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in areaNode.SelectNodes("Descriptions/Description")) { area.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapAreas.Add(area); #region Export Groups var groupNodes = areaNode.SelectNodes("Group"); foreach (XmlNode groupNode in groupNodes) { var group = new CrmSiteMapGroup { Id = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in groupNode.SelectNodes("Titles/Title")) { group.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in groupNode.SelectNodes("Descriptions/Description")) { group.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapGroups.Add(group); #region Export SubArea var subAreaNodes = groupNode.SelectNodes("SubArea"); foreach (XmlNode subAreaNode in subAreaNodes) { var subArea = new CrmSiteMapSubArea() { Id = subAreaNode.Attributes["Id"].Value, GroupId = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in subAreaNode.SelectNodes("Titles/Title")) { subArea.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in groupNode.SelectNodes("Descriptions/Description")) { subArea.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapSubAreas.Add(subArea); } #endregion Export SubArea } #endregion Export Groups } #endregion Export Area #region Area sheet var areaSheet = file.Worksheets.Add("SiteMap Areas"); AddAreaHeader(areaSheet, languages); foreach (var crmArea in crmSiteMapAreas) { var cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion Area sheet #region Group sheet line = 1; var groupSheet = file.Worksheets.Add("SiteMap Groups"); AddGroupHeader(groupSheet, languages); foreach (var crmGroup in crmSiteMapGroups) { var cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion Group sheet #region SubArea sheet line = 1; var subAreaSheet = file.Worksheets.Add("SiteMap SubAreas"); AddSubAreaHeader(subAreaSheet, languages); foreach (var crmSubArea in crmSiteMapSubAreas) { var cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion SubArea sheet // Applying style to cells for (int i = 0; i < (2 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(areaSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 2; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(areaSheet, i, j).Style); } } for (int i = 0; i < (3 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(groupSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 3; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(groupSheet, i, j).Style); } } for (int i = 0; i < (4 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(subAreaSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 4; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(subAreaSheet, i, j).Style); } } }
/// <summary> /// /// </summary> /// <example> /// viewId;entityLogicalName;viewName;ViewType;Type;LCID1;LCID2;...;LCODX /// </example> /// <param name="languages"></param> /// <param name="file"></param> /// <param name="service"></param> public void Export(List <int> languages, ExcelWorkbook file, IOrganizationService service) { var line = 1; var siteMap = GetSiteMap(service); var siteMapDoc = new XmlDocument(); siteMapDoc.LoadXml(siteMap["sitemapxml"].ToString()); var crmSiteMapAreas = new List <CrmSiteMapArea>(); var crmSiteMapGroups = new List <CrmSiteMapGroup>(); var crmSiteMapSubAreas = new List <CrmSiteMapSubArea>(); #region Export Area var areaNodes = siteMapDoc.SelectNodes("SiteMap/Area"); foreach (XmlNode areaNode in areaNodes) { var area = new CrmSiteMapArea { Id = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in areaNode.SelectNodes("Titles/Title")) { area.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in areaNode.SelectNodes("Descriptions/Description")) { area.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapAreas.Add(area); #region Export Groups var groupNodes = areaNode.SelectNodes("Group"); foreach (XmlNode groupNode in groupNodes) { var group = new CrmSiteMapGroup { Id = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in groupNode.SelectNodes("Titles/Title")) { group.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in groupNode.SelectNodes("Descriptions/Description")) { group.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapGroups.Add(group); #region Export SubArea var subAreaNodes = groupNode.SelectNodes("SubArea"); foreach (XmlNode subAreaNode in subAreaNodes) { var subArea = new CrmSiteMapSubArea() { Id = subAreaNode.Attributes["Id"].Value, GroupId = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value }; foreach (XmlNode titleNode in subAreaNode.SelectNodes("Titles/Title")) { subArea.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } foreach (XmlNode titleNode in subAreaNode.SelectNodes("Descriptions/Description")) { subArea.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } crmSiteMapSubAreas.Add(subArea); } #endregion Export SubArea } #endregion Export Groups } #endregion Export Area #region Area sheet var areaSheet = file.Worksheets.Add("SiteMap Areas"); AddAreaHeader(areaSheet, languages); foreach (var crmArea in crmSiteMapAreas) { var cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion Area sheet #region Group sheet line = 1; var groupSheet = file.Worksheets.Add("SiteMap Groups"); AddGroupHeader(groupSheet, languages); foreach (var crmGroup in crmSiteMapGroups) { var cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion Group sheet #region SubArea sheet line = 1; var subAreaSheet = file.Worksheets.Add("SiteMap SubAreas"); AddSubAreaHeader(subAreaSheet, languages); foreach (var crmSubArea in crmSiteMapSubAreas) { var cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } line++; cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } line++; } #endregion SubArea sheet // Applying style to cells for (int i = 0; i < (2 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(areaSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 2; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(areaSheet, i, j).Style); } } for (int i = 0; i < (3 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(groupSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 3; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(groupSheet, i, j).Style); } } for (int i = 0; i < (4 + languages.Count); i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(subAreaSheet, 0, i).Style); } for (int i = 1; i < line; i++) { for (int j = 0; j < 4; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(subAreaSheet, i, j).Style); } } }
/// <summary> /// /// </summary> /// <example> /// viewId;entityLogicalName;viewName;ViewType;Type;LCID1;LCID2;...;LCODX /// </example> /// <param name="languages"></param> /// <param name="file"></param> /// <param name="service"></param> /// <param name="settings"></param> public void Export(List <int> languages, ExcelWorkbook file, IOrganizationService service, ExportSettings settings, ConnectionDetail detail) { var line = 0; int cell; siteMaps = GetSiteMaps(settings, service, detail); var areaSheet = file.Worksheets.Add("SiteMap Areas"); var groupSheet = file.Worksheets.Add("SiteMap Groups"); var subAreaSheet = file.Worksheets.Add("SiteMap SubAreas"); AddAreaHeader(areaSheet, languages); AddGroupHeader(groupSheet, languages); AddSubAreaHeader(subAreaSheet, languages); var crmSiteMapAreas = new List <CrmSiteMapArea>(); var crmSiteMapGroups = new List <CrmSiteMapGroup>(); var crmSiteMapSubAreas = new List <CrmSiteMapSubArea>(); foreach (var siteMap in siteMaps.Entities) { var siteMapDoc = new XmlDocument(); siteMapDoc.LoadXml(siteMap["sitemapxml"].ToString()); #region Export Area var areaNodes = siteMapDoc.SelectNodes("SiteMap/Area"); foreach (XmlNode areaNode in areaNodes) { var area = new CrmSiteMapArea { Id = areaNode.Attributes["Id"].Value, SiteMapId = siteMap.Id, SiteMapName = siteMap.GetAttributeValue <string>("sitemapname") }; if (settings.ExportNames) { foreach (XmlNode titleNode in areaNode.SelectNodes("Titles/Title")) { area.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } } if (settings.ExportDescriptions) { foreach (XmlNode titleNode in areaNode.SelectNodes("Descriptions/Description")) { area.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } } crmSiteMapAreas.Add(area); #region Export Groups var groupNodes = areaNode.SelectNodes("Group"); foreach (XmlNode groupNode in groupNodes) { var group = new CrmSiteMapGroup { Id = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value, SiteMapId = siteMap.Id, SiteMapName = siteMap.GetAttributeValue <string>("sitemapname") }; if (settings.ExportNames) { foreach (XmlNode titleNode in groupNode.SelectNodes("Titles/Title")) { group.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } } if (settings.ExportDescriptions) { foreach (XmlNode titleNode in groupNode.SelectNodes("Descriptions/Description")) { group.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } } crmSiteMapGroups.Add(group); #region Export SubArea var subAreaNodes = groupNode.SelectNodes("SubArea"); foreach (XmlNode subAreaNode in subAreaNodes) { var subArea = new CrmSiteMapSubArea() { Id = subAreaNode.Attributes["Id"].Value, GroupId = groupNode.Attributes["Id"].Value, AreaId = areaNode.Attributes["Id"].Value, SiteMapId = siteMap.Id, SiteMapName = siteMap.GetAttributeValue <string>("sitemapname") }; if (settings.ExportNames) { foreach (XmlNode titleNode in subAreaNode.SelectNodes("Titles/Title")) { subArea.Titles.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Title"].Value); } } if (settings.ExportDescriptions) { foreach (XmlNode titleNode in subAreaNode.SelectNodes("Descriptions/Description")) { subArea.Descriptions.Add(int.Parse(titleNode.Attributes["LCID"].Value), titleNode.Attributes["Description"].Value); } } crmSiteMapSubAreas.Add(subArea); } #endregion Export SubArea } #endregion Export Groups } #endregion Export Area } #region Area sheet foreach (var crmArea in crmSiteMapAreas) { if (settings.ExportNames) { line++; cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.SiteMapName; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.SiteMapId.ToString(); ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } } if (settings.ExportDescriptions) { line++; cell = 0; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.SiteMapName; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.SiteMapId.ToString(); ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Id; ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(areaSheet, line, cell++).Value = crmArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } } } #endregion Area sheet #region Group sheet line = 0; foreach (var crmGroup in crmSiteMapGroups) { if (settings.ExportNames) { line++; cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.SiteMapName; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.SiteMapId.ToString(); ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Titles.FirstOrDefault(n => n.Key == lcid).Value; } } if (settings.ExportDescriptions) { line++; cell = 0; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.SiteMapName; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.SiteMapId.ToString(); ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.AreaId; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Id; ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(groupSheet, line, cell++).Value = crmGroup.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } } } #endregion Group sheet #region SubArea sheet line = 0; foreach (var crmSubArea in crmSiteMapSubAreas) { if (settings.ExportNames) { line++; cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.SiteMapName; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.SiteMapId.ToString(); ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Title"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Titles.FirstOrDefault(n => n.Key == lcid).Value; } } if (settings.ExportDescriptions) { line++; cell = 0; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.SiteMapName; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.SiteMapId.ToString(); ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.AreaId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.GroupId; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Id; ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = "Description"; foreach (var lcid in languages) { ZeroBasedSheet.Cell(subAreaSheet, line, cell++).Value = crmSubArea.Descriptions.FirstOrDefault(n => n.Key == lcid).Value; } } } #endregion SubArea sheet // Applying style to cells for (int i = 0; i < 4 + languages.Count; i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(areaSheet, 0, i).Style); } for (int i = 1; i <= crmSiteMapAreas.Select(c => c.Titles).Count() + crmSiteMapAreas.Select(c => c.Descriptions).Count(); i++) { for (int j = 0; j < 4; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(areaSheet, i, j).Style); } } for (int i = 0; i < 5 + languages.Count; i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(groupSheet, 0, i).Style); } for (int i = 1; i <= crmSiteMapGroups.Select(c => c.Titles).Count() + crmSiteMapGroups.Select(c => c.Descriptions).Count(); i++) { for (int j = 0; j < 5; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(groupSheet, i, j).Style); } } for (int i = 0; i < 6 + languages.Count; i++) { StyleMutator.TitleCell(ZeroBasedSheet.Cell(subAreaSheet, 0, i).Style); } for (int i = 1; i <= crmSiteMapSubAreas.Select(c => c.Titles).Count() + crmSiteMapSubAreas.Select(c => c.Descriptions).Count(); i++) { for (int j = 0; j < 6; j++) { StyleMutator.HighlightedCell(ZeroBasedSheet.Cell(subAreaSheet, i, j).Style); } } }