示例#1
0
 internal void ReadXml(XElement node, MemoryFolder mFolder, XFile xFile)
 {
     foreach (XElement element in node.Elements())
     {
         if (element.Name.LocalName == "layout")
         {
             Dt.Xls.Chart.Layout layout = new Dt.Xls.Chart.Layout();
             layout.ReadXml(element, mFolder, xFile);
             this.Layout = layout;
         }
         else if (element.Name.LocalName == "numFmt")
         {
             Dt.Xls.Chart.NumberFormat format = ChartCommonSimpleNodeHelper.ReadNumberFormatNode(element);
             this.NumberFormat       = format.NumberFormatCode;
             this.NumberFormatLinked = format.LinkToSource;
         }
         else if (element.Name.LocalName == "tx")
         {
             foreach (XElement element2 in element.Elements())
             {
                 if (element2.Name.LocalName == "rich")
                 {
                     Dt.Xls.Chart.RichText text = new Dt.Xls.Chart.RichText();
                     text.ReadXml(element2, mFolder, xFile);
                     this.RichText = text;
                 }
                 else if (element2.Name.LocalName == "strRef")
                 {
                     this.TextStringReference = element2.GetChildElementValue("f");
                 }
             }
         }
     }
 }
示例#2
0
        internal void ReadXml(XElement node, MemoryFolder mFolder, XFile xFile)
        {
            foreach (XElement element in node.Elements())
            {
                if (element.Name.LocalName == "legendPos")
                {
                    switch (element.GetAttributeValueOrDefaultOfStringType("val", "r"))
                    {
                    case "r":
                        this.Position = ExcelLegendPositon.Right;
                        break;

                    case "l":
                        this.Position = ExcelLegendPositon.Left;
                        break;

                    case "t":
                        this.Position = ExcelLegendPositon.Top;
                        break;

                    case "b":
                        this.Position = ExcelLegendPositon.Bottom;
                        break;

                    case "tr":
                        this.Position = ExcelLegendPositon.TopRight;
                        break;
                    }
                }
                else if (element.Name.LocalName == "legendEntry")
                {
                    ExcelLegendEntry entry = new ExcelLegendEntry();
                    entry.ReadXml(element, mFolder, xFile);
                    this.LegendEntries.Add(entry);
                }
                else if (element.Name.LocalName == "layout")
                {
                    Dt.Xls.Chart.Layout layout = new Dt.Xls.Chart.Layout();
                    layout.ReadXml(element, mFolder, xFile);
                    this.Layout = layout;
                }
                else if (element.Name.LocalName == "overlay")
                {
                    this.Overlay = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "spPr")
                {
                    ExcelChartFormat format = new ExcelChartFormat();
                    format.ReadXml(element, mFolder, xFile);
                    this.ShapeFormat = format;
                }
                else if (element.Name.LocalName == "txPr")
                {
                    ExcelTextFormat format2 = new ExcelTextFormat();
                    format2.ReadXml(element, mFolder, xFile);
                    this.TextFormat = format2;
                }
            }
        }
示例#3
0
 internal void ReadXml(XElement node, MemoryFolder mFolder, XFile xFile)
 {
     foreach (XElement element in node.Elements())
     {
         if (element.Name.LocalName == "overlay")
         {
             this.Overlay = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
         }
         else if (element.Name.LocalName == "layout")
         {
             Dt.Xls.Chart.Layout layout = new Dt.Xls.Chart.Layout();
             layout.ReadXml(element, mFolder, xFile);
             this.Layout = layout;
         }
         else if (element.Name.LocalName == "spPr")
         {
             ExcelChartFormat format = new ExcelChartFormat();
             format.ReadXml(element, mFolder, xFile);
             this.ShapeFormat = format;
         }
         else if (element.Name.LocalName == "txPr")
         {
             ExcelTextFormat format2 = new ExcelTextFormat();
             format2.ReadXml(element, mFolder, xFile);
             this.TextForamt = format2;
         }
         else if (element.Name.LocalName == "tx")
         {
             foreach (XElement element2 in element.Elements())
             {
                 if (element2.Name.LocalName == "rich")
                 {
                     RichText text = new RichText();
                     text.ReadXml(element2, mFolder, xFile);
                     this.RichTextTitle = text;
                 }
                 else if (element2.Name.LocalName == "strRef")
                 {
                     this.TitleFormula = element2.GetChildElementValue("f");
                     if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
                     {
                         this.TitleFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.TitleFormula, 0, 0);
                     }
                 }
             }
         }
     }
 }
示例#4
0
 internal void ReadXml(XElement node, MemoryFolder mFolder, XFile xFile)
 {
     foreach (XElement element in node.Elements())
     {
         if (element.Name.LocalName == "custUnit")
         {
             this.CustomDisplayUnit = element.GetAttributeValueOrDefaultOfDoubleType("val", 0.0);
         }
         else if (element.Name.LocalName == "builtInUnit")
         {
             BuiltInDisplayUnitValue hundreds = BuiltInDisplayUnitValue.Hundreds;
             Enum.TryParse <BuiltInDisplayUnitValue>(element.GetAttributeValueOrDefaultOfStringType("val", "hundreds"), true, out hundreds);
             this.BuiltInDisplayUnit = hundreds;
         }
         else if (element.Name.LocalName == "dispUnitsLbl")
         {
             foreach (XElement element2 in element.Elements())
             {
                 if (element2.Name.LocalName == "layout")
                 {
                     Dt.Xls.Chart.Layout layout = new Dt.Xls.Chart.Layout();
                     layout.ReadXml(element2, mFolder, xFile);
                     this.Layout = layout;
                 }
                 else if (element2.Name.LocalName == "tx")
                 {
                     foreach (XElement element3 in element.Elements())
                     {
                         if (element3.Name.LocalName == "rich")
                         {
                             Dt.Xls.Chart.RichText text = new Dt.Xls.Chart.RichText();
                             text.ReadXml(element3, mFolder, xFile);
                             this.RichText = text;
                         }
                         else if (element3.Name.LocalName == "strRef")
                         {
                             this.TextFormula = element3.GetChildElementValue("f");
                         }
                     }
                 }
             }
         }
     }
 }
示例#5
0
        internal void ReadXml(XElement node, MemoryFolder mFolder, XFile xFile)
        {
            foreach (XElement element in node.Elements())
            {
                if (element.Name.LocalName == "idx")
                {
                    this.Index = element.GetAttributeValueOrDefaultOfInt32Type("val", 0);
                }
                else if (element.Name.LocalName == "layout")
                {
                    Dt.Xls.Chart.Layout layout = new Dt.Xls.Chart.Layout();
                    layout.ReadXml(element, mFolder, xFile);
                    this.Layout = layout;
                }
                else if (element.Name.LocalName == "delete")
                {
                    this.Delete = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "numFmt")
                {
                    Dt.Xls.Chart.NumberFormat format = ChartCommonSimpleNodeHelper.ReadNumberFormatNode(element);
                    this.NumberFormat       = format.NumberFormatCode;
                    this.NumberFormatLinked = format.LinkToSource;
                }
                else if (element.Name.LocalName == "dLblPos")
                {
                    switch (element.GetAttributeValueOrDefaultOfStringType("val", "bestFit"))
                    {
                    case "b":
                        this.Position = DataLabelPosition.Bottom;
                        break;

                    case "bestFit":
                        this.Position = DataLabelPosition.BestFit;
                        break;

                    case "ctr":
                        this.Position = DataLabelPosition.Center;
                        break;

                    case "inBase":
                        this.Position = DataLabelPosition.InsideBase;
                        break;

                    case "inEnd":
                        this.Position = DataLabelPosition.InsideEnd;
                        break;

                    case "l":
                        this.Position = DataLabelPosition.Left;
                        break;

                    case "outEnd":
                        this.Position = DataLabelPosition.OutsideEnd;
                        break;

                    case "r":
                        this.Position = DataLabelPosition.Right;
                        break;

                    case "t":
                        this.Position = DataLabelPosition.Top;
                        break;
                    }
                }
                else if (element.Name.LocalName == "separator")
                {
                    this.Separator = element.Value;
                }
                else if (element.Name.LocalName == "showLegendKey")
                {
                    this.ShowLegendKey = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "showVal")
                {
                    this.ShowValue = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "showCatName")
                {
                    this.ShowCategoryName = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "showSerName")
                {
                    this.ShowSeriesName = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "showPercent")
                {
                    this.ShowPercentage = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "showBubbleSize")
                {
                    this.ShowBubbleSize = element.GetAttributeValueOrDefaultOfBooleanType("val", true);
                }
                else if (element.Name.LocalName == "tx")
                {
                    foreach (XElement element2 in element.Elements())
                    {
                        if (element2.Name.LocalName == "rich")
                        {
                            Dt.Xls.Chart.RichText text = new Dt.Xls.Chart.RichText();
                            text.ReadXml(element2, mFolder, xFile);
                            this.RichText = text;
                        }
                        else if (element2.Name.LocalName == "strRef")
                        {
                            this.TextFormula = element2.GetChildElementValue("f");
                            if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
                            {
                                this.TextFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.TextFormula, 0, 0);
                            }
                        }
                    }
                }
                else if (element.Name.LocalName == "spPr")
                {
                    ExcelChartFormat format2 = new ExcelChartFormat();
                    format2.ReadXml(element, mFolder, xFile);
                    this.ShapeFormat = format2;
                }
                else if (element.Name.LocalName == "txPr")
                {
                    ExcelTextFormat format3 = new ExcelTextFormat();
                    format3.ReadXml(element, mFolder, xFile);
                    this.TextFormat = format3;
                }
            }
        }