protected override void OnClick() { IMxDocument pMxDoc = ArcMap.Application.Document as IMxDocument; IMap pMap = pMxDoc.FocusMap; IFeatureLayer pFeatLayer = pMap.Layer[0] as IFeatureLayer; IFeatureSelection featSel = pFeatLayer as IFeatureSelection; ISimpleFillSymbol polySym = new SimpleFillSymbol(); IRgbColor pColor = new RgbColor(); pColor.Red = 0; pColor.Green = 250; pColor.Blue = 0; IRgbColor pOutColor = new RgbColor(); pOutColor.Red = 0; pOutColor.Green = 0; pOutColor.Blue = 250; ILineSymbol pLineSym = new SimpleLineSymbol(); pLineSym.Color = pOutColor; pLineSym.Width = 2; polySym.Color = pColor; polySym.Outline = pLineSym; featSel.SetSelectionSymbol = true; featSel.SelectionSymbol = polySym as ISymbol; // ArcMap.Application.CurrentTool = null; }
/// <summary> /// Adds a mapping from the given RGB color to the given ARGB color. /// </summary> /// <param name="source">The source RGB color.</param> /// <param name="destination">The destination ARGB color.</param> /// <exception cref="T:System.ArgumentException">The <paramref name="source"/> and <paramref name="destination"/> colors are /// identical, and thus this mapping is trivial.</exception> public void AddMapping(RgbColor source, ArgbColor destination) { if (source.ToArgb() == destination.ToArgb()) throw new ArgumentException( "source and destination colors are identical. Trivial mappings may not be explicitly defined."); map.Add(source, destination); }
/// <summary> /// Convert a color to a string /// </summary> /// <param name="color">the windows forms color</param> /// <returns>the color in a string</returns> private static string ConvertColor(System.Drawing.Color color) { int i = color.ToArgb(); byte r = (byte)((i >> 16) & 255); byte g = (byte)((i >> 8) & 255); byte b = (byte)(i & 255); RgbColor rgbColor = new RgbColor(r, g, b); return rgbColor.ToString(); }
internal void AddPPGeocodedPoint(double lat, double lng) { // Set the coordinate system of the data frame. ArcMap.Document.ActiveView.FocusMap.SpatialReference = DefineGCS(); ArcMap.Document.ActiveView.Refresh(); IPoint iPoint = new PointClass(); // Set the coordinate system of your point to match your data frame iPoint.SpatialReference = DefineGCS(); iPoint.X = lng; iPoint.Y = lat; IMap map = ArcMap.Document.ActiveView as IMap; IGraphicsContainer graphicsContainer = (IGraphicsContainer)map; // Explicit Cast IElement element = null; // set the point color IColor pointColor = new RgbColor(); //pointColor.RGB = 255255255; pointColor.RGB = 255000000; // Marker symbols ESRI.ArcGIS.Display.ISimpleMarkerSymbol simpleMarkerSymbol = new SimpleMarkerSymbolClass(); simpleMarkerSymbol.Color = pointColor; simpleMarkerSymbol.Outline = true; simpleMarkerSymbol.OutlineColor = pointColor; simpleMarkerSymbol.Size = 10; simpleMarkerSymbol.Style = esriSimpleMarkerStyle.esriSMSCircle; // Marker element IMarkerElement markerElement = new MarkerElementClass(); markerElement.Symbol = simpleMarkerSymbol; markerElement.Symbol.Color = pointColor; element = (IElement)markerElement; // Explicit Cast // set the element name IElementProperties3 elemProperties = element as IElementProperties3; elemProperties.Name = string.Concat(lng, " ,", lat); elemProperties.AnchorPoint = esriAnchorPointEnum.esriCenterPoint; // Add the element to a graphics container and refresh the ActiveView if (!(element == null)) { element.Geometry = iPoint; graphicsContainer.AddElement(element, 0); IEnvelope envelope = new EnvelopeClass(); envelope = ArcMap.Document.ActiveView.Extent; envelope.CenterAt(iPoint); //ArcMap.Document.ActiveView.Extent = envelope; //map.MapScale = 2400; map.MapScale = 5000; ArcMap.Document.ActiveView.Refresh(); } }
public override byte[] Render() { if (TimePassed(5)) { if (FirstFrame) { Image.SetAll(_bgcolor); } for (int i = 0; i < LedCount; i++) { if (_pixelArray[i] > 256) { _pixelArray[i] = _pixelArray[i] - 500 / (256 - _speed) * 4 > 0 ? _pixelArray[i] - 500 / (256 - _speed) * 4 : 0; } else { _pixelArray[i] = _pixelArray[i] - 500 / (256 - _speed) > 0 ? _pixelArray[i] - 500 / (256 - _speed) : 0; } } if (Rndm.Next(1000) < _count) { var index = RndmIndex(); if (_pixelArray[index] < 0.1) { _pixelArray[index] = 510; } } for (int i = 0; i < LedCount; i++) { if (_pixelArray[i] != 0) { RgbColor newColor; if (_pixelArray[i] > 255) { newColor = RgbColor.Transition(_color, _bgcolor, ((_pixelArray[i] - 255) + 1) / 256, _evenColors); } else { newColor = RgbColor.Transition(_bgcolor, _color, (_pixelArray[i] + 1) / 256, _evenColors); } Image.Leds[i] = newColor; } else { Image.Leds[i] = _bgcolor; } } return(Image.ToByteArray()); } return(null); }
private void ReadColors(BinaryReader reader, Swatch swatch, int count, short version) { for (int i = 0; i < count; i++) { var space = (ColorSpace)reader.ReadInt16(); var item1 = reader.ReadUInt16(); var item2 = reader.ReadUInt16(); var item3 = reader.ReadUInt16(); var item4 = reader.ReadUInt16(); ColorBase color = null; switch (space) { case ColorSpace.RGB: color = new RgbColor(Convert.ToByte(item1 / 256), Convert.ToByte(item2 / 256), Convert.ToByte(item3 / 256)); break; case ColorSpace.HSB: color = new HsvColor(item1 / 65535f, item2 / 65535f, item3 / 65535f); break; case ColorSpace.Grayscale: color = new GrayColor(item1 / 10000f); break; case ColorSpace.CMYK: color = new CmykColor(1f - (item1 / 65535f), 1f - (item2 / 65535f), 1f - (item3 / 65535f), 1f - (item4 / 65535f)); break; case ColorSpace.WideCMYK: color = new CmykColor(item1 / 10000f, item2 / 10000f, item3 / 10000f, item4 / 10000f); break; case ColorSpace.Lab: color = new LabColor((short)(item1 / 100), (short)(item2 / 100), (short)(item3 / 100)); break; default: break; } if (version == 2) { reader.ReadBytes(2); var nameLength = reader.ReadInt16() * 2; if (nameLength > 0) { var nameBuffer = reader.ReadBytes(nameLength); color.Name = Encoding.BigEndianUnicode.GetString(nameBuffer, 0, nameLength - 2); } } swatch.Colors.Add(color); } }
internal static ICmyk TranslateColor(IRgb rgb, Uri cmykProfile, Uri rgbProfile) { const double dividend = 65535; var profileName = new StringBuilder(256); var size = (uint)profileName.Capacity * 2; ProfileFilename sRgbFilename; if (rgbProfile == null) { GetStandardColorSpaceProfile(0, LogicalColorSpace.SRgb, profileName, ref size); sRgbFilename = new ProfileFilename(profileName.ToString()); } else { sRgbFilename = new ProfileFilename(rgbProfile.LocalPath); } var hSRgbProfile = OpenColorProfile(sRgbFilename, ProfileRead, FileShare.Read, CreateDisposition.OpenExisting); var isoCoatedFilename = new ProfileFilename(cmykProfile.LocalPath); var hIsoCoatedProfile = OpenColorProfile(isoCoatedFilename, ProfileRead, FileShare.Read, CreateDisposition.OpenExisting); var profiles = new[] { hSRgbProfile, hIsoCoatedProfile }; var intents = new[] { IntentPerceptual }; var transform = CreateMultiProfileTransform(profiles, 2, intents, 1, ColorTransformMode.BestMode, IndexDontCare); var rgbColors = new RgbColor[1]; rgbColors[0] = new RgbColor(); var cmykColors = new CmykColor[1]; cmykColors[0] = new CmykColor(); rgbColors[0].red = (ushort)(rgb.R * dividend / 255.0); rgbColors[0].green = (ushort)(rgb.G * dividend / 255.0); rgbColors[0].blue = (ushort)(rgb.B * dividend / 255.0); TranslateColors(transform, rgbColors, 1, ColorType.Rgb, cmykColors, ColorType.Cmyk); DeleteColorTransform(transform); CloseColorProfile(hSRgbProfile); CloseColorProfile(hIsoCoatedProfile); return(new Cmyk { C = cmykColors[0].cyan / dividend, M = cmykColors[0].magenta / dividend, Y = cmykColors[0].yellow / dividend, K = cmykColors[0].black / dividend }); }
private void btnLabel_Click(object sender, RoutedEventArgs e) { //The FeatureLayer for labelling IFeatureLayer labelLayer = this.m_map.Map.get_Layer(0) as IFeatureLayer; IGeoFeatureLayer gLabelLayer = labelLayer as IGeoFeatureLayer; IAnnotateLayerPropertiesCollection annoPropCol = gLabelLayer.AnnotationProperties; annoPropCol.Clear(); //ITextSymbol uasage ITextSymbol pTextSyl = new TextSymbol(); //Font fnt = new System.Drawing.Font("宋体", 10f, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point); //using stdole IFontDisp font = new StdFont() as IFontDisp; font.Size = 20; font.Italic = true; // pTextSyl.Size = 20; pTextSyl.Font = font; //IRgbColor fromColor = new RgbColor(255,0, 0); //ESRI.ArcGIS.Display.RgbColorClass() RgbColor color = new RgbColor(); color.Red = 255; color.Green = 0; color.Blue = 0; pTextSyl.Color = color; //Position IBasicOverposterLayerProperties pBasic = new BasicOverposterLayerProperties(); // if (labelLayer.FeatureClass.ShapeType == esriGeometryType.esriGeometryPoint) // { IPointPlacementPriorities pPlacementPoint = new PointPlacementPriorities(); pBasic.FeatureType = esriBasicOverposterFeatureType.esriOverposterPoint; pBasic.PointPlacementPriorities = pPlacementPoint; pBasic.PointPlacementOnTop = false; pBasic.PointPlacementMethod = esriOverposterPointPlacementMethod.esriOnTopPoint;// esriAroundPoint; // } //Point a field as a label ILabelEngineLayerProperties labelField = new LabelEngineLayerProperties() as ILabelEngineLayerProperties; labelField.Expression = "[name]"; //set postion labelField.BasicOverposterLayerProperties = pBasic; //set symbol labelField.Symbol = pTextSyl; IAnnotateLayerProperties annoProp = labelField as IAnnotateLayerProperties; annoPropCol.Add(annoProp); gLabelLayer.DisplayAnnotation = true; m_map.Refresh(); }
public void MixWithIsNotAssociative() { // Counter-example var x = new RgbColor(67, 108, 13); var y = new RgbColor(33, 114, 130); var z = new RgbColor(38, 104, 245); Assert.NotEqual( x.MixWith(y).MixWith(z), x.MixWith(y.MixWith(z))); }
public override void RegisterSample(RgbColor weight, float misWeight, Vector2 pixel, int cameraPathLength, int lightPathLength, int fullLength) { if (!RenderTechniquePyramid) { return; } weight /= NumIterations; techPyramidRaw.Add(cameraPathLength, lightPathLength, fullLength, pixel, weight); techPyramidWeighted.Add(cameraPathLength, lightPathLength, fullLength, pixel, weight * misWeight); }
private static LabColor RgbToLabColor(RgbColor color) { using (var bitmap = new Aurigma.GraphicsMill.Bitmap(1, 1, PixelFormat.Format24bppRgb, color)) { bitmap.ColorProfile = ColorProfile.FromSrgb(); bitmap.ColorManagement.Convert(PixelFormat.Format24bppLab); return((LabColor)bitmap.GetPixel(0, 0)); } }
public void DrawSelGeometry() { ((IGraphicsContainer)this.m_app.FocusMap).DeleteAllElements(); if (this.m_pDrawGeo != null) { IRgbColor rgbColor = new RgbColor(); IRgbColor selectionCorlor = this.m_app.Config.SelectionEnvironment.DefaultColor as IRgbColor; rgbColor.Blue = ((int)selectionCorlor.Blue); rgbColor.Green = ((int)selectionCorlor.Green); rgbColor.Red = ((int)selectionCorlor.Red); rgbColor.Transparency = (selectionCorlor.Transparency); object obj = null; int selectionBufferInPixels = this.m_app.Config.SelectionEnvironment.SearchTolerance; ISymbol symbol = null; switch ((int)this.m_pDrawGeo.GeometryType) { case 1: { ISimpleMarkerSymbol simpleMarkerSymbol = new SimpleMarkerSymbol(); symbol = (ISymbol)simpleMarkerSymbol; symbol.ROP2 = (esriRasterOpCode)(10); simpleMarkerSymbol.Color = (rgbColor); simpleMarkerSymbol.Size = ((double)(selectionBufferInPixels + selectionBufferInPixels + selectionBufferInPixels)); break; } case 3: { ISimpleLineSymbol simpleLineSymbol = new SimpleLineSymbol(); symbol = (ISymbol)simpleLineSymbol; symbol.ROP2 = (esriRasterOpCode)(10); simpleLineSymbol.Color = (rgbColor); simpleLineSymbol.Color.Transparency = (1); simpleLineSymbol.Width = ((double)selectionBufferInPixels); break; } case 4: case 5: { ISimpleFillSymbol simpleFillSymbol = new SimpleFillSymbol(); symbol = (ISymbol)simpleFillSymbol; symbol.ROP2 = (esriRasterOpCode)(10); simpleFillSymbol.Color = (rgbColor); simpleFillSymbol.Color.Transparency = (1); break; } } obj = symbol; this.m_app.MapControl.DrawShape(this.m_pDrawGeo, ref obj); } }
public void DrawEnvelope(IEnvelope envelope) { if (envelope == null) { return; } try { //将鹰眼地图设置为地理容器,再设置为活动视图 IGraphicsContainer pGraphicsContainer = this.axMapControl.Map as IGraphicsContainer; IActiveView pActiveView = pGraphicsContainer as IActiveView; //清除鹰眼地图中的任何图形元素 pGraphicsContainer.DeleteAllElements(); //设置矩形范围 IRectangleElement pRectangeEle = new RectangleElementClass(); IElement pElement = pRectangeEle as IElement; pElement.Geometry = envelope; //创建鹰眼图中的红线框 IRgbColor pColor = new RgbColor(); pColor.Red = 255; pColor.Blue = 0; pColor.Green = 0; pColor.Transparency = 255; //创建线符号对象 ILineSymbol pOutline = new SimpleLineSymbolClass(); pOutline.Width = 2; pOutline.Color = pColor; //设置颜色属性 pColor = new RgbColorClass(); pColor.Red = 255; pColor.Blue = 0; pColor.Green = 0; pColor.Transparency = 0; //设置填充符号 IFillSymbol pFillSymbol = new SimpleFillSymbolClass(); pFillSymbol.Color = pColor; pFillSymbol.Outline = pOutline; IFillShapeElement pFillShapeEle = pElement as IFillShapeElement; pFillShapeEle.Symbol = pFillSymbol; pGraphicsContainer.AddElement((IElement)pFillShapeEle, 0); pActiveView.PartialRefresh(esriViewDrawPhase.esriViewGraphics, null, null); interEnvelope = envelope; } catch (Exception ex) { LoggingService.Error(ex.Message + "\r\n" + ex.StackTrace); } }
private static void RgbToLabWithColorManagement() { RgbColor rgbColor = new RgbColor(223, 210, 30) { Profile = ColorProfile.FromSrgb() }; LabColor labColor = rgbColor.To <LabColor>(); Console.WriteLine("With color management: {0} to {1}", rgbColor, labColor); }
public async Task ExecuteAsync() { var senseHat = _senseHatFactory.Create(); var foregroundPink = new RgbColor(255, 0, 255); var config = _ledPixelConfigFactory.CreateForNumber( 1, foregroundPink, RgbColor.CreateBlack()); await senseHat.LedMatrix.ShowPixels(config); }
public void SetColor(RgbColor color) { // Keyboard CueSDK.KeyboardSDK.Brush = (SolidColorBrush)color.GetColor(); foreach (var corsairLed in _keyboard.GetLeds()) { corsairLed.Color = color.GetColor(); } _keyboard.Update(); // TODO: Mouse, Mousepad, and headset }
public HtmlColorSample(string name, RgbColor @base, string hex, HtmlColorSampleRgb rgb, HtmlColorSampleHsl hsl, HtmlColorSampleHsv hsv, HtmlColorSampleCmy cmy, HtmlColorSampleCmyk cmyk) { Name = name; Base = @base; Hex = hex; Rgb = rgb; Hsl = hsl; Hsv = hsv; Cmy = cmy; Cmyk = cmyk; }
protected override RgbColor OnInvalidHit(Ray ray, float pdfFromAncestor, RgbColor throughput, int depth) { path.Vertices.Add(new PathPdfPair { PdfFromAncestor = pdfFromAncestor, PdfToAncestor = 0 }); path.Throughput = throughput; path.Distances.Add(float.PositiveInfinity); return(integrator.OnBackgroundHit(ray, path)); }
private static void RgbToCmykWithColorManagement() { RgbColor rgbColor = new RgbColor(253, 202, 12) { Profile = ColorProfile.FromSrgb() }; CmykColor cmykColor = rgbColor.To <CmykColor>("../../../../_Input/ColorProfiles/ISOcoated_v2_eci.icc", transformationIntent: ColorTransformationIntent.Perceptual); Console.WriteLine("With color management: {0} to {1}", rgbColor, cmykColor); }
private static void CmykToRgbWithColorManagement() { CmykColor cmykColor = new CmykColor(20, 42, 211, 40) { Profile = new ColorProfile("../../../../_Input/ColorProfiles/ISOcoated_v2_eci.icc") }; RgbColor rgbColor = cmykColor.To <RgbColor>(ColorProfile.FromSrgb()); Console.WriteLine("With color management: {0} to {1}", cmykColor, rgbColor); }
public void TurnOffHalfWayThroughSecondBlink() { animation.RepeatBlink = 2; for (int i = animation.DurationBlink + animation.DurationBlink / 2; i < animation.DurationBlink * 2; i++) { RgbColor newColor = animation.GetColor(StartTime, StartTime.AddMilliseconds(i)); Assert.AreEqual(RgbColor.Black().ToString(), newColor.ToString()); } Assert.IsTrue(!animation.AnimationFinished); }
private static void SymbolInit() { //设置各种地图符号的颜色 IRgbColor pFcolor; IRgbColor pOcolor; IRgbColor pTrackcolor; IRgbColor pVcolor; IRgbColor pSColor; pFcolor = new RgbColor(); pOcolor = new RgbColor(); pTrackcolor = new RgbColor(); pVcolor = new RgbColor(); pSColor = new RgbColor(); pFcolor = MapManager.GetRgbColor(255, 0, 0); pOcolor = MapManager.GetRgbColor(0, 0, 255); pTrackcolor = MapManager.GetRgbColor(0, 255, 255); pVcolor = MapManager.GetRgbColor(0, 255, 0); pSColor = MapManager.GetRgbColor(0, 0, 0); //设置各种地图符号的属性 m_markerSym = new SimpleMarkerSymbol(); m_markerSym.Style = esriSimpleMarkerStyle.esriSMSCircle; m_markerSym.Color = pFcolor; m_markerSym.Outline = true; m_markerSym.OutlineColor = pOcolor; m_markerSym.OutlineSize = 1; m_vertexSym = new SimpleMarkerSymbol(); m_vertexSym.Style = esriSimpleMarkerStyle.esriSMSSquare; m_vertexSym.Color = pVcolor; m_vertexSym.Size = 4; m_selPointSym = new SimpleMarkerSymbol(); m_selPointSym.Style = esriSimpleMarkerStyle.esriSMSSquare; m_selPointSym.Color = pSColor; m_selPointSym.Size = 4; m_endPointSym = new SimpleMarkerSymbol(); m_endPointSym.Style = esriSimpleMarkerStyle.esriSMSSquare; m_endPointSym.Color = pFcolor; m_endPointSym.Size = 4; m_lineSym = new SimpleLineSymbol(); m_lineSym.Color = pFcolor; m_lineSym.Width = 1; m_tracklineSym = new SimpleLineSymbol(); m_tracklineSym.Color = pTrackcolor; m_tracklineSym.Width = 1; ISimpleLineSymbol pOsym = default(ISimpleLineSymbol); pOsym = new SimpleLineSymbol(); pOsym.Color = pOcolor; pOsym.Width = 1; m_fillSym = new SimpleFillSymbol(); m_fillSym.Color = pFcolor; m_fillSym.Style = esriSimpleFillStyle.esriSFSVertical; m_fillSym.Outline = pOsym; }
public override void OnCreate(object hook) { this.m_caption = "节点编辑工具"; this.m_category = "编辑"; this.m_toolTip = "节点编辑工具"; this.m_name = "Edit_VerticsEdit"; _context = hook as IAppContext; this._key = "Edit_VerticsEdit"; base._itemType = RibbonItemType.Tool; this.m_cursor = new System.Windows.Forms.Cursor( base.GetType() .Assembly.GetManifestResourceStream("Yutai.Plugins.Editor.Resources.Cursor.DeleteVertex.cur")); this.isymbol_0 = new SimpleMarkerSymbol() as ISymbol; (this.isymbol_0 as ISimpleMarkerSymbol).Style = esriSimpleMarkerStyle.esriSMSSquare; (this.isymbol_0 as ISimpleMarkerSymbol).Size = 6; (this.isymbol_0 as ISimpleMarkerSymbol).Outline = true; IRgbColor rgbColorClass = new RgbColor() { Red = 255, Green = 0, Blue = 0 }; (this.isymbol_0 as ISimpleMarkerSymbol).OutlineColor = rgbColorClass; (this.isymbol_0 as ISimpleMarkerSymbol).OutlineSize = 2; IRgbColor rgbColor = new RgbColor() { NullColor = true }; (this.isymbol_0 as ISimpleMarkerSymbol).Color = rgbColor; (_context as IApplicationEvents).OnActiveHookChanged += new OnActiveHookChangedHandler(this.App_ActiveHookChanged); if (this.iactiveViewEvents_Event_0 != null) { try { this.iactiveViewEvents_Event_0.AfterDraw -= new IActiveViewEvents_AfterDrawEventHandler(this.ActiveView_AfterDraw); } catch { } } if (_context.FocusMap != null) { this.iactiveViewEvents_Event_0 = _context.ActiveView as IActiveViewEvents_Event; this.iactiveViewEvents_Event_0.AfterDraw += new IActiveViewEvents_AfterDrawEventHandler(this.ActiveView_AfterDraw); } }
public static IRgbColor MakeRGB(int int_0, int int_1, int int_2) { IRgbColor rgbColorClass = new RgbColor() { Red = int_0, Green = int_1, Blue = int_2 }; return(rgbColorClass); }
public static RgbColor RgbColor(System.Drawing.Color col) { RgbColor c = new RgbColor(); c.Red = col.R; c.Green = col.G; c.Blue = col.B; c.AlphaValue = col.A; return(c); }
/// <summary> /// Calculates the overall color at a specific location. /// </summary> /// <param name="configuration">The configuration.</param> /// <param name="x">The location x.</param> /// <param name="radius">The analyzation radius.</param> /// <param name="quality">The quality (higher is better).</param> /// <returns>The overall color at a specific location.</returns> private static RgbColor CalculateColorAt(MultislitConfiguration configuration, double x, double radius, int quality) { RgbColor result = new RgbColor(0, 0, 0); foreach (WavelengthColorPair light in configuration.LightSources) { result = result + (light.Color * MultiSlitIntensityCalculator.CalculateIntensity(light.Wavelength, configuration.Slits, x, radius, quality)); } return(result); }
public ActionResult DbEkle(string Renk) { // Arduino ile bağlantı kuruyorum. Eğer bağlantıda sorun çıkarsa catch'e atlayıp sayfayı yeniliyorum try { // Hex kodu int olarak renklere ayırıyorum string colour = Renk.TrimStart('#'); int red = int.Parse(colour.Substring(0, 2), NumberStyles.AllowHexSpecifier); int green = int.Parse(colour.Substring(2, 2), NumberStyles.AllowHexSpecifier); int blue = int.Parse(colour.Substring(4, 2), NumberStyles.AllowHexSpecifier); // Arduino ile bağlantı kurulmaya çalışılıyor TcpClient TcpAc = new TcpClient("192.168.1.13", 8090); NetworkStream networkStream = TcpAc.GetStream(); StreamWriter streamWriter = new StreamWriter(networkStream); StreamReader streamReader = new StreamReader(networkStream); // Arduino'ya renklerin aralarına '+' işareti koyarak mesaj gönderiyorum. En sona hex kodu ekliyorum streamWriter.Write(red + "+" + green + "+" + blue + "+" + Renk + "\n"); streamWriter.Flush(); // Arduino'dan gelen mesaja bakıyorum. Eğer renk aynı mesajı geldiyse bağlantıyı sonlandırıp sayfayı yeniliyorum if (streamReader.ReadToEnd() == "Renk aynı") { networkStream.Close(); return(RedirectToAction("Index", "Home")); } // Renk aynı değilse bağlantıyı sonlandırıp veri tabanına verileri ekliyorum. Sayfayı yeniliyorum else { networkStream.Close(); Led database1 = new Led(); RgbColor database2 = new RgbColor(); database1.Color = Renk; database1.IsOpen = true; database1.Time = DateTime.Now; database2.LastColor = Renk; db.Leds.Add(database1); db.RgbColors.Add(database2); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } catch { return(RedirectToAction("Index", "Home")); } }
public async Task Can_replace_OneToOne_relationship_from_principal_side() { // Arrange List <WorkItemGroup> existingGroups = _fakers.WorkItemGroup.Generate(2); existingGroups[0].Color = _fakers.RgbColor.Generate(); existingGroups[1].Color = _fakers.RgbColor.Generate(); await _testContext.RunOnDatabaseAsync(async dbContext => { dbContext.Groups.AddRange(existingGroups); await dbContext.SaveChangesAsync(); }); var requestBody = new { data = new { type = "rgbColors", id = existingGroups[0].Color.StringId } }; string route = $"/workItemGroups/{existingGroups[1].StringId}/relationships/color"; // Act (HttpResponseMessage httpResponse, string responseDocument) = await _testContext.ExecutePatchAsync <string>(route, requestBody); httpResponse.Should().HaveStatusCode(HttpStatusCode.NoContent); responseDocument.Should().BeEmpty(); await _testContext.RunOnDatabaseAsync(async dbContext => { List <WorkItemGroup> groupsInDatabase = await dbContext.Groups.Include(group => group.Color).ToListAsync(); WorkItemGroup groupInDatabase1 = groupsInDatabase.Single(group => group.Id == existingGroups[0].Id); groupInDatabase1.Color.Should().BeNull(); WorkItemGroup groupInDatabase2 = groupsInDatabase.Single(group => group.Id == existingGroups[1].Id); groupInDatabase2.Color.Should().NotBeNull(); groupInDatabase2.Color.Id.Should().Be(existingGroups[0].Color.Id); List <RgbColor> colorsInDatabase = await dbContext.RgbColors.Include(color => color.Group).ToListAsync(); RgbColor colorInDatabase1 = colorsInDatabase.Single(color => color.Id == existingGroups[0].Color.Id); colorInDatabase1.Group.Should().NotBeNull(); colorInDatabase1.Group.Id.Should().Be(existingGroups[1].Id); RgbColor colorInDatabase2 = colorsInDatabase.SingleOrDefault(color => color.Id == existingGroups[1].Color.Id); colorInDatabase1.Should().NotBeNull(); colorInDatabase2 !.Group.Should().BeNull(); }); }
private void setColor(RgbColor color) { Color c = color.ToColor(); colorControl.SelectedColor = c; if (NeedUpdateUI != null) { NeedUpdateUI(this, EventArgs.Empty); } }
/// <summary> /// 文字颜色 /// </summary> /// <params name="red"></params> /// <params name="green"></params> /// <params name="blue"></params> /// <returns></returns> private IRgbColor GetRGBColor(int red, int green, int blue) { //创建rgb颜色和实例化IRGBColor接口 IRgbColor rGB = new RgbColor(); //设置RGB属性 rGB.Red = red; rGB.Green = green; rGB.Blue = blue; rGB.UseWindowsDithering = true; return(rGB); }
private static IColor BuildRGB(int int_0, int int_1, int int_2) { IRgbColor rgbColorClass = new RgbColor() { Red = int_0, Green = int_1, Blue = int_2, UseWindowsDithering = true }; return(rgbColorClass); }
private void clarionLongTextBox_TextChanged(object sender, EventArgs e) { if (!_ignoreTextFieldChange) { _changingControl = (Control)sender; notifyValueChangedByUser(LeadingInputElement.ClarionLongInput); setColor(RgbColor.FromColor(ColorTranslator.FromOle(Int32.Parse(clarionLongTextBox.Text)))); _changingControl = null; } }
private void button2_Click(object sender, EventArgs e) { if (colorDialog1.ShowDialog() == DialogResult.OK) { textBox1.BackColor = colorDialog1.Color; Form1.fontColor = colorDialog1.Color; } IColor pColor = new RgbColor(); pColor.RGB = 255; }
public void FromHex() { foreach (HtmlColorSample sample in HtmlColorSamples.All) { string hex = sample.Hex; RgbColor colorTest = ColorUtils.HexToRgb(hex); Assert.AreEqual(sample.Hex, colorTest.ToHex(), sample.Name); Assert.AreEqual(sample.Rgb.Red, colorTest.Red, sample.Name); Assert.AreEqual(sample.Rgb.Green, colorTest.Green, sample.Name); Assert.AreEqual(sample.Rgb.Blue, colorTest.Blue, sample.Name); } }
//��˸�� public static void FlashPoint(IMapControlDefault mapControl, IScreenDisplay iScreenDisplay, IGeometry iGeometry) { ISimpleMarkerSymbol iMarkerSymbol; ISymbol iSymbol; IRgbColor iRgbColor; iMarkerSymbol = new SimpleMarkerSymbol(); iMarkerSymbol.Style = esriSimpleMarkerStyle.esriSMSCircle; iRgbColor = new RgbColor(); iRgbColor.RGB = System.Drawing.Color.FromArgb(0, 0, 0).ToArgb(); iMarkerSymbol.Color = iRgbColor; iSymbol = (ISymbol)iMarkerSymbol; iSymbol.ROP2 = esriRasterOpCode.esriROPNotXOrPen; mapControl.FlashShape(iGeometry, 5, 300, iSymbol); }
//��˸�� public static void FlashLine(IMapControlDefault mapControl, IScreenDisplay iScreenDisplay, IGeometry iGeometry) { ISimpleLineSymbol iLineSymbol; ISymbol iSymbol; IRgbColor iRgbColor; iLineSymbol = new SimpleLineSymbol(); iLineSymbol.Width = 4; iRgbColor = new RgbColor(); iRgbColor.Red = 255; iLineSymbol.Color = iRgbColor; iSymbol = (ISymbol)iLineSymbol; iSymbol.ROP2 = esriRasterOpCode.esriROPNotXOrPen; mapControl.FlashShape(iGeometry, 5, 300, iSymbol); }
protected override void OnClick() { try { IMxDocument mxDoc = ArcMap.Document; IMap map = mxDoc.FocusMap; IGraphicsContainer graphicsCon = map as IGraphicsContainer; graphicsCon.Reset(); IElement element = graphicsCon.Next(); IRgbColor red = new RgbColor(); red.Blue = 0; red.Green = 0; red.Red = 255; IRgbColor green = new RgbColor(); green.Blue = 0; green.Green = 255; green.Red = 0; ISimpleFillSymbol fillSymbol = new SimpleFillSymbolClass(); fillSymbol.Color = green; fillSymbol.Outline.Color = red; // This change did not change the outline color in the display (a bug at 10.1) fillSymbol.Outline.Width = 3.0; // // This change did not change the outline width in the display (a bug at 10.1) // For assigning the symbol // -------------------------------------------------------------------------------- (element as IFillShapeElement).Symbol = fillSymbol; // -------------------------------------------------------------------------------- graphicsCon.DeleteAllElements(); (graphicsCon as IActiveView).Refresh(); graphicsCon.AddElement(element, 0); (graphicsCon as IActiveView).Refresh(); } catch (Exception myEx) { System.Diagnostics.Debug.WriteLine(myEx.Message + " " + myEx.Source.ToString()); } ArcMap.Application.CurrentTool = null; }
/// <summary> /// 文字颜色 /// </summary> /// <params name="red"></params> /// <params name="green"></params> /// <params name="blue"></params> /// <returns></returns> private IRgbColor GetRGBColor(int red, int green, int blue) { //创建rgb颜色和实例化IRGBColor接口 IRgbColor rGB = new RgbColor(); //设置RGB属性 rGB.Red = red; rGB.Green = green; rGB.Blue = blue; rGB.UseWindowsDithering = true; return rGB; }
private ESRI.ArcGIS.Display.IColor GetCombinedColor(IColor pColor1, IColor pColor2, EColorCombinationType eCombinationMethod, IColor pOriginColor) { // combines the input colors based on m_eColorCombinationMethod // (11/08/04) -- RGB and enuLabLChColorRamp aren't used by GUI IColor pOutColor = null; long MyOLE_COLOR = 0; // As OLE_COLOR in VB6 IRgbColor pMainRGBColor = null; IRgbColor pVariationRGBColor = null; IRgbColor pMergedRGBColor = null; bool bOK = false; IAlgorithmicColorRamp pAlgorithmicCR = null; // if either of the colors are null, then don't run the color through any algorithm, // instead, just return the other color. if both are null, then return a null color if (pColor1.NullColor) { pOutColor = pColor2; } else if (pColor2.NullColor) { pOutColor = pColor1; } else if (eCombinationMethod == EColorCombinationType.enuComponents) { // HSV components // create a new HSV color IHsvColor pHSVDrawColor = null; pHSVDrawColor = new HsvColor(); // get HSV values from Color1 and Color2 and assign to pHSVDrawColor IHsvColor pHSVColor1 = null; IHsvColor pHSVColor2 = null; // (new 4/27/04) didn't think I had to do this... //pHSVColor1 = pColor1 //pHSVColor2 = pColor2 pHSVColor1 = new HsvColor(); pHSVColor1.RGB = pColor1.RGB; pHSVColor2 = new HsvColor(); pHSVColor2.RGB = pColor2.RGB; pHSVDrawColor.Hue = pHSVColor1.Hue; pHSVDrawColor.Saturation = pHSVColor2.Saturation; pHSVDrawColor.Value = pHSVColor2.Value; pOutColor = pHSVDrawColor; } else if (eCombinationMethod == EColorCombinationType.enuRGBAverage) { // use additive color model to merge the two colors MyOLE_COLOR = pColor1.RGB; pMainRGBColor = new RgbColor(); pMainRGBColor.RGB = (int)MyOLE_COLOR; MyOLE_COLOR = pColor2.RGB; pVariationRGBColor = new RgbColor(); pVariationRGBColor.RGB = (int)MyOLE_COLOR; // merged color = RGB average of the two colors pMergedRGBColor = new RgbColor(); pMergedRGBColor.Red = (pMainRGBColor.Red + pVariationRGBColor.Red) / 2; pMergedRGBColor.Green = (pMainRGBColor.Green + pVariationRGBColor.Green) / 2; pMergedRGBColor.Blue = (pMainRGBColor.Blue + pVariationRGBColor.Blue) / 2; pOutColor = pMergedRGBColor; } else if ((eCombinationMethod == EColorCombinationType.enuCIELabColorRamp) | (eCombinationMethod == EColorCombinationType.enuLabLChColorRamp)) { // use color ramp and take central color between the two colors pAlgorithmicCR = new AlgorithmicColorRamp(); if (m_eColorCombinationMethod == EColorCombinationType.enuCIELabColorRamp) pAlgorithmicCR.Algorithm = esriColorRampAlgorithm.esriCIELabAlgorithm; else pAlgorithmicCR.Algorithm = esriColorRampAlgorithm.esriLabLChAlgorithm; pAlgorithmicCR.Size = 3; pAlgorithmicCR.FromColor = pColor1; pAlgorithmicCR.ToColor = pColor2; pAlgorithmicCR.CreateRamp(out bOK); pOutColor = pAlgorithmicCR.get_Color(1); // middle color in ramp } else // EColorCombinationType.enuCIELabMatrix { double[] iLab1 = new double[4]; // L, a, b values for Color1 double[] iLab2 = new double[4]; // L, a, b values for Color2 double[] iLabOrig = new double[4]; // L, a, b values for pOriginColor pColor1.GetCIELAB(out iLab1[0], out iLab1[1], out iLab1[2]); pColor2.GetCIELAB(out iLab2[0], out iLab2[1], out iLab2[2]); pOriginColor.GetCIELAB(out iLabOrig[0], out iLabOrig[1], out iLabOrig[2]); double[] iLabOut = new double[4]; // add color1 vector and color2 vector, then subtract the origin color vector iLabOut[0] = iLab1[0] + iLab2[0] - iLabOrig[0]; iLabOut[1] = iLab1[1] + iLab2[1] - iLabOrig[1]; iLabOut[2] = iLab1[2] + iLab2[2] - iLabOrig[2]; CorrectLabOutofRange(ref iLabOut[0], ref iLabOut[1], ref iLabOut[2]); IHsvColor pHSVColor = null; pHSVColor = new HsvColor(); pHSVColor.SetCIELAB(iLabOut[0], iLabOut[1], iLabOut[2]); pOutColor = pHSVColor; } return pOutColor; }
private bool addMarkerAtAdres(string Adres) { datacontract.locationResult loc = getAdres(Adres); IPoint fromXY; IPoint toXY; IRgbColor innerClr; IRgbColor outlineClr; if (loc != null ) { fromXY = new ESRI.ArcGIS.Geometry.Point() { X = loc.Location.Lon_WGS84, Y = loc.Location.Lat_WGS84, SpatialReference = wgs }; toXY = geopuntHelper.Transform(fromXY as IGeometry, map.SpatialReference) as IPoint; innerClr = new RgbColor() { Red = 255, Blue = 0, Green = 255 }; outlineClr = new RgbColor() { Red = 0, Blue = 0, Green = 0 }; geopuntHelper.AddGraphicToMap(map, toXY, innerClr, outlineClr, 12, false); geopuntHelper.AddTextElement(map , toXY, loc.FormattedAddress); infoLabel.Text = geopuntHelper.adresTypeStringTranslate(loc.LocationType); view.Refresh(); return true; } return false; }
private ISymbol GetFeatureSymbol(IFeature Feature) { ICartographicLineSymbol hashsym = null; IRgbColor pcolor = null; ILineSymbol lsym = null; // ISimpleEdgeFeature seFeat = null; ILineProperties lineProperties = null; IArrowMarkerSymbol aMSymbol = null; ILineDecoration lineDecoration = null; ISimpleLineDecorationElement simpleLineDecorationElement = null; IMarkerSymbol smSym = null; bool isMultiLyrSym = false; int multiLyrSymIndex = -1; try { if (Feature.HasOID) { int status = 0; if (string.Compare(Feature.Class.AliasName.Substring(Feature.Class.AliasName.LastIndexOf('.') + 1), "PrimaryConductor", true) == 0) { if (ExtensionInfo.netUtil.primaryStatuses.ContainsKey(Feature.OID)) status = ExtensionInfo.netUtil.primaryStatuses[Feature.OID]; } else if (ExtensionInfo.netUtil.secondaryStatuses.ContainsKey(Feature.OID)) status = ExtensionInfo.netUtil.secondaryStatuses[Feature.OID]; //int fldIndexGUID = Feature.Fields.FindField("FuturaGUID"); //if (fldIndexGUID != -1) //{ // IFeatureClass featCls = Feature.Class as IFeatureClass; // IFeature feat = featCls.GetFeature(Feature.OID); // string guid = feat.get_Value(fldIndexGUID).ToString(); // if (guid != null) // status = (int)NetworkExtension.FuturaNetworkExt.netUtil._sectionList[guid].status; //} // int status = NetworkExtension.FuturaNetworkExt.netUtil._sectionList.Values.FirstOrDefault(obj => (obj.objectId == Feature.OID && string.Compare(Feature.Class.AliasName.Substring(Feature.Class.AliasName.LastIndexOf('.')+1), obj.className, true) == 0)).status; // string guid = Feature.get_Value(Feature.Fields.FindField("FuturaGUID")).ToString(); // int status = NetworkExtension.FuturaNetworkExt.netUtil._sectionList[guid].status; pcolor = new RgbColor(); //FeatureRenderer.PrepareFilter(Feature.Class as IFeatureClass, new QueryFilterClass()); //below line used to get default linesymbol of a featureclass lsym = FeatureRenderer.get_SymbolByFeature(Feature) as ILineSymbol; if (lsym is ICartographicLineSymbol) hashsym = lsym as ICartographicLineSymbol; else if (lsym is IMultiLayerLineSymbol) { IMultiLayerLineSymbol multiLyrLineSymbol = lsym as IMultiLayerLineSymbol; for (int i = 0; i < multiLyrLineSymbol.LayerCount; i++) { if (multiLyrLineSymbol.get_Layer(i) != null && multiLyrLineSymbol.get_Layer(i) is ICartographicLineSymbol) { hashsym = multiLyrLineSymbol.get_Layer(i) as ICartographicLineSymbol; isMultiLyrSym = true; multiLyrSymIndex = i; break; } } } if (hashsym == null) { hashsym = new CartographicLineSymbolClass(); hashsym.Color = lsym.Color; hashsym.Width = lsym.Width; } if (FeatureSelection.SelectionSet.Count > 0 && IsSelected(Feature.OID)) { //if (MobileSettings.settings.UserSettings.TraceSettings.LineColor.R == 0 && MobileSettings.settings.UserSettings.TraceSettings.LineColor.G == 255 && MobileSettings.settings.UserSettings.TraceSettings.LineColor.B == 255) //{ // pcolor.Red = 0; // pcolor.Green = 255; // pcolor.Blue = 0; //} //else //{ pcolor.Red = 0; pcolor.Green = 255; pcolor.Blue = 255; // } //lsym.Color = pcolor; //lsym.Width = lsym.Width + 1; hashsym.Color = pcolor; hashsym.Width = hashsym.Width + 1; } else { //pcolor.Red = MobileSettings.settings.UserSettings.TraceSettings.LineColor.R; //pcolor.Green = MobileSettings.settings.UserSettings.TraceSettings.LineColor.G; //pcolor.Blue = MobileSettings.settings.UserSettings.TraceSettings.LineColor.B; //lsym.Color = pcolor; } if (Feature.Shape.GeometryType == esriGeometryType.esriGeometryLine || Feature.Shape.GeometryType == esriGeometryType.esriGeometryPolyline) { // SectionObject sObj = null; // Orientation dir = Orientation.Uninitialized; // seFeat = Feature as ISimpleEdgeFeature; // int fldIndexGUID = Feature.Fields.FindField(((IClassEx)Feature.Class).GlobalIDFieldName); // if(fldIndexGUID != -1) // { //IFeatureClass featCls = Feature.Class as IFeatureClass; //IFeature feat = featCls.GetFeature(Feature.OID); //object guid = feat.get_Value(fldIndexGUID); // if (guid != null) // sObj = secElements.ContainsKey(guid.ToString()) ? secElements[guid.ToString()] : null; //if(sObj != null) //{ // IPolyline pl = Feature.ShapeCopy as IPolyline; // NodeObject fNode = nodeElements.ContainsKey(sObj.Parent) ? nodeElements[sObj.Parent] : null; // NodeObject tNode = nodeElements.ContainsKey(sObj.Child) ? nodeElements[sObj.Child] : null; // if(fNode != null && tNode != null) // { // if (Math.Abs(fNode.X - pl.FromPoint.X) < 0.001 && Math.Abs(fNode.Y - pl.FromPoint.Y) < 0.001) // dir = Orientation.WithFlow; // else // dir = Orientation.AgainstFlow; // } //} // } //bool isPrimary = string.Compare(Feature.Class.AliasName, "PrimaryConductor", true) == 0; //try //{ // if (isPrimary && PrimaryFlowDirections != null) // dir = PrimaryFlowDirections[Feature.OID]; // // dir = secElements.Values.FirstOrDefault(obj => (obj.OID == Feature.OID && string.Compare(Feature.Class.AliasName, obj.LayerName, true) == 0)); // else if (SecFlowDirections != null) // dir = SecFlowDirections[Feature.OID]; //} //catch //{ // dir = Orientation.Uninitialized; //} //if (sObj != null) // { // dir = sObj.FlowDirection; //IPolyline pl = Feature.ShapeCopy as IPolyline; //NodeObject fNode = nodeElements.ContainsKey(sObj.Parent) ? nodeElements[sObj.Parent] : null; //NodeObject tNode = nodeElements.ContainsKey(sObj.Child) ? nodeElements[sObj.Child] : null; //if (fNode != null && tNode != null) //{ // bool isUninitialized = false; // if (string.Compare(fNode.LayerName, FuturaNetJunctions.Futura_NetJunctions_TableName, true) == 0 && secElements.Values.FirstOrDefault(obj => (obj.Child == fNode.GUID)) == null) // dir = Orientation.Indeterminate; // else // { // if (Math.Abs(fNode.X - pl.FromPoint.X) < 0.001 && Math.Abs(fNode.Y - pl.FromPoint.Y) < 0.001) // dir = Orientation.WithFlow; // else // dir = Orientation.AgainstFlow; // } //} // } lineProperties = hashsym as ILineProperties; simpleLineDecorationElement = new SimpleLineDecorationElement(); if (FuturaNetwork.StatusExtensions.IsLoop(status)) simpleLineDecorationElement.MarkerSymbol = DefaultUninitializedSymbol(); else if (FuturaNetwork.StatusExtensions.IsEnergized(status)) { //if (smSym == null) // smSym = Global.DefaultFlowSymbol(); if (FuturaNetwork.StatusExtensions.BreakDown(status).Contains(FuturaNetwork.Constants.WithFlow)) simpleLineDecorationElement.MarkerSymbol = DefaultFlowSymbol(false); else simpleLineDecorationElement.MarkerSymbol = DefaultFlowSymbol(true); } else simpleLineDecorationElement.MarkerSymbol = DefaultUninitializedSymbol(); simpleLineDecorationElement.AddPosition(0.5); simpleLineDecorationElement.PositionAsRatio = true; lineDecoration = new LineDecoration(); lineDecoration.AddElement(simpleLineDecorationElement); lineProperties.LineDecoration = lineDecoration; } ISymbol featSymbol = null; if (isMultiLyrSym && multiLyrSymIndex != -1) { IMultiLayerLineSymbol multiLyrLineSymbol = lsym as IMultiLayerLineSymbol; if (multiLyrLineSymbol.get_Layer(multiLyrSymIndex) != null && multiLyrLineSymbol.get_Layer(multiLyrSymIndex) is ICartographicLineSymbol) { ILineSymbol lineSymbol = multiLyrLineSymbol.get_Layer(multiLyrSymIndex); multiLyrLineSymbol.DeleteLayer(lineSymbol); multiLyrLineSymbol.AddLayer(hashsym as ILineSymbol); } featSymbol = multiLyrLineSymbol as ISymbol; } else featSymbol = hashsym as ISymbol; return featSymbol; } else { return null; } } catch (Exception ex) { //EngineLogger.Logger.LogException(ex); return null; } finally { hashsym = null; pcolor = null; lsym = null; //seFeat = null; lineProperties = null; aMSymbol = null; lineDecoration = null; simpleLineDecorationElement = null; smSym = null; } }
public IElement addTitleToLayout(IMxDocument pMxDoc,double S, double x, double y, IGraphicsContainer pGc, bool b, string texto) { ITextElement pTxtElem; ITextSymbol pTxtSym = default(ITextSymbol); IRgbColor myColor = default(IRgbColor); stdole.IFontDisp myFont; IElement pElem; IEnvelope pEnv; IPoint pPoint = default(IPoint); try{ // pGc.Reset() //Set the font and color properties //for the title myFont = (stdole.IFontDisp)new stdole.StdFont(); myFont.Name = "Times New Roman"; myFont.Bold = b; // myFont.Size = S; myColor = new RgbColor(); myColor.Red = 0; myColor.Green = 0; myColor.Blue = 0; ///'''''''''''''''''''''''''''''' //Create a text element pTxtElem = (ITextElement)new TextElement(); //Create a text symbol pTxtSym = new TextSymbol(); pTxtSym.Color = myColor; pTxtSym.Font = myFont; pTxtSym.Size = S; //Set symbol property pTxtElem.Symbol = pTxtSym; //set the text property to be the layer's name (Uppercase) pTxtElem.Text = texto; //Create an envelope for the TextElements Geometry pEnv = (IEnvelope)new Envelope(); pPoint = new ESRI.ArcGIS.Geometry.Point(); pPoint.X = x; pPoint.Y = y; pEnv.LowerLeft = pPoint; pPoint.X = 1; pPoint.Y = 1; pEnv.UpperRight = pPoint; //set the text elements geomtery pElem = (IElement)pTxtElem; pElem.Geometry = pEnv; //Add the element to the graphics container pGc.AddElement(pElem, 1); pMxDoc.ActiveView.Refresh(); return (pElem); } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, "clsMapTools.addTitleToLayout"); MessageBox.Show("Error: " + ex.StackTrace); return null ; } }
private void DrawArc(IEllipticArc pEllipArc) { if (pEllipArc == null) return; try { ISegmentCollection pSegColl; IPolyline pPolyline; pSegColl = new PolylineClass(); pSegColl.AddSegment(pEllipArc as ISegment); pPolyline = pSegColl as IPolyline; IRgbColor pColor = new RgbColor(); pColor.Red = 0; pColor.Green = 0; pColor.Blue = 0; m_LineSym = new SimpleLineSymbol(); m_LineSym.Color = pColor; m_LineSym.Width = 1; m_LineSym.Style = esriSimpleLineStyle.esriSLSSolid; ISymbol pSym = m_LineSym as ISymbol; pSym.ROP2 = esriRasterOpCode.esriROPNotXOrPen; m_pEnvFeedback.Symbol = pSym; m_hookHelper.ActiveView.ScreenDisplay.StartDrawing(m_hookHelper.ActiveView.ScreenDisplay.hDC, (short)esriScreenCache.esriNoScreenCache); m_hookHelper.ActiveView.ScreenDisplay.SetSymbol(pSym); m_hookHelper.ActiveView.ScreenDisplay.DrawPolyline(pPolyline); m_hookHelper.ActiveView.ScreenDisplay.FinishDrawing(); } catch (Exception) { return; } }
private ISymbol ApplyColor(ISymbol pSym, IFeature pFeat) { try { ISymbol pSym1 = null; ISymbol pSym2 = null; IColor pColor = null; IHsvColor pHSVColor = null; if ((m_pColorRend1 != null) & (m_pColorRend2 != null)) // for now both color renderers need to be set to apply color { pSym1 = m_pColorRend1.get_SymbolByFeature(pFeat); pSym2 = m_pColorRend2.get_SymbolByFeature(pFeat); // only use GetCombinedColor for HSV component-type combination method if (m_eColorCombinationMethod == EColorCombinationType.enuComponents) { pColor = GetCombinedColor(GetSymbolColor(pSym1), GetSymbolColor(pSym2), m_eColorCombinationMethod); // Hue is good when I do this... pHSVColor = pColor as IHsvColor; //'MsgBox(Str(pHSVColor.Hue) & " " & Str(pHSVColor.Saturation) & " " & " " & Str(pHSVColor.Value())) } else { pColor = new RgbColor(); pColor.RGB = (int)m_OLEColorMatrix[GetSymbolIndex(pSym1 as ISymbol, m_pColorRend1 as IClassBreaksRenderer), GetSymbolIndex(pSym2 as ISymbol, m_pColorRend2 as IClassBreaksRenderer)]; } if (pSym is IMarkerSymbol) { IMarkerSymbol pMarkerSym = null; pMarkerSym = pSym as IMarkerSymbol; pMarkerSym.Color = pColor; } else if (pSym is ILineSymbol) { ILineSymbol pLineSym = null; pLineSym = pSym as ILineSymbol; pLineSym.Color = pColor; } else if (pSym != null) { IFillSymbol pFillSym = null; pFillSym = pSym as IFillSymbol; pFillSym.Color = pColor; } } return pSym; return null; } catch { return null; } }
/// <summary> /// Creates a new <see cref="T:DesktopSprites.SpriteManagement.BitmapFrame"/> from the raw buffer, loading extra transparency /// information and adjusting the colors as required by the transparency. /// </summary> /// <param name="buffer">The raw buffer.</param> /// <param name="palette">The color palette.</param> /// <param name="transparentIndex">The index of the transparent color.</param> /// <param name="stride">The stride width of the buffer.</param> /// <param name="width">The logical width of the buffer.</param> /// <param name="height">The logical height of the buffer.</param> /// <param name="depth">The bit depth of the buffer.</param> /// <param name="hashCode">The hash code of the frame.</param> /// <param name="fileName">The path to the GIF file being loaded.</param> /// <returns>A new <see cref="T:DesktopSprites.SpriteManagement.BitmapFrame"/> for the frame held in the raw buffer.</returns> private BitmapFrame BitmapFrameFromBuffer(byte[] buffer, RgbColor[] palette, int transparentIndex, int stride, int width, int height, int depth, int hashCode, string fileName) { return Disposable.SetupSafely( BitmapFrame.FromBuffer(buffer, palette, transparentIndex, stride, width, height, depth, hashCode), frame => { if (IsAlphaBlended) { // Check for an alpha remapping table, and apply it if one exists. string mapFilePath = Path.ChangeExtension(fileName, AlphaRemappingTable.FileExtension); if (File.Exists(mapFilePath)) { AlphaRemappingTable map = new AlphaRemappingTable(); map.LoadMap(mapFilePath); ColorPalette colorPalette = frame.Image.Palette; for (int i = 0; i < colorPalette.Entries.Length; i++) { Color color = colorPalette.Entries[i]; ArgbColor argbColor; if (map.TryGetMapping(new RgbColor(color.R, color.G, color.B), out argbColor)) colorPalette.Entries[i] = Color.FromArgb(argbColor.ToArgb()); } frame.Image.Palette = colorPalette; // We only need to pre-multiply when we add an alpha channel ourselves, as GIFs only support 1 bit transparency. frame.Image.PreMultiplyAlpha(); } } else { frame.Image.RemapColors(paletteMapping); } }); }
private void DrawPoint(IPoint pPoint) { //Draw a red graphic dot on the display at the given point location IRgbColor color = null; ISimpleMarkerSymbol marker = null; IAppDisplay appDisplay = m_editor.Display as IAppDisplay; //Set the symbol (red, size 8) color = new RgbColor(); color.Red = 255; color.Green = 0; color.Blue = 0; marker = new SimpleMarkerSymbol(); marker.Color = color; marker.Size = 8; //Draw the point appDisplay.StartDrawing(0, (short)esriScreenCache.esriNoScreenCache); appDisplay.SetSymbol(marker as ISymbol); appDisplay.DrawPoint(pPoint); appDisplay.FinishDrawing(); }
/// <summary> /// Converts an RGB color to an HSB color, with output flags to indicate whether or not hue and/or saturation /// are defined after the conversion. /// </summary> /// <param name="rgbColor">An RGB color to convert to HSB color space.</param> /// <param name="isHueDefined">True if input color lies off the R=G=B line in the RGB cube, false if it lies on this line.</param> /// <param name="isSaturationDefined">True if input color isn't at either HLS cone tip, false if it is.</param> /// <returns> /// An HLS color corresponding to the input RGB color. /// If isHueDefined comes out false, then the resulting hue defaults to 0. /// If isSaturationDefined comes out false, then the resulting saturation defaults to 0. /// </returns> private static HlsColor RgbToHls(RgbColor rgbColor, out bool isHueDefined, out bool isSaturationDefined) { Debug.Assert(rgbColor.Red >= 0 && rgbColor.Red <= 1, "Red must be between 0 and 1."); Debug.Assert(rgbColor.Green >= 0 && rgbColor.Green <= 1, "Green must be between 0 and 1."); Debug.Assert(rgbColor.Blue >= 0 && rgbColor.Blue <= 1, "Blue must be between 0 and 1."); float min = Math.Min(rgbColor.Red, Math.Min(rgbColor.Green, rgbColor.Blue)); float max = Math.Max(rgbColor.Red, Math.Max(rgbColor.Green, rgbColor.Blue)); float hue = 0; float lightness = (min + max) / 2; float saturation = 0; // Three classifications of a point in the HLS double-cone: // (1) Point is on either cone's tip => hue & saturation both undefined // (2) Point is on the saturation=0 axis and isn't on either cone's tip => hue undefined, saturation=0 // (3) Point lies off the saturation=0 axis and off both cone's tips => hue defined, saturation defined // So the only invalid value for hue & saturation defined flags is: (hue defined, saturation undefined). if (min == max) { // Red, green, and blue are equal (the achromatic case). // Hue is undefined, so we arbitrarily choose zero. // If lightness is zero or one, then saturation is also undefined, so we arbitrarily choose zero. // Otherwise, saturation is zero. isHueDefined = false; isSaturationDefined = (lightness > 0 && lightness < 1); } else { // Hue and saturation are both defined. // Point lies off the saturation=0 axis and isn't on either HLS cone tip. isHueDefined = isSaturationDefined = true; float delta = max - min; saturation = (lightness <= 0.5f ? delta / (min + max) : delta / (2 - min - max)); // Force saturation to be between 0 and 1 in case of numerical instability saturation = Math.Max(0.0f, Math.Min(saturation, 1.0f)); if ((float)rgbColor.Red == max) { // between yellow & magenta hue = (rgbColor.Green - rgbColor.Blue) / delta; } else if ((float)rgbColor.Green == max) { // between cyan & yellow hue = 2 + (rgbColor.Blue - rgbColor.Red) / delta; } else { // between magenta & cyan hue = 4 + (rgbColor.Red - rgbColor.Green) / delta; } // Make hue positive. if (hue < 0) { hue += 6; } // Scale hue to [0, 1]. hue /= 6; } Debug.Assert(hue >= 0 && hue <= 1, "Output hue should be between 0 and 1."); Debug.Assert(lightness >= 0 && lightness <= 1, "Output lightness should be between 0 and 1."); Debug.Assert(saturation >= 0 && saturation <= 1, "Output saturation should be between 0 and 1."); Debug.Assert(!isHueDefined || isSaturationDefined, "If hue is defined, saturation must also be defined."); return new HlsColor(rgbColor.Alpha, hue, lightness, saturation); }
/// <summary> /// Converts a color from RGB to HLS color space. /// If hue is undefined (because color is achromatic), it defaults to zero. /// If saturation is undefined (because lightness is zero or one), it defaults to zero. /// </summary> /// <param name="rgbColor">The input color.</param> /// <returns>An HLS color corresponding to the input RGB color.</returns> private static HlsColor RgbToHls(RgbColor rgbColor) { bool isHueDefined; bool isSaturationDefined; return RgbToHls(rgbColor, out isHueDefined, out isSaturationDefined); }
private void addMarkerBtn_Click(object sender, EventArgs e) { if (perceel == null) return; datacontract.geojsonPolygon jsPoly = JsonConvert.DeserializeObject<datacontract.geojsonPolygon>(perceel.geometry.shape); IPolygon lbShape = geopuntHelper.geojson2esriPolygon(jsPoly, (int)dataHandler.CRS.Lambert72); IPolygon mapShape = (IPolygon)geopuntHelper.Transform(lbShape, map.SpatialReference); string adres = string.Join("-", perceel.adres.ToArray()) ; if (adres.Length > 120) adres = adres.Substring(0, 120); IRgbColor innerClr = new RgbColor() { Red = 0, Blue = 0, Green = 0 }; IRgbColor outlineClr = new RgbColor() { Red = 0, Blue = 200, Green = 0 }; IPoint center = ((IArea)mapShape).LabelPoint; geopuntHelper.AddGraphicToMap(map, mapShape, innerClr, outlineClr, 2, false); geopuntHelper.AddTextElement(map, center, perceel.capakey + "\r\n" + adres); view.PartialRefresh(esriViewDrawPhase.esriViewGraphics, null, null); }
//填充外边框颜色变化响应事件 private void cbOutlineColor_MouseUp(object sender, MouseEventArgs e) { IRgbColor pColor = new RgbColor(); pColor.RGB = 255; tagRECT ptagRECT = new tagRECT(); ptagRECT.left = cbOutlineColor.PointToScreen(System.Drawing.Point.Empty).X; ptagRECT.bottom = cbOutlineColor.PointToScreen(System.Drawing.Point.Empty).Y + cbOutlineColor.Height; IColorPalette pColorPalette = new ColorPalette(); pColorPalette.TrackPopupMenu(ref ptagRECT, pColor, false, 0); pColor = pColorPalette.Color as IRgbColor; Color color = Color.FromArgb(pColor.Red, pColor.Green, pColor.Blue); //btOutlineColor.BackColor = color; cbOutlineColor.BackColor = color; ILineSymbol pLineSymbol = ((IFillSymbol)pStyleGalleryItem.Item).Outline; pLineSymbol.Color = pColor; ((IFillSymbol)pStyleGalleryItem.Item).Outline = pLineSymbol; PreviewPicture(); }
private void SetNewLineFeedBack() { m_pEnvFeedback = new NewEnvelopeFeedback(); IRgbColor pColor = new RgbColor(); pColor.Red = 0; pColor.Green = 0; pColor.Blue = 0; m_LineSym = new SimpleLineSymbol(); m_LineSym.Color = pColor; m_LineSym.Width = 1; m_LineSym.Style = esriSimpleLineStyle.esriSLSSolid; ISymbol pSym = m_LineSym as ISymbol; pSym.ROP2 = esriRasterOpCode.esriROPNotXOrPen; m_pEnvFeedback.Symbol = pSym; m_hookHelper.ActiveView.ScreenDisplay.StartDrawing(m_hookHelper.ActiveView.ScreenDisplay.hDC, (short)esriScreenCache.esriNoScreenCache); m_hookHelper.ActiveView.ScreenDisplay.SetSymbol(pSym); m_hookHelper.ActiveView.ScreenDisplay.FinishDrawing(); m_pEnvFeedback.Display = m_hookHelper.ActiveView.ScreenDisplay; }
private void UpdateFeedbackWithEllipse(bool HasMinorAxis = true) { if (!HasPoint1) return; ClearTempGraphics(); AddGraphicToMap(Point1, new RgbColor() { Green = 255 } as IColor, true); var ellipticArc = new Polyline() as IConstructGeodetic; var minorAxis = MinorAxisDistance; if (!HasMinorAxis || minorAxis == 0.0) minorAxis = MajorAxisDistance; if (minorAxis > MajorAxisDistance) minorAxis = MajorAxisDistance; ellipticArc.ConstructGeodesicEllipse(Point1, GetLinearUnit(), MajorAxisDistance, minorAxis, Azimuth, esriCurveDensifyMethod.esriCurveDensifyByAngle, 0.45); var line = ellipticArc as IPolyline; if (line != null) { var color = new RgbColor() as IColor; AddGraphicToMap(line as IGeometry, color, true, rasterOpCode: esriRasterOpCode.esriROPNotXOrPen); } }
/// <summary> /// 画线 /// <param name="arrPointAll">点坐标数组</param> ///<returns></returns> private void DrawLine2(ArrayList arrPointAll) { if (arrPointAll.Count <= 0)//点坐标数组不能为空 { return; } IActiveView activeView = this.axMapControl.ActiveView.FocusMap as IActiveView; //删除以前的element //DeleteOldElement(activeView.GraphicsContainer); // 获取IRGBColor接口 IRgbColor color = new RgbColor(); // 设置颜色属性 color.Red = 255; color.Transparency = 255; //点 IPoint pPoint = new PointClass(); //线样式 ISimpleLineSymbol lineSymbol = new SimpleLineSymbolClass(); lineSymbol.Color = color; lineSymbol.Style = esriSimpleLineStyle.esriSLSInsideFrame; lineSymbol.Width = 10; //线元素 ILineElement lineElement = new LineElementClass(); lineElement.Symbol = lineSymbol; //创建线 IPolyline m_Polyline = new PolylineClass(); //点集合 IPointCollection m_PointCollection = new PolylineClass(); //点数组 ArrayList arrPoint = new ArrayList(); object missing = Type.Missing; for (int i = 0; i < arrPointAll.Count; i++) { //pPoint.PutCoords(int.Parse(arrPointAll[i].ToString()), int.Parse(arrPointAll[i].ToString())); pPoint.PutCoords(-1520445, 1038916); m_PointCollection.AddPoint(pPoint, ref missing, ref missing); pPoint.PutCoords(389327, 1613427); m_PointCollection.AddPoint(pPoint, ref missing, ref missing); } //QI for IPolyline m_Polyline = m_PointCollection as IPolyline; //放大地图 //折线范围 IEnvelope pEnvelope = m_Polyline.Envelope; //折线区域 IArea pArea = pEnvelope as IArea; pPoint = pArea.Centroid; // this.ChangeEnvelope(pPoint, 0.06, 0.06); //QI for IElement IElement element = lineElement as IElement; element.Geometry = m_Polyline; //加载线元素到地图 activeView.GraphicsContainer.AddElement(element, 0); //Refresh the graphics activeView.PartialRefresh(esriViewDrawPhase.esriViewGraphics, null, null); }
public void Activate(ESRI.ArcGIS.CatalogUI.IGxApplication Application, ESRI.ArcGIS.Catalog.IGxCatalog Catalog) { try { //Get selection m_pSelection = (GxSelection) Application.Selection; m_pSelection.OnSelectionChanged += new IGxSelectionEvents_OnSelectionChangedEventHandler(OnSelectionChanged); // get data from the MyProject's settings. // please change accordingly m_path = Properties.Settings.Default.DataLocation; //Add data to map control frmExtentView.AxMapControl1.AddShapeFile(m_path, "world30"); frmExtentView.AxMapControl1.Extent = frmExtentView.AxMapControl1.FullExtent; //Create and setup the fill symbol that will be used to draw the dataset's extent // rectangle if it is not cached if (m_pFillSymbol == null) { m_pFillSymbol = new SimpleFillSymbol(); IColor pColor = null; ILineSymbol pLineSymbol = null; pColor = new RgbColor(); pColor.NullColor = true; m_pFillSymbol.Color = pColor; pLineSymbol = new SimpleLineSymbol(); pColor.NullColor = false; pColor.RGB = 200; //Red pLineSymbol.Color = pColor; pLineSymbol.Width = 2; m_pFillSymbol.Outline = pLineSymbol; } //Draw extent Refresh(); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } }
//点、线、面填充颜色变化响应事件 private void cbColor_MouseUp(object sender, MouseEventArgs e) { IRgbColor pColor = new RgbColor(); //颜色实例 pColor.RGB = 255; tagRECT pTag = new tagRECT(); //用于下面显示 ColorPalette 的位置 pTag.left = cbColor.PointToScreen(System.Drawing.Point.Empty).X; //按钮控件的左边全局横坐标 pTag.bottom = cbColor.PointToScreen(System.Drawing.Point.Empty).Y + cbColor.Height; //按钮控件的下边全局纵坐标 IColorPalette pColorPalette = new ColorPalette(); pColorPalette.TrackPopupMenu(ref pTag, pColor, false, 0); //显示 ColorPalette pColor = pColorPalette.Color as IRgbColor; //获取选中的颜色 Color color = Color.FromArgb(pColor.Red, pColor.Green, pColor.Blue); //将颜色转为 C# 颜色 btColor.BackColor = color; cbColor.BackColor = color; switch (((IFeatureLayer)pLayer).FeatureClass.ShapeType) //判断几何体样式 { case esriGeometryType.esriGeometryPoint: //点 ((IMarkerSymbol)pStyleGalleryItem.Item).Color = pColor; //转为 IMarkerSymbol,注意改好后要在图片上显示 PreviewPicture(); break; case esriGeometryType.esriGeometryPolyline: //线 ((ILineSymbol)pStyleGalleryItem.Item).Color = pColor; //转为 ILineSymbol PreviewPicture(); break; case esriGeometryType.esriGeometryPolygon: //面 ((IFillSymbol)pStyleGalleryItem.Item).Color = pColor; //转为 IFillSymbol PreviewPicture(); break; default: break; } }
//闪烁面 static void FlashPolygon(AxMapControl mapControl, IScreenDisplay iScreenDisplay, IGeometry iGeometry) { ISimpleFillSymbol iFillSymbol; ISymbol iSymbol; IRgbColor iRgbColor; iFillSymbol = new SimpleFillSymbol(); iFillSymbol.Style = esriSimpleFillStyle.esriSFSSolid; iFillSymbol.Outline.Width = 12; iRgbColor = new RgbColor(); iRgbColor.RGB = System.Drawing.Color.FromArgb(100, 180, 180).ToArgb(); iFillSymbol.Color = iRgbColor; iSymbol = (ISymbol)iFillSymbol; iSymbol.ROP2 = esriRasterOpCode.esriROPNotXOrPen; iScreenDisplay.SetSymbol(iSymbol); mapControl.FlashShape(iGeometry, 3, 200, iSymbol); }
// Generates content of workbookStylesPart1. private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1) { Stylesheet stylesheet1 = new Stylesheet(); NumberingFormats numberingFormats1 = new NumberingFormats() { Count = (UInt32Value)2U }; NumberingFormat numberingFormat1 = new NumberingFormat() { NumberFormatId = (UInt32Value)166U, FormatCode = "_(* #,##0_);_(* \\(#,##0\\);_(* \"-\"??_);_(@_)" }; NumberingFormat numberingFormat2 = new NumberingFormat() { NumberFormatId = (UInt32Value)167U, FormatCode = "_-* #,##0\\ _€_-;\\-* #,##0\\ _€_-;_-* \"-\"??\\ _€_-;_-@_-" }; numberingFormats1.Append(numberingFormat1); numberingFormats1.Append(numberingFormat2); Fonts fonts1 = new Fonts() { Count = (UInt32Value)14U }; Font font1 = new Font(); FontSize fontSize1 = new FontSize() { Val = 10D }; FontName fontName1 = new FontName() { Val = "Arial" }; font1.Append(fontSize1); font1.Append(fontName1); Font font2 = new Font(); Bold bold1 = new Bold(); FontSize fontSize2 = new FontSize() { Val = 10D }; FontName fontName2 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 }; font2.Append(bold1); font2.Append(fontSize2); font2.Append(fontName2); font2.Append(fontFamilyNumbering1); Font font3 = new Font(); Bold bold2 = new Bold(); Italic italic1 = new Italic(); FontSize fontSize3 = new FontSize() { Val = 10D }; FontName fontName3 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering() { Val = 2 }; font3.Append(bold2); font3.Append(italic1); font3.Append(fontSize3); font3.Append(fontName3); font3.Append(fontFamilyNumbering2); Font font4 = new Font(); Bold bold3 = new Bold(); FontSize fontSize4 = new FontSize() { Val = 10D }; Color color1 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName4 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering() { Val = 2 }; font4.Append(bold3); font4.Append(fontSize4); font4.Append(color1); font4.Append(fontName4); font4.Append(fontFamilyNumbering3); Font font5 = new Font(); FontSize fontSize5 = new FontSize() { Val = 10D }; Color color2 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName5 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering4 = new FontFamilyNumbering() { Val = 2 }; font5.Append(fontSize5); font5.Append(color2); font5.Append(fontName5); font5.Append(fontFamilyNumbering4); Font font6 = new Font(); Bold bold4 = new Bold(); FontSize fontSize6 = new FontSize() { Val = 10D }; Color color3 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName6 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering5 = new FontFamilyNumbering() { Val = 2 }; font6.Append(bold4); font6.Append(fontSize6); font6.Append(color3); font6.Append(fontName6); font6.Append(fontFamilyNumbering5); Font font7 = new Font(); FontSize fontSize7 = new FontSize() { Val = 12D }; Color color4 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName7 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering6 = new FontFamilyNumbering() { Val = 2 }; font7.Append(fontSize7); font7.Append(color4); font7.Append(fontName7); font7.Append(fontFamilyNumbering6); Font font8 = new Font(); Bold bold5 = new Bold(); FontSize fontSize8 = new FontSize() { Val = 9D }; FontName fontName8 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering7 = new FontFamilyNumbering() { Val = 2 }; font8.Append(bold5); font8.Append(fontSize8); font8.Append(fontName8); font8.Append(fontFamilyNumbering7); Font font9 = new Font(); Bold bold6 = new Bold(); FontSize fontSize9 = new FontSize() { Val = 8D }; Color color5 = new Color() { Indexed = (UInt32Value)9U }; FontName fontName9 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering8 = new FontFamilyNumbering() { Val = 2 }; font9.Append(bold6); font9.Append(fontSize9); font9.Append(color5); font9.Append(fontName9); font9.Append(fontFamilyNumbering8); Font font10 = new Font(); FontSize fontSize10 = new FontSize() { Val = 12D }; FontName fontName10 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering9 = new FontFamilyNumbering() { Val = 2 }; font10.Append(fontSize10); font10.Append(fontName10); font10.Append(fontFamilyNumbering9); Font font11 = new Font(); Bold bold7 = new Bold(); FontSize fontSize11 = new FontSize() { Val = 12D }; FontName fontName11 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering10 = new FontFamilyNumbering() { Val = 2 }; font11.Append(bold7); font11.Append(fontSize11); font11.Append(fontName11); font11.Append(fontFamilyNumbering10); Font font12 = new Font(); Bold bold8 = new Bold(); FontSize fontSize12 = new FontSize() { Val = 11D }; FontName fontName12 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering11 = new FontFamilyNumbering() { Val = 2 }; font12.Append(bold8); font12.Append(fontSize12); font12.Append(fontName12); font12.Append(fontFamilyNumbering11); Font font13 = new Font(); FontSize fontSize13 = new FontSize() { Val = 11D }; FontName fontName13 = new FontName() { Val = "Arial" }; FontFamilyNumbering fontFamilyNumbering12 = new FontFamilyNumbering() { Val = 2 }; font13.Append(fontSize13); font13.Append(fontName13); font13.Append(fontFamilyNumbering12); Font font14 = new Font(); Underline underline1 = new Underline(); FontSize fontSize14 = new FontSize() { Val = 12D }; Color color6 = new Color() { Indexed = (UInt32Value)12U }; FontName fontName14 = new FontName() { Val = "Arial" }; font14.Append(underline1); font14.Append(fontSize14); font14.Append(color6); font14.Append(fontName14); fonts1.Append(font1); fonts1.Append(font2); fonts1.Append(font3); fonts1.Append(font4); fonts1.Append(font5); fonts1.Append(font6); fonts1.Append(font7); fonts1.Append(font8); fonts1.Append(font9); fonts1.Append(font10); fonts1.Append(font11); fonts1.Append(font12); fonts1.Append(font13); fonts1.Append(font14); Fills fills1 = new Fills() { Count = (UInt32Value)13U }; Fill fill1 = new Fill(); PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None }; fill1.Append(patternFill1); Fill fill2 = new Fill(); PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 }; fill2.Append(patternFill2); Fill fill3 = new Fill(); PatternFill patternFill3 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor1 = new ForegroundColor() { Indexed = (UInt32Value)9U }; BackgroundColor backgroundColor1 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill3.Append(foregroundColor1); patternFill3.Append(backgroundColor1); fill3.Append(patternFill3); Fill fill4 = new Fill(); PatternFill patternFill4 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor2 = new ForegroundColor() { Indexed = (UInt32Value)10U }; BackgroundColor backgroundColor2 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill4.Append(foregroundColor2); patternFill4.Append(backgroundColor2); fill4.Append(patternFill4); Fill fill5 = new Fill(); PatternFill patternFill5 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor3 = new ForegroundColor() { Indexed = (UInt32Value)23U }; BackgroundColor backgroundColor3 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill5.Append(foregroundColor3); patternFill5.Append(backgroundColor3); fill5.Append(patternFill5); Fill fill6 = new Fill(); PatternFill patternFill6 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor4 = new ForegroundColor() { Indexed = (UInt32Value)43U }; BackgroundColor backgroundColor4 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill6.Append(foregroundColor4); patternFill6.Append(backgroundColor4); fill6.Append(patternFill6); Fill fill7 = new Fill(); PatternFill patternFill7 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor5 = new ForegroundColor() { Indexed = (UInt32Value)42U }; BackgroundColor backgroundColor5 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill7.Append(foregroundColor5); patternFill7.Append(backgroundColor5); fill7.Append(patternFill7); Fill fill8 = new Fill(); PatternFill patternFill8 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor6 = new ForegroundColor() { Indexed = (UInt32Value)55U }; BackgroundColor backgroundColor6 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill8.Append(foregroundColor6); patternFill8.Append(backgroundColor6); fill8.Append(patternFill8); Fill fill9 = new Fill(); PatternFill patternFill9 = new PatternFill() { PatternType = PatternValues.None }; ForegroundColor foregroundColor7 = new ForegroundColor() { Indexed = (UInt32Value)9U }; BackgroundColor backgroundColor7 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill9.Append(foregroundColor7); patternFill9.Append(backgroundColor7); fill9.Append(patternFill9); Fill fill10 = new Fill(); PatternFill patternFill10 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor8 = new ForegroundColor() { Theme = (UInt32Value)0U }; BackgroundColor backgroundColor8 = new BackgroundColor() { Indexed = (UInt32Value)64U }; patternFill10.Append(foregroundColor8); patternFill10.Append(backgroundColor8); fill10.Append(patternFill10); Fill fill11 = new Fill(); PatternFill patternFill11 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor9 = new ForegroundColor() { Rgb = "FFFFE699" }; BackgroundColor backgroundColor9 = new BackgroundColor() { Rgb = "FF000000" }; patternFill11.Append(foregroundColor9); patternFill11.Append(backgroundColor9); fill11.Append(patternFill11); Fill fill12 = new Fill(); PatternFill patternFill12 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor10 = new ForegroundColor() { Rgb = "FFCCFFCC" }; BackgroundColor backgroundColor10 = new BackgroundColor() { Rgb = "FF000000" }; patternFill12.Append(foregroundColor10); patternFill12.Append(backgroundColor10); fill12.Append(patternFill12); Fill fill13 = new Fill(); PatternFill patternFill13 = new PatternFill() { PatternType = PatternValues.Solid }; ForegroundColor foregroundColor11 = new ForegroundColor() { Rgb = "FF969696" }; BackgroundColor backgroundColor11 = new BackgroundColor() { Rgb = "FF000000" }; patternFill13.Append(foregroundColor11); patternFill13.Append(backgroundColor11); fill13.Append(patternFill13); fills1.Append(fill1); fills1.Append(fill2); fills1.Append(fill3); fills1.Append(fill4); fills1.Append(fill5); fills1.Append(fill6); fills1.Append(fill7); fills1.Append(fill8); fills1.Append(fill9); fills1.Append(fill10); fills1.Append(fill11); fills1.Append(fill12); fills1.Append(fill13); Borders borders1 = new Borders() { Count = (UInt32Value)27U }; Border border1 = new Border(); LeftBorder leftBorder1 = new LeftBorder(); RightBorder rightBorder1 = new RightBorder(); TopBorder topBorder1 = new TopBorder(); BottomBorder bottomBorder1 = new BottomBorder(); DiagonalBorder diagonalBorder1 = new DiagonalBorder(); border1.Append(leftBorder1); border1.Append(rightBorder1); border1.Append(topBorder1); border1.Append(bottomBorder1); border1.Append(diagonalBorder1); Border border2 = new Border(); LeftBorder leftBorder2 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color7 = new Color() { Indexed = (UInt32Value)64U }; leftBorder2.Append(color7); RightBorder rightBorder2 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color8 = new Color() { Indexed = (UInt32Value)64U }; rightBorder2.Append(color8); TopBorder topBorder2 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color9 = new Color() { Indexed = (UInt32Value)64U }; topBorder2.Append(color9); BottomBorder bottomBorder2 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color10 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder2.Append(color10); DiagonalBorder diagonalBorder2 = new DiagonalBorder(); border2.Append(leftBorder2); border2.Append(rightBorder2); border2.Append(topBorder2); border2.Append(bottomBorder2); border2.Append(diagonalBorder2); Border border3 = new Border(); LeftBorder leftBorder3 = new LeftBorder(); RightBorder rightBorder3 = new RightBorder(); TopBorder topBorder3 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color11 = new Color() { Indexed = (UInt32Value)64U }; topBorder3.Append(color11); BottomBorder bottomBorder3 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color12 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder3.Append(color12); DiagonalBorder diagonalBorder3 = new DiagonalBorder(); border3.Append(leftBorder3); border3.Append(rightBorder3); border3.Append(topBorder3); border3.Append(bottomBorder3); border3.Append(diagonalBorder3); Border border4 = new Border(); LeftBorder leftBorder4 = new LeftBorder(); RightBorder rightBorder4 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color13 = new Color() { Indexed = (UInt32Value)64U }; rightBorder4.Append(color13); TopBorder topBorder4 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color14 = new Color() { Indexed = (UInt32Value)64U }; topBorder4.Append(color14); BottomBorder bottomBorder4 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color15 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder4.Append(color15); DiagonalBorder diagonalBorder4 = new DiagonalBorder(); border4.Append(leftBorder4); border4.Append(rightBorder4); border4.Append(topBorder4); border4.Append(bottomBorder4); border4.Append(diagonalBorder4); Border border5 = new Border(); LeftBorder leftBorder5 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color16 = new Color() { Indexed = (UInt32Value)64U }; leftBorder5.Append(color16); RightBorder rightBorder5 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color17 = new Color() { Indexed = (UInt32Value)64U }; rightBorder5.Append(color17); TopBorder topBorder5 = new TopBorder(); BottomBorder bottomBorder5 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color18 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder5.Append(color18); DiagonalBorder diagonalBorder5 = new DiagonalBorder(); border5.Append(leftBorder5); border5.Append(rightBorder5); border5.Append(topBorder5); border5.Append(bottomBorder5); border5.Append(diagonalBorder5); Border border6 = new Border(); LeftBorder leftBorder6 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color19 = new Color() { Indexed = (UInt32Value)64U }; leftBorder6.Append(color19); RightBorder rightBorder6 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color20 = new Color() { Indexed = (UInt32Value)64U }; rightBorder6.Append(color20); TopBorder topBorder6 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color21 = new Color() { Indexed = (UInt32Value)64U }; topBorder6.Append(color21); BottomBorder bottomBorder6 = new BottomBorder(); DiagonalBorder diagonalBorder6 = new DiagonalBorder(); border6.Append(leftBorder6); border6.Append(rightBorder6); border6.Append(topBorder6); border6.Append(bottomBorder6); border6.Append(diagonalBorder6); Border border7 = new Border(); LeftBorder leftBorder7 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color22 = new Color() { Indexed = (UInt32Value)64U }; leftBorder7.Append(color22); RightBorder rightBorder7 = new RightBorder(); TopBorder topBorder7 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color23 = new Color() { Indexed = (UInt32Value)64U }; topBorder7.Append(color23); BottomBorder bottomBorder7 = new BottomBorder(); DiagonalBorder diagonalBorder7 = new DiagonalBorder(); border7.Append(leftBorder7); border7.Append(rightBorder7); border7.Append(topBorder7); border7.Append(bottomBorder7); border7.Append(diagonalBorder7); Border border8 = new Border(); LeftBorder leftBorder8 = new LeftBorder(); RightBorder rightBorder8 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color24 = new Color() { Indexed = (UInt32Value)64U }; rightBorder8.Append(color24); TopBorder topBorder8 = new TopBorder(); BottomBorder bottomBorder8 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color25 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder8.Append(color25); DiagonalBorder diagonalBorder8 = new DiagonalBorder(); border8.Append(leftBorder8); border8.Append(rightBorder8); border8.Append(topBorder8); border8.Append(bottomBorder8); border8.Append(diagonalBorder8); Border border9 = new Border(); LeftBorder leftBorder9 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color26 = new Color() { Indexed = (UInt32Value)64U }; leftBorder9.Append(color26); RightBorder rightBorder9 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color27 = new Color() { Indexed = (UInt32Value)64U }; rightBorder9.Append(color27); TopBorder topBorder9 = new TopBorder(); BottomBorder bottomBorder9 = new BottomBorder(); DiagonalBorder diagonalBorder9 = new DiagonalBorder(); border9.Append(leftBorder9); border9.Append(rightBorder9); border9.Append(topBorder9); border9.Append(bottomBorder9); border9.Append(diagonalBorder9); Border border10 = new Border(); LeftBorder leftBorder10 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color28 = new Color() { Indexed = (UInt32Value)64U }; leftBorder10.Append(color28); RightBorder rightBorder10 = new RightBorder(); TopBorder topBorder10 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color29 = new Color() { Indexed = (UInt32Value)64U }; topBorder10.Append(color29); BottomBorder bottomBorder10 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color30 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder10.Append(color30); DiagonalBorder diagonalBorder10 = new DiagonalBorder(); border10.Append(leftBorder10); border10.Append(rightBorder10); border10.Append(topBorder10); border10.Append(bottomBorder10); border10.Append(diagonalBorder10); Border border11 = new Border(); LeftBorder leftBorder11 = new LeftBorder(); RightBorder rightBorder11 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color31 = new Color() { Indexed = (UInt32Value)64U }; rightBorder11.Append(color31); TopBorder topBorder11 = new TopBorder(); BottomBorder bottomBorder11 = new BottomBorder(); DiagonalBorder diagonalBorder11 = new DiagonalBorder(); border11.Append(leftBorder11); border11.Append(rightBorder11); border11.Append(topBorder11); border11.Append(bottomBorder11); border11.Append(diagonalBorder11); Border border12 = new Border(); LeftBorder leftBorder12 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color32 = new Color() { Indexed = (UInt32Value)64U }; leftBorder12.Append(color32); RightBorder rightBorder12 = new RightBorder(); TopBorder topBorder12 = new TopBorder(); BottomBorder bottomBorder12 = new BottomBorder(); DiagonalBorder diagonalBorder12 = new DiagonalBorder(); border12.Append(leftBorder12); border12.Append(rightBorder12); border12.Append(topBorder12); border12.Append(bottomBorder12); border12.Append(diagonalBorder12); Border border13 = new Border(); LeftBorder leftBorder13 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color33 = new Color() { Indexed = (UInt32Value)64U }; leftBorder13.Append(color33); RightBorder rightBorder13 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color34 = new Color() { Indexed = (UInt32Value)64U }; rightBorder13.Append(color34); TopBorder topBorder13 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color35 = new Color() { Indexed = (UInt32Value)64U }; topBorder13.Append(color35); BottomBorder bottomBorder13 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color36 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder13.Append(color36); DiagonalBorder diagonalBorder13 = new DiagonalBorder(); border13.Append(leftBorder13); border13.Append(rightBorder13); border13.Append(topBorder13); border13.Append(bottomBorder13); border13.Append(diagonalBorder13); Border border14 = new Border(); LeftBorder leftBorder14 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color37 = new Color() { Indexed = (UInt32Value)64U }; leftBorder14.Append(color37); RightBorder rightBorder14 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color38 = new Color() { Indexed = (UInt32Value)64U }; rightBorder14.Append(color38); TopBorder topBorder14 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color39 = new Color() { Indexed = (UInt32Value)64U }; topBorder14.Append(color39); BottomBorder bottomBorder14 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color40 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder14.Append(color40); DiagonalBorder diagonalBorder14 = new DiagonalBorder(); border14.Append(leftBorder14); border14.Append(rightBorder14); border14.Append(topBorder14); border14.Append(bottomBorder14); border14.Append(diagonalBorder14); Border border15 = new Border(); LeftBorder leftBorder15 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color41 = new Color() { Indexed = (UInt32Value)64U }; leftBorder15.Append(color41); RightBorder rightBorder15 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color42 = new Color() { Indexed = (UInt32Value)64U }; rightBorder15.Append(color42); TopBorder topBorder15 = new TopBorder(); BottomBorder bottomBorder15 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color43 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder15.Append(color43); DiagonalBorder diagonalBorder15 = new DiagonalBorder(); border15.Append(leftBorder15); border15.Append(rightBorder15); border15.Append(topBorder15); border15.Append(bottomBorder15); border15.Append(diagonalBorder15); Border border16 = new Border(); LeftBorder leftBorder16 = new LeftBorder(); RightBorder rightBorder16 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color44 = new Color() { Indexed = (UInt32Value)64U }; rightBorder16.Append(color44); TopBorder topBorder16 = new TopBorder(); BottomBorder bottomBorder16 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color45 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder16.Append(color45); DiagonalBorder diagonalBorder16 = new DiagonalBorder(); border16.Append(leftBorder16); border16.Append(rightBorder16); border16.Append(topBorder16); border16.Append(bottomBorder16); border16.Append(diagonalBorder16); Border border17 = new Border(); LeftBorder leftBorder17 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color46 = new Color() { Indexed = (UInt32Value)64U }; leftBorder17.Append(color46); RightBorder rightBorder17 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color47 = new Color() { Indexed = (UInt32Value)64U }; rightBorder17.Append(color47); TopBorder topBorder17 = new TopBorder(); BottomBorder bottomBorder17 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color48 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder17.Append(color48); DiagonalBorder diagonalBorder17 = new DiagonalBorder(); border17.Append(leftBorder17); border17.Append(rightBorder17); border17.Append(topBorder17); border17.Append(bottomBorder17); border17.Append(diagonalBorder17); Border border18 = new Border(); LeftBorder leftBorder18 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color49 = new Color() { Indexed = (UInt32Value)64U }; leftBorder18.Append(color49); RightBorder rightBorder18 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color50 = new Color() { Indexed = (UInt32Value)64U }; rightBorder18.Append(color50); TopBorder topBorder18 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color51 = new Color() { Indexed = (UInt32Value)64U }; topBorder18.Append(color51); BottomBorder bottomBorder18 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color52 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder18.Append(color52); DiagonalBorder diagonalBorder18 = new DiagonalBorder(); border18.Append(leftBorder18); border18.Append(rightBorder18); border18.Append(topBorder18); border18.Append(bottomBorder18); border18.Append(diagonalBorder18); Border border19 = new Border(); LeftBorder leftBorder19 = new LeftBorder(); RightBorder rightBorder19 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color53 = new Color() { Indexed = (UInt32Value)64U }; rightBorder19.Append(color53); TopBorder topBorder19 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color54 = new Color() { Indexed = (UInt32Value)64U }; topBorder19.Append(color54); BottomBorder bottomBorder19 = new BottomBorder(); DiagonalBorder diagonalBorder19 = new DiagonalBorder(); border19.Append(leftBorder19); border19.Append(rightBorder19); border19.Append(topBorder19); border19.Append(bottomBorder19); border19.Append(diagonalBorder19); Border border20 = new Border(); LeftBorder leftBorder20 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color55 = new Color() { Indexed = (UInt32Value)64U }; leftBorder20.Append(color55); RightBorder rightBorder20 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color56 = new Color() { Indexed = (UInt32Value)64U }; rightBorder20.Append(color56); TopBorder topBorder20 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color57 = new Color() { Indexed = (UInt32Value)64U }; topBorder20.Append(color57); BottomBorder bottomBorder20 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color58 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder20.Append(color58); DiagonalBorder diagonalBorder20 = new DiagonalBorder(); border20.Append(leftBorder20); border20.Append(rightBorder20); border20.Append(topBorder20); border20.Append(bottomBorder20); border20.Append(diagonalBorder20); Border border21 = new Border(); LeftBorder leftBorder21 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color59 = new Color() { Indexed = (UInt32Value)64U }; leftBorder21.Append(color59); RightBorder rightBorder21 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color60 = new Color() { Indexed = (UInt32Value)64U }; rightBorder21.Append(color60); TopBorder topBorder21 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color61 = new Color() { Indexed = (UInt32Value)64U }; topBorder21.Append(color61); BottomBorder bottomBorder21 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color62 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder21.Append(color62); DiagonalBorder diagonalBorder21 = new DiagonalBorder(); border21.Append(leftBorder21); border21.Append(rightBorder21); border21.Append(topBorder21); border21.Append(bottomBorder21); border21.Append(diagonalBorder21); Border border22 = new Border(); LeftBorder leftBorder22 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color63 = new Color() { Indexed = (UInt32Value)64U }; leftBorder22.Append(color63); RightBorder rightBorder22 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color64 = new Color() { Indexed = (UInt32Value)64U }; rightBorder22.Append(color64); TopBorder topBorder22 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color65 = new Color() { Indexed = (UInt32Value)64U }; topBorder22.Append(color65); BottomBorder bottomBorder22 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color66 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder22.Append(color66); DiagonalBorder diagonalBorder22 = new DiagonalBorder(); border22.Append(leftBorder22); border22.Append(rightBorder22); border22.Append(topBorder22); border22.Append(bottomBorder22); border22.Append(diagonalBorder22); Border border23 = new Border(); LeftBorder leftBorder23 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color67 = new Color() { Indexed = (UInt32Value)64U }; leftBorder23.Append(color67); RightBorder rightBorder23 = new RightBorder() { Style = BorderStyleValues.Medium }; Color color68 = new Color() { Indexed = (UInt32Value)64U }; rightBorder23.Append(color68); TopBorder topBorder23 = new TopBorder(); BottomBorder bottomBorder23 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color69 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder23.Append(color69); DiagonalBorder diagonalBorder23 = new DiagonalBorder(); border23.Append(leftBorder23); border23.Append(rightBorder23); border23.Append(topBorder23); border23.Append(bottomBorder23); border23.Append(diagonalBorder23); Border border24 = new Border(); LeftBorder leftBorder24 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color70 = new Color() { Indexed = (UInt32Value)64U }; leftBorder24.Append(color70); RightBorder rightBorder24 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color71 = new Color() { Indexed = (UInt32Value)64U }; rightBorder24.Append(color71); TopBorder topBorder24 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color72 = new Color() { Indexed = (UInt32Value)64U }; topBorder24.Append(color72); BottomBorder bottomBorder24 = new BottomBorder() { Style = BorderStyleValues.Thin }; Color color73 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder24.Append(color73); DiagonalBorder diagonalBorder24 = new DiagonalBorder(); border24.Append(leftBorder24); border24.Append(rightBorder24); border24.Append(topBorder24); border24.Append(bottomBorder24); border24.Append(diagonalBorder24); Border border25 = new Border(); LeftBorder leftBorder25 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color74 = new Color() { Indexed = (UInt32Value)64U }; leftBorder25.Append(color74); RightBorder rightBorder25 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color75 = new Color() { Indexed = (UInt32Value)64U }; rightBorder25.Append(color75); TopBorder topBorder25 = new TopBorder() { Style = BorderStyleValues.Thin }; Color color76 = new Color() { Indexed = (UInt32Value)64U }; topBorder25.Append(color76); BottomBorder bottomBorder25 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color77 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder25.Append(color77); DiagonalBorder diagonalBorder25 = new DiagonalBorder(); border25.Append(leftBorder25); border25.Append(rightBorder25); border25.Append(topBorder25); border25.Append(bottomBorder25); border25.Append(diagonalBorder25); Border border26 = new Border(); LeftBorder leftBorder26 = new LeftBorder() { Style = BorderStyleValues.Medium }; Color color78 = new Color() { Indexed = (UInt32Value)64U }; leftBorder26.Append(color78); RightBorder rightBorder26 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color79 = new Color() { Indexed = (UInt32Value)64U }; rightBorder26.Append(color79); TopBorder topBorder26 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color80 = new Color() { Indexed = (UInt32Value)64U }; topBorder26.Append(color80); BottomBorder bottomBorder26 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color81 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder26.Append(color81); DiagonalBorder diagonalBorder26 = new DiagonalBorder(); border26.Append(leftBorder26); border26.Append(rightBorder26); border26.Append(topBorder26); border26.Append(bottomBorder26); border26.Append(diagonalBorder26); Border border27 = new Border(); LeftBorder leftBorder27 = new LeftBorder() { Style = BorderStyleValues.Thin }; Color color82 = new Color() { Indexed = (UInt32Value)64U }; leftBorder27.Append(color82); RightBorder rightBorder27 = new RightBorder() { Style = BorderStyleValues.Thin }; Color color83 = new Color() { Indexed = (UInt32Value)64U }; rightBorder27.Append(color83); TopBorder topBorder27 = new TopBorder() { Style = BorderStyleValues.Medium }; Color color84 = new Color() { Indexed = (UInt32Value)64U }; topBorder27.Append(color84); BottomBorder bottomBorder27 = new BottomBorder() { Style = BorderStyleValues.Medium }; Color color85 = new Color() { Indexed = (UInt32Value)64U }; bottomBorder27.Append(color85); DiagonalBorder diagonalBorder27 = new DiagonalBorder(); border27.Append(leftBorder27); border27.Append(rightBorder27); border27.Append(topBorder27); border27.Append(bottomBorder27); border27.Append(diagonalBorder27); borders1.Append(border1); borders1.Append(border2); borders1.Append(border3); borders1.Append(border4); borders1.Append(border5); borders1.Append(border6); borders1.Append(border7); borders1.Append(border8); borders1.Append(border9); borders1.Append(border10); borders1.Append(border11); borders1.Append(border12); borders1.Append(border13); borders1.Append(border14); borders1.Append(border15); borders1.Append(border16); borders1.Append(border17); borders1.Append(border18); borders1.Append(border19); borders1.Append(border20); borders1.Append(border21); borders1.Append(border22); borders1.Append(border23); borders1.Append(border24); borders1.Append(border25); borders1.Append(border26); borders1.Append(border27); CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U }; CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U }; cellStyleFormats1.Append(cellFormat1); CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)95U }; CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U }; CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)9U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment1 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat3.Append(alignment1); CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)9U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment2 = new Alignment() { Horizontal = HorizontalAlignmentValues.CenterContinuous }; cellFormat7.Append(alignment2); CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment3 = new Alignment() { Horizontal = HorizontalAlignmentValues.CenterContinuous }; cellFormat8.Append(alignment3); CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment4 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat10.Append(alignment4); CellFormat cellFormat11 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat12 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)5U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment5 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat12.Append(alignment5); CellFormat cellFormat13 = new CellFormat() { NumberFormatId = (UInt32Value)166U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment6 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat13.Append(alignment6); CellFormat cellFormat14 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment7 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat14.Append(alignment7); CellFormat cellFormat15 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment8 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat15.Append(alignment8); CellFormat cellFormat16 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment9 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat16.Append(alignment9); CellFormat cellFormat17 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)13U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat18 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)6U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyProtection = true }; CellFormat cellFormat19 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment10 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat19.Append(alignment10); CellFormat cellFormat20 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment11 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat20.Append(alignment11); CellFormat cellFormat21 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)6U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment12 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat21.Append(alignment12); CellFormat cellFormat22 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment13 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat22.Append(alignment13); CellFormat cellFormat23 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment14 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat23.Append(alignment14); CellFormat cellFormat24 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment15 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat24.Append(alignment15); CellFormat cellFormat25 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment16 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat25.Append(alignment16); CellFormat cellFormat26 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment17 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat26.Append(alignment17); CellFormat cellFormat27 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment18 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat27.Append(alignment18); CellFormat cellFormat28 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)4U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)18U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment19 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat28.Append(alignment19); CellFormat cellFormat29 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment20 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat29.Append(alignment20); CellFormat cellFormat30 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment21 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat30.Append(alignment21); CellFormat cellFormat31 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat32 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)12U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat33 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)19U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment22 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat33.Append(alignment22); CellFormat cellFormat34 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)20U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment23 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat34.Append(alignment23); CellFormat cellFormat35 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment24 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat35.Append(alignment24); CellFormat cellFormat36 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment25 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat36.Append(alignment25); CellFormat cellFormat37 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment26 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat37.Append(alignment26); CellFormat cellFormat38 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment27 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat38.Append(alignment27); CellFormat cellFormat39 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment28 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat39.Append(alignment28); CellFormat cellFormat40 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)13U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment29 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat40.Append(alignment29); CellFormat cellFormat41 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)17U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment30 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat41.Append(alignment30); CellFormat cellFormat42 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment31 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat42.Append(alignment31); CellFormat cellFormat43 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)11U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment32 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat43.Append(alignment32); CellFormat cellFormat44 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)14U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment33 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat44.Append(alignment33); CellFormat cellFormat45 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)15U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment34 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat45.Append(alignment34); CellFormat cellFormat46 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment35 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat46.Append(alignment35); CellFormat cellFormat47 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)10U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat48 = new CellFormat() { NumberFormatId = (UInt32Value)49U, FontId = (UInt32Value)10U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat49 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment36 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat49.Append(alignment36); CellFormat cellFormat50 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment37 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat50.Append(alignment37); CellFormat cellFormat51 = new CellFormat() { NumberFormatId = (UInt32Value)167U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment38 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat51.Append(alignment38); CellFormat cellFormat52 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)10U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat53 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)9U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat54 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment39 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat54.Append(alignment39); CellFormat cellFormat55 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)8U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment40 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat55.Append(alignment40); CellFormat cellFormat56 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)5U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment41 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center, WrapText = true }; cellFormat56.Append(alignment41); CellFormat cellFormat57 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)12U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment42 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right, Vertical = VerticalAlignmentValues.Center }; cellFormat57.Append(alignment42); CellFormat cellFormat58 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment43 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat58.Append(alignment43); CellFormat cellFormat59 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)12U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment44 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right, Vertical = VerticalAlignmentValues.Center }; cellFormat59.Append(alignment44); CellFormat cellFormat60 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)6U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment45 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat60.Append(alignment45); CellFormat cellFormat61 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)7U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat62 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)7U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment46 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat62.Append(alignment46); CellFormat cellFormat63 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment47 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat63.Append(alignment47); CellFormat cellFormat64 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)16U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment48 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat64.Append(alignment48); CellFormat cellFormat65 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)22U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment49 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat65.Append(alignment49); CellFormat cellFormat66 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)23U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyProtection = true }; CellFormat cellFormat67 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)24U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment50 = new Alignment() { Horizontal = HorizontalAlignmentValues.Left }; cellFormat67.Append(alignment50); CellFormat cellFormat68 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)21U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment51 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat68.Append(alignment51); CellFormat cellFormat69 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)10U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment52 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat69.Append(alignment52); CellFormat cellFormat70 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment53 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat70.Append(alignment53); CellFormat cellFormat71 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)8U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment54 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat71.Append(alignment54); CellFormat cellFormat72 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment55 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat72.Append(alignment55); CellFormat cellFormat73 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)25U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment56 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat73.Append(alignment56); CellFormat cellFormat74 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment57 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat74.Append(alignment57); CellFormat cellFormat75 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment58 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat75.Append(alignment58); CellFormat cellFormat76 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment59 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat76.Append(alignment59); CellFormat cellFormat77 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)11U, FillId = (UInt32Value)11U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment60 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat77.Append(alignment60); CellFormat cellFormat78 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment61 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat78.Append(alignment61); CellFormat cellFormat79 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment62 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat79.Append(alignment62); CellFormat cellFormat80 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)7U, FillId = (UInt32Value)12U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment63 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat80.Append(alignment63); CellFormat cellFormat81 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment64 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat81.Append(alignment64); CellFormat cellFormat82 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment65 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat82.Append(alignment65); CellFormat cellFormat83 = new CellFormat() { NumberFormatId = (UInt32Value)17U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment66 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat83.Append(alignment66); CellFormat cellFormat84 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)9U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment67 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat84.Append(alignment67); CellFormat cellFormat85 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment68 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat85.Append(alignment68); CellFormat cellFormat86 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)10U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true }; Alignment alignment69 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center }; cellFormat86.Append(alignment69); CellFormat cellFormat87 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)8U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment70 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat87.Append(alignment70); CellFormat cellFormat88 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment71 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat88.Append(alignment71); CellFormat cellFormat89 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)1U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment72 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat89.Append(alignment72); CellFormat cellFormat90 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)3U, FillId = (UInt32Value)4U, BorderId = (UInt32Value)7U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment73 = new Alignment() { Horizontal = HorizontalAlignmentValues.Right }; cellFormat90.Append(alignment73); CellFormat cellFormat91 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment74 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat91.Append(alignment74); CellFormat cellFormat92 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment75 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat92.Append(alignment75); CellFormat cellFormat93 = new CellFormat() { NumberFormatId = (UInt32Value)4U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment76 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat93.Append(alignment76); CellFormat cellFormat94 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment77 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat94.Append(alignment77); CellFormat cellFormat95 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment78 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat95.Append(alignment78); CellFormat cellFormat96 = new CellFormat() { NumberFormatId = (UInt32Value)2U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)26U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true, ApplyProtection = true }; Alignment alignment79 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center }; cellFormat96.Append(alignment79); cellFormats1.Append(cellFormat2); cellFormats1.Append(cellFormat3); cellFormats1.Append(cellFormat4); cellFormats1.Append(cellFormat5); cellFormats1.Append(cellFormat6); cellFormats1.Append(cellFormat7); cellFormats1.Append(cellFormat8); cellFormats1.Append(cellFormat9); cellFormats1.Append(cellFormat10); cellFormats1.Append(cellFormat11); cellFormats1.Append(cellFormat12); cellFormats1.Append(cellFormat13); cellFormats1.Append(cellFormat14); cellFormats1.Append(cellFormat15); cellFormats1.Append(cellFormat16); cellFormats1.Append(cellFormat17); cellFormats1.Append(cellFormat18); cellFormats1.Append(cellFormat19); cellFormats1.Append(cellFormat20); cellFormats1.Append(cellFormat21); cellFormats1.Append(cellFormat22); cellFormats1.Append(cellFormat23); cellFormats1.Append(cellFormat24); cellFormats1.Append(cellFormat25); cellFormats1.Append(cellFormat26); cellFormats1.Append(cellFormat27); cellFormats1.Append(cellFormat28); cellFormats1.Append(cellFormat29); cellFormats1.Append(cellFormat30); cellFormats1.Append(cellFormat31); cellFormats1.Append(cellFormat32); cellFormats1.Append(cellFormat33); cellFormats1.Append(cellFormat34); cellFormats1.Append(cellFormat35); cellFormats1.Append(cellFormat36); cellFormats1.Append(cellFormat37); cellFormats1.Append(cellFormat38); cellFormats1.Append(cellFormat39); cellFormats1.Append(cellFormat40); cellFormats1.Append(cellFormat41); cellFormats1.Append(cellFormat42); cellFormats1.Append(cellFormat43); cellFormats1.Append(cellFormat44); cellFormats1.Append(cellFormat45); cellFormats1.Append(cellFormat46); cellFormats1.Append(cellFormat47); cellFormats1.Append(cellFormat48); cellFormats1.Append(cellFormat49); cellFormats1.Append(cellFormat50); cellFormats1.Append(cellFormat51); cellFormats1.Append(cellFormat52); cellFormats1.Append(cellFormat53); cellFormats1.Append(cellFormat54); cellFormats1.Append(cellFormat55); cellFormats1.Append(cellFormat56); cellFormats1.Append(cellFormat57); cellFormats1.Append(cellFormat58); cellFormats1.Append(cellFormat59); cellFormats1.Append(cellFormat60); cellFormats1.Append(cellFormat61); cellFormats1.Append(cellFormat62); cellFormats1.Append(cellFormat63); cellFormats1.Append(cellFormat64); cellFormats1.Append(cellFormat65); cellFormats1.Append(cellFormat66); cellFormats1.Append(cellFormat67); cellFormats1.Append(cellFormat68); cellFormats1.Append(cellFormat69); cellFormats1.Append(cellFormat70); cellFormats1.Append(cellFormat71); cellFormats1.Append(cellFormat72); cellFormats1.Append(cellFormat73); cellFormats1.Append(cellFormat74); cellFormats1.Append(cellFormat75); cellFormats1.Append(cellFormat76); cellFormats1.Append(cellFormat77); cellFormats1.Append(cellFormat78); cellFormats1.Append(cellFormat79); cellFormats1.Append(cellFormat80); cellFormats1.Append(cellFormat81); cellFormats1.Append(cellFormat82); cellFormats1.Append(cellFormat83); cellFormats1.Append(cellFormat84); cellFormats1.Append(cellFormat85); cellFormats1.Append(cellFormat86); cellFormats1.Append(cellFormat87); cellFormats1.Append(cellFormat88); cellFormats1.Append(cellFormat89); cellFormats1.Append(cellFormat90); cellFormats1.Append(cellFormat91); cellFormats1.Append(cellFormat92); cellFormats1.Append(cellFormat93); cellFormats1.Append(cellFormat94); cellFormats1.Append(cellFormat95); cellFormats1.Append(cellFormat96); CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U }; CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U }; cellStyles1.Append(cellStyle1); DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)1U }; DifferentialFormat differentialFormat1 = new DifferentialFormat(); Fill fill14 = new Fill(); PatternFill patternFill14 = new PatternFill() { PatternType = PatternValues.Solid }; BackgroundColor backgroundColor12 = new BackgroundColor() { Indexed = (UInt32Value)9U }; patternFill14.Append(backgroundColor12); fill14.Append(patternFill14); differentialFormat1.Append(fill14); differentialFormats1.Append(differentialFormat1); TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" }; Colors colors1 = new Colors(); IndexedColors indexedColors1 = new IndexedColors(); RgbColor rgbColor1 = new RgbColor() { Rgb = "00000000" }; RgbColor rgbColor2 = new RgbColor() { Rgb = "00FFFFFF" }; RgbColor rgbColor3 = new RgbColor() { Rgb = "00FF0000" }; RgbColor rgbColor4 = new RgbColor() { Rgb = "0000FF00" }; RgbColor rgbColor5 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor6 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor7 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor8 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor9 = new RgbColor() { Rgb = "00000000" }; RgbColor rgbColor10 = new RgbColor() { Rgb = "00FFFFFF" }; RgbColor rgbColor11 = new RgbColor() { Rgb = "00FF0000" }; RgbColor rgbColor12 = new RgbColor() { Rgb = "0000FF00" }; RgbColor rgbColor13 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor14 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor15 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor16 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor17 = new RgbColor() { Rgb = "00800000" }; RgbColor rgbColor18 = new RgbColor() { Rgb = "00008000" }; RgbColor rgbColor19 = new RgbColor() { Rgb = "00000080" }; RgbColor rgbColor20 = new RgbColor() { Rgb = "00808000" }; RgbColor rgbColor21 = new RgbColor() { Rgb = "00800080" }; RgbColor rgbColor22 = new RgbColor() { Rgb = "00008080" }; RgbColor rgbColor23 = new RgbColor() { Rgb = "00C0C0C0" }; RgbColor rgbColor24 = new RgbColor() { Rgb = "00808080" }; RgbColor rgbColor25 = new RgbColor() { Rgb = "008080FF" }; RgbColor rgbColor26 = new RgbColor() { Rgb = "00802060" }; RgbColor rgbColor27 = new RgbColor() { Rgb = "00FFFFC0" }; RgbColor rgbColor28 = new RgbColor() { Rgb = "00A0E0E0" }; RgbColor rgbColor29 = new RgbColor() { Rgb = "00600080" }; RgbColor rgbColor30 = new RgbColor() { Rgb = "00FF8080" }; RgbColor rgbColor31 = new RgbColor() { Rgb = "000080C0" }; RgbColor rgbColor32 = new RgbColor() { Rgb = "00C0C0FF" }; RgbColor rgbColor33 = new RgbColor() { Rgb = "00000080" }; RgbColor rgbColor34 = new RgbColor() { Rgb = "00FF00FF" }; RgbColor rgbColor35 = new RgbColor() { Rgb = "00FFFF00" }; RgbColor rgbColor36 = new RgbColor() { Rgb = "0000FFFF" }; RgbColor rgbColor37 = new RgbColor() { Rgb = "00800080" }; RgbColor rgbColor38 = new RgbColor() { Rgb = "00800000" }; RgbColor rgbColor39 = new RgbColor() { Rgb = "00008080" }; RgbColor rgbColor40 = new RgbColor() { Rgb = "000000FF" }; RgbColor rgbColor41 = new RgbColor() { Rgb = "0000CCFF" }; RgbColor rgbColor42 = new RgbColor() { Rgb = "0069FFFF" }; RgbColor rgbColor43 = new RgbColor() { Rgb = "00CCFFCC" }; RgbColor rgbColor44 = new RgbColor() { Rgb = "00FFFF99" }; RgbColor rgbColor45 = new RgbColor() { Rgb = "00A6CAF0" }; RgbColor rgbColor46 = new RgbColor() { Rgb = "00CC9CCC" }; RgbColor rgbColor47 = new RgbColor() { Rgb = "00CC99FF" }; RgbColor rgbColor48 = new RgbColor() { Rgb = "00E3E3E3" }; RgbColor rgbColor49 = new RgbColor() { Rgb = "003366FF" }; RgbColor rgbColor50 = new RgbColor() { Rgb = "0033CCCC" }; RgbColor rgbColor51 = new RgbColor() { Rgb = "00339933" }; RgbColor rgbColor52 = new RgbColor() { Rgb = "00999933" }; RgbColor rgbColor53 = new RgbColor() { Rgb = "00996633" }; RgbColor rgbColor54 = new RgbColor() { Rgb = "00996666" }; RgbColor rgbColor55 = new RgbColor() { Rgb = "00666699" }; RgbColor rgbColor56 = new RgbColor() { Rgb = "00969696" }; RgbColor rgbColor57 = new RgbColor() { Rgb = "003333CC" }; RgbColor rgbColor58 = new RgbColor() { Rgb = "00336666" }; RgbColor rgbColor59 = new RgbColor() { Rgb = "00003300" }; RgbColor rgbColor60 = new RgbColor() { Rgb = "00333300" }; RgbColor rgbColor61 = new RgbColor() { Rgb = "00663300" }; RgbColor rgbColor62 = new RgbColor() { Rgb = "00993366" }; RgbColor rgbColor63 = new RgbColor() { Rgb = "00333399" }; RgbColor rgbColor64 = new RgbColor() { Rgb = "00424242" }; indexedColors1.Append(rgbColor1); indexedColors1.Append(rgbColor2); indexedColors1.Append(rgbColor3); indexedColors1.Append(rgbColor4); indexedColors1.Append(rgbColor5); indexedColors1.Append(rgbColor6); indexedColors1.Append(rgbColor7); indexedColors1.Append(rgbColor8); indexedColors1.Append(rgbColor9); indexedColors1.Append(rgbColor10); indexedColors1.Append(rgbColor11); indexedColors1.Append(rgbColor12); indexedColors1.Append(rgbColor13); indexedColors1.Append(rgbColor14); indexedColors1.Append(rgbColor15); indexedColors1.Append(rgbColor16); indexedColors1.Append(rgbColor17); indexedColors1.Append(rgbColor18); indexedColors1.Append(rgbColor19); indexedColors1.Append(rgbColor20); indexedColors1.Append(rgbColor21); indexedColors1.Append(rgbColor22); indexedColors1.Append(rgbColor23); indexedColors1.Append(rgbColor24); indexedColors1.Append(rgbColor25); indexedColors1.Append(rgbColor26); indexedColors1.Append(rgbColor27); indexedColors1.Append(rgbColor28); indexedColors1.Append(rgbColor29); indexedColors1.Append(rgbColor30); indexedColors1.Append(rgbColor31); indexedColors1.Append(rgbColor32); indexedColors1.Append(rgbColor33); indexedColors1.Append(rgbColor34); indexedColors1.Append(rgbColor35); indexedColors1.Append(rgbColor36); indexedColors1.Append(rgbColor37); indexedColors1.Append(rgbColor38); indexedColors1.Append(rgbColor39); indexedColors1.Append(rgbColor40); indexedColors1.Append(rgbColor41); indexedColors1.Append(rgbColor42); indexedColors1.Append(rgbColor43); indexedColors1.Append(rgbColor44); indexedColors1.Append(rgbColor45); indexedColors1.Append(rgbColor46); indexedColors1.Append(rgbColor47); indexedColors1.Append(rgbColor48); indexedColors1.Append(rgbColor49); indexedColors1.Append(rgbColor50); indexedColors1.Append(rgbColor51); indexedColors1.Append(rgbColor52); indexedColors1.Append(rgbColor53); indexedColors1.Append(rgbColor54); indexedColors1.Append(rgbColor55); indexedColors1.Append(rgbColor56); indexedColors1.Append(rgbColor57); indexedColors1.Append(rgbColor58); indexedColors1.Append(rgbColor59); indexedColors1.Append(rgbColor60); indexedColors1.Append(rgbColor61); indexedColors1.Append(rgbColor62); indexedColors1.Append(rgbColor63); indexedColors1.Append(rgbColor64); colors1.Append(indexedColors1); stylesheet1.Append(numberingFormats1); stylesheet1.Append(fonts1); stylesheet1.Append(fills1); stylesheet1.Append(borders1); stylesheet1.Append(cellStyleFormats1); stylesheet1.Append(cellFormats1); stylesheet1.Append(cellStyles1); stylesheet1.Append(differentialFormats1); stylesheet1.Append(tableStyles1); stylesheet1.Append(colors1); workbookStylesPart1.Stylesheet = stylesheet1; }
public static void AddAnnotate(ILayer layer, string fieldName) { var pGeoLayer = layer as IGeoFeatureLayer; if (pGeoLayer != null) { var ipalpColl = pGeoLayer.AnnotationProperties; ipalpColl.Clear(); IColor fontColor = new RgbColor(); fontColor.RGB = 255; //字体颜色 var font = new Font("宋体", 10, FontStyle.Bold); var dispFont = (IFontDisp)OLE.GetIFontDispFromFont(font); ITextSymbol pTextSymbol = new TextSymbolClass { Color = fontColor, Font = dispFont, Size = 12 }; ////用来控制标注和要素的相对位置关系 ILineLabelPosition pLineLpos = new LineLabelPositionClass { Parallel = true, //修改标注的属性 //Perpendicular = false, Below = true, InLine = false, Above = false }; //用来控制标注冲突 ILineLabelPlacementPriorities pLinePlace = new LineLabelPlacementPrioritiesClass { AboveStart = 5, //让above 和start的优先级为5 BelowAfter = 4 }; //用来实现对ILineLabelPosition 和 ILineLabelPlacementPriorities以及更高级属性的控制 IBasicOverposterLayerProperties pBolp = new BasicOverposterLayerPropertiesClass { FeatureType = esriBasicOverposterFeatureType.esriOverposterPolygon, LineLabelPlacementPriorities = pLinePlace, LineLabelPosition = pLineLpos }; //创建标注对象 ILabelEngineLayerProperties pLableEngine = new LabelEngineLayerPropertiesClass { Symbol = pTextSymbol, BasicOverposterLayerProperties = pBolp, IsExpressionSimple = true, Expression = "[" + fieldName + "]" }; //设置标注的参考比例尺 var pAnnoLyrPros = (IAnnotateLayerTransformationProperties)pLableEngine; pAnnoLyrPros.ReferenceScale = 2500000; //设置标注可见的最大最小比例尺 var pAnnoPros = pLableEngine as IAnnotateLayerProperties; //pAnnoPros.AnnotationMaximumScale = 2500000; //pAnnoPros.AnnotationMinimumScale = 25000000; //pAnnoPros.WhereClause属性 设置过滤条件 ipalpColl.Add(pAnnoPros); } if (pGeoLayer != null) pGeoLayer.DisplayAnnotation = true; }
/// <summary> /// Gets the ARGB color that is mapped to from the given RGB color. /// </summary> /// <param name="source">The source RGB color.</param> /// <param name="destination">When this method returns, contains resulting ARGB color, if a mapping exists; otherwise, the default /// ARGB color. This parameter is passed uninitialized.</param> /// <returns>Returns true if a mapping was found; otherwise, false.</returns> public bool TryGetMapping(RgbColor source, out ArgbColor destination) { return map.TryGetValue(source, out destination); }
private byte[] getLayerCountByType(System.Collections.Specialized.NameValueCollection boundVariables, ESRI.ArcGIS.SOESupport.JsonObject operationInput, string outputFormat, string requestProperties, out string responseProperties) { IMapImage mapImage = null; bool? shouldAdd = null; operationInput.TryGetAsBoolean("addlayer", out shouldAdd); if (shouldAdd.HasValue) { if ((bool)shouldAdd) { if (((IMapServerInfo4)mapServerInfo).SupportsDynamicLayers) { IRgbColor color = new RgbColor(){ Blue = 255}; ISimpleLineSymbol outline = new SimpleLineSymbol(){ Color = color, Width = 1, Style = esriSimpleLineStyle.esriSLSSolid }; ISimpleFillSymbol sfs = new SimpleFillSymbol(){ Color = color, Outline = outline, Style = esriSimpleFillStyle.esriSFSSolid }; ISimpleRenderer sr = new SimpleRenderer(){ Symbol = (ISymbol)sfs }; IFeatureLayerDrawingDescription featureLayerDrawingDesc = new FeatureLayerDrawingDescription(){ FeatureRenderer = (IFeatureRenderer)sr }; IMapServerSourceDescription mapServerSourceDesc = new TableDataSourceDescriptionClass(); ((IDataSourceDescription)mapServerSourceDesc).WorkspaceID = "MyFGDB"; ((ITableDataSourceDescription)mapServerSourceDesc).TableName = "B"; IDynamicLayerDescription dynamicLayerDesc = new LayerDescriptionClass(){ ID = 3, Visible = true, DrawingDescription = (ILayerDrawingDescription)featureLayerDrawingDesc, Source = mapServerSourceDesc }; mapDesc.HonorLayerReordering = true; mapDesc.LayerDescriptions.Insert(0, (ILayerDescription)dynamicLayerDesc); mapImage = exportMap(); } } else { mapImage = exportMap(); } } responseProperties = null; JSONObject json = new JSONObject(); json.AddString("URL", mapImage.URL); return Encoding.UTF8.GetBytes(json.ToJSONString(null)); }