【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枚举包含了创建标准流程图所需的所有常见形状。