【C#】【EXCEL】Bumblebee/Classes/ExEnums.cs

Bumblebee/Classes/ExEnums.cs

Flow diagram

Description

这个流程图展示了 Bumblebee 命名空间中定义的各种枚举类型。以下是对应的说明：

1. Bumblebee Namespace (Bumblebee 命名空间)
   • 包含所有定义的枚举类型
2. Enums (枚举类型)
   • 分为几个主要类别
3. Border Enums (边框相关枚举)
   • HorizontalBorder (水平边框)
   • VerticalBorder (垂直边框)
   • LineType (线条类型)
   • BorderWeight (边框粗细)
4. Formatting Enums (格式化相关枚举)
   • Justification (对齐方式)
5. Chart Enums (图表相关枚举)
   • ChartFill (图表填充)
   • RadialChartType (径向图表类型)
   • BarChartType (条形图类型)
   • LineChartType (线形图类型)
   • ScatterChartType (散点图类型)
   • SurfaceChartType (表面图类型)
   • LegendLocations (图例位置)
   • LabelType (标签类型)
   • GridType (网格类型)
6. Shape Enums (形状相关枚举)
   • ShapeList (形状列表)
   • ArrowStyle (箭头样式)
   • ShapeArrow (箭头形状)
   • ShapeStar (星形)
   • ShapeFlowChart (流程图形状)
   • ShapeSymbol (符号形状)
   • ShapeGeometry (几何形状)
   • ShapeFigure (图形形状)
7. Other Enums (其他枚举)
   • ValueCondition (值条件)
   • AverageCondition (平均值条件)
   • VbModuleType (VB模块类型)
   • Extensions (扩展名)

Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Bumblebee
{
    // 边框相关枚举
    /// <summary>
    /// 水平边框类型
    /// </summary>
    public enum HorizontalBorder { None, Bottom, Top, Both, Between, All };

    /// <summary>
    /// 垂直边框类型
    /// </summary>
    public enum VerticalBorder { None, Left, Right, Both, Between, All };

    /// <summary>
    /// 线条类型
    /// </summary>
    public enum LineType { None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot };

    /// <summary>
    /// 边框粗细
    /// </summary>
    public enum BorderWeight { Hairline, Thin, Medium, Thick, None };

    // 格式化相关枚举
    /// <summary>
    /// 对齐方式
    /// </summary>
    public enum Justification { BottomLeft, BottomMiddle, BottomRight, CenterLeft, CenterMiddle, CenterRight, TopLeft, TopMiddle, TopRight };

    // 条件相关枚举
    /// <summary>
    /// 值条件
    /// </summary>
    public enum ValueCondition { Greater, GreaterEqual, Less, LessEqual, Equal, NotEqual };

    /// <summary>
    /// 平均值条件
    /// </summary>
    public enum AverageCondition { AboveAverage, AboveEqualAverage, AboveDeviation, BelowAverage, BelowEqualAverage, BelowDeviation };

    // 模块类型枚举
    /// <summary>
    /// VB模块类型
    /// </summary>
    public enum VbModuleType { ClassModule, Document, MSForm, StdModule, ActiveX};

    // 图表相关枚举
    /// <summary>
    /// 图表填充类型
    /// </summary>
    public enum ChartFill { Cluster, Stack, Fill};

    /// <summary>
    /// 径向图表类型
    /// </summary>
    public enum RadialChartType { Pie, Pie3D, Donut, Radar, RadarFilled};

    /// <summary>
    /// 条形图类型
    /// </summary>
    public enum BarChartType { Basic, Box, Pyramid, Cylinder, Cone };

    /// <summary>
    /// 线形图类型
    /// </summary>
    public enum LineChartType { Line, LineMarkers, Area, Area3d };

    /// <summary>
    /// 散点图类型
    /// </summary>
    public enum ScatterChartType { Scatter, ScatterLines, ScatterSmooth, Bubble, Bubble3D };

    /// <summary>
    /// 表面图类型
    /// </summary>
    public enum SurfaceChartType { Surface, SurfaceWireframe, SurfaceTop, SurfaceWireframeTop };

    /// <summary>
    /// 图例位置
    /// </summary>
    public enum LegendLocations { None, Left, Right, Top, Bottom};

    /// <summary>
    /// 标签类型
    /// </summary>
    public enum LabelType { None, Value, Category};

    /// <summary>
    /// 网格类型
    /// </summary>
    public enum GridType { None, Primary, All };

    // 形状相关枚举
    /// <summary>
    /// 形状列表
    /// </summary>
    public enum ShapeList { AlternatingFlow, AlternatingHexagons, BasicBlockList, CircleAccentTimeline, ConvergingArrows, DivergingArrows, Grouped, HorizontalBullet, LinearVenn, Lined, MultidirectionalCycle, NondirectionalCycle, Process, SquareAccent, Stacked, Trapezoid, VerticalAccent, VerticalArrow, VerticalBlock, VerticalBox, VerticalBullet, VerticalCircle };

    /// <summary>
    /// 箭头样式
    /// </summary>
    public enum ArrowStyle { None, Open, Oval, Diamond, Stealth, Triangle};

    /// <summary>
    /// 箭头形状
    /// </summary>
    public enum ShapeArrow { Right, Left, Up, Down, LeftRight, UpDown, Quad, LeftRightUp, Bent, UTurn, LeftUp, BentUp, CurvedRight, CurvedLeft, CurvedUp, CurvedDown, StripedRight, NotchedRight, Circular, Swoosh, LeftCircular, LeftRightCircular };

    /// <summary>
    /// 星形
    /// </summary>
    public enum ShapeStar { Pt4, Pt5, Pt6, Pt7, Pt8, Pt10, Pt12, Pt16, Pt24, Pt32};

    /// <summary>
    /// 流程图形状
    /// </summary>
    public enum ShapeFlowChart { Process, AlternateProcess, Decision, Data, PredefinedProcess, InternalStorage, Document, Multidocument, Terminator, Preparation, ManualInput, ManualOperation, Connector, OfflineStorage, OffpageConnector, Card, PunchedTape, SummingJunction, Or, Collate, Sort, Extract, Merge, StoredData, Delay, SequentialAccessStorage, MagneticDisk, DirectAccessStorage, Display };

    /// <summary>
    /// 符号形状
    /// </summary>
    public enum ShapeSymbol { Plus, Minus, Multiply, Divide, Equal, NotEqual, LeftBracket, RightBracket, DoubleBracket, LeftBrace, RightBrace, DoubleBrace };

    /// <summary>
    /// 几何形状
    /// </summary>
    public enum ShapeGeometry { Rectangle, Parallelogram, Trapezoid, Diamond, RoundedRectangle, Octagon, IsoscelesTriangle, RightTriangle, Oval, Hexagon, Cross, RegularPentagon, Pentagon, Donut, BlockArc, NonIsoscelesTrapezoid, Decagon, Heptagon, Dodecagon, Round1Rectangle, Round2SameRectangle, SnipRoundRectangle, Snip1Rectangle, Snip2SameRectangle, Round2DiagRectangle, Snip2DiagRectangle };

    /// <summary>
    /// 图形形状
    /// </summary>
    public enum ShapeFigure { Can, Cube, Bevel, FoldedCorner, SmileyFace, NoSymbol, Heart, LightningBolt, Sun, Moon, Arc, Plaque, Cloud, Gear6, Gear9, Funnel, Chevron, Explosion1, Balloon, Explosion2, Wave, DoubleWave, DiagonalStripe, Pie, Frame, HalfFrame, Tear, Chord, Corner, PieWedge };

    // 其他枚举
    /// <summary>
    /// 文件扩展名
    /// </summary>
    public enum Extensions { xlxs, xlxm};
}

1. 边框相关枚举：这些枚举用于定义电子表格或文档中的边框样式。例如，HorizontalBorder和VerticalBorder可以用来设置单元格的边框，而LineType和BorderWeight可以进一步定制边框的外观。
2. 图表相关枚举：这组枚举提供了丰富的图表类型和样式选项。从基本的饼图（RadialChartType.Pie）到复杂的3D表面图（SurfaceChartType.Surface），开发者可以创建各种类型的数据可视化。
3. 形状相关枚举：这些枚举提供了广泛的形状选项，可用于创建复杂的图表、流程图或其他视觉元素。例如，ShapeFlowChart枚举包含了创建标准流程图所需的所有常见形状。