形状
添加形状
func (f *File) AddShape(sheet, cell, format string) error
根据给定的工作表名、单元格坐标和样式(包括偏移、缩放、拉伸、宽高比和打印属性等)在指定单元格添加形状。例如,在名为 Sheet1
的工作表上添加文本框(矩形):
err := f.AddShape("Sheet1", "G6", `{"type":"rect","color":{"line":"#4286F4","fill":"#8eb9ff"},"paragraph":[{"text":"Rectangle Shape","font":{"bold":true,"italic":true,"family":"Berlin Sans FB Demi","size":36,"color":"#777777","underline":"sng"}}],"width":180,"height": 90}`)
下面是 Excelize 所支持的所有形状:
名称 | 形状 |
---|---|
accentBorderCallout1 | Callout 1 with Border and Accent Shape |
accentBorderCallout2 | Callout 2 with Border and Accent Shape |
accentBorderCallout3 | Callout 3 with Border and Accent Shape |
accentCallout1 | Callout 1 Shape |
accentCallout2 | Callout 2 Shape |
accentCallout3 | Callout 3 Shape |
actionButtonBackPrevious | Back or Previous Button Shape |
actionButtonBeginning | Beginning Button Shape |
actionButtonBlank | Blank Button Shape |
actionButtonDocument | Document Button Shape |
actionButtonEnd | End Button Shape |
actionButtonForwardNext | Forward or Next Button Shape |
actionButtonHelp | Help Button Shape |
actionButtonHome | Home Button Shape |
actionButtonInformation | Information Button Shape |
actionButtonMovie | Movie Button Shape |
actionButtonReturn | Return Button Shape |
actionButtonSound | Sound Button Shape |
arc | Curved Arc Shape |
bentArrow | Bent Arrow Shape |
bentConnector2 | Bent Connector 2 Shape |
bentConnector3 | Bent Connector 3 Shape |
bentConnector4 | Bent Connector 4 Shape |
bentConnector5 | Bent Connector 5 Shape |
bentUpArrow | Bent Up Arrow Shape |
bevel | Bevel Shape |
blockArc | Block Arc Shape |
borderCallout1 | Callout 1 with Border Shape |
borderCallout2 | Callout 2 with Border Shape |
borderCallout3 | Callout 3 with Border Shape |
bracePair | Brace Pair Shape |
bracketPair | Bracket Pair Shape |
callout1 | Callout 1 Shape |
callout2 | Callout 2 Shape |
callout3 | Callout 3 Shape |
can | Can Shape |
chartPlus | Chart Plus Shape |
chartStar | Chart Star Shape |
chartX | Chart X Shape |
chevron | Chevron Shape |
chord | Chord Shape |
circularArrow | Circular Arrow Shape |
cloud | Cloud Shape |
cloudCallout | Callout Cloud Shape |
corner | Corner Shape |
cornerTabs | Corner Tabs Shape |
cube | Cube Shape |
curvedConnector2 | Curved Connector 2 Shape |
curvedConnector3 | Curved Connector 3 Shape |
curvedConnector4 | Curved Connector 4 Shape |
curvedConnector5 | Curved Connector 5 Shape |
curvedDownArrow | Curved Down Arrow Shape |
curvedLeftArrow | Curved Left Arrow Shape |
curvedRightArrow | Curved Right Arrow Shape |
curvedUpArrow | Curved Up Arrow Shape |
decagon | Decagon Shape |
diagStripe | Diagonal Stripe Shape |
diamond | Diamond Shape |
dodecagon | Dodecagon Shape |
donut | Donut Shape |
doubleWave | Double Wave Shape |
downArrow | Down Arrow Shape |
downArrowCallout | Callout Down Arrow Shape |
ellipse | Ellipse Shape |
ellipseRibbon | Ellipse Ribbon Shape |
ellipseRibbon2 | Ellipse Ribbon 2 Shape |
flowChartAlternateProcess | Alternate Process Flow Shape |
flowChartCollate | Collate Flow Shape |
flowChartConnector | Connector Flow Shape |
flowChartDecision | Decision Flow Shape |
flowChartDelay | Delay Flow Shape |
flowChartDisplay | Display Flow Shape |
flowChartDocument | Document Flow Shape |
flowChartExtract | Extract Flow Shape |
flowChartInputOutput | Input Output Flow Shape |
flowChartInternalStorage | Internal Storage Flow Shape |
flowChartMagneticDisk | Magnetic Disk Flow Shape |
flowChartMagneticDrum | Magnetic Drum Flow Shape |
flowChartMagneticTape | Magnetic Tape Flow Shape |
flowChartManualInput | Manual Input Flow Shape |
flowChartManualOperation | Manual Operation Flow Shape |
flowChartMerge | Merge Flow Shape |
flowChartMultidocument | Multi-Document Flow Shape |
flowChartOfflineStorage | Offline Storage Flow Shape |
flowChartOffpageConnector | Off-Page Connector Flow Shape |
flowChartOnlineStorage | Online Storage Flow Shape |
flowChartOr | Or Flow Shape |
flowChartPredefinedProcess | Predefined Process Flow Shape |
flowChartPreparation | Preparation Flow Shape |
flowChartProcess | Process Flow Shape |
flowChartPunchedCard | Punched Card Flow Shape |
flowChartPunchedTape | Punched Tape Flow Shape |
flowChartSort | Sort Flow Shape |
flowChartSummingJunction | Summing Junction Flow Shape |
flowChartTerminator | Terminator Flow Shape |
foldedCorner | Folded Corner Shape |
frame | Frame Shape |
funnel | Funnel Shape |
gear6 | Gear 6 Shape |
gear9 | Gear 9 Shape |
halfFrame | Half Frame Shape |
heart | Heart Shape |
heptagon | Heptagon Shape |
hexagon | Hexagon Shape |
homePlate | Home Plate Shape |
horizontalScroll | Horizontal Scroll Shape |
irregularSeal1 | Irregular Seal 1 Shape |
irregularSeal2 | Irregular Seal 2 Shape |
leftArrow | Left Arrow Shape |
leftArrowCallout | Callout Left Arrow Shape |
leftBrace | Left Brace Shape |
leftBracket | Left Bracket Shape |
leftCircularArrow | Left Circular Arrow Shape |
leftRightArrow | Left Right Arrow Shape |
leftRightArrowCallout | Callout Left Right Arrow Shape |
leftRightCircularArrow | Left Right Circular Arrow Shape |
leftRightRibbon | Left Right Ribbon Shape |
leftRightUpArrow | Left Right Up Arrow Shape |
leftUpArrow | Left Up Arrow Shape |
lightningBolt | Lightning Bolt Shape |
line | Line Shape |
lineInv | Line Inverse Shape |
mathDivide | Divide Math Shape |
mathEqual | Equal Math Shape |
mathMinus | Minus Math Shape |
mathMultiply | Multiply Math Shape |
mathNotEqual | Not Equal Math Shape |
mathPlus | Plus Math Shape |
moon | Moon Shape |
nonIsoscelesTrapezoid | Non-Isosceles Trapezoid Shape |
noSmoking | No Smoking Shape |
notchedRightArrow | Notched Right Arrow Shape |
octagon | Octagon Shape |
parallelogram | Parallelogram Shape |
pentagon | Pentagon Shape |
pie | Pie Shape |
pieWedge | Pie Wedge Shape |
plaque | Plaque Shape |
plaqueTabs | Plaque Tabs Shape |
plus | Plus Shape |
quadArrow | Quad-Arrow Shape |
quadArrowCallout | Callout Quad-Arrow Shape |
rect | Rectangle Shape |
ribbon | Ribbon Shape |
ribbon2 | Ribbon 2 Shape |
rightArrow | Right Arrow Shape |
rightArrowCallout | Callout Right Arrow Shape |
rightBrace | Right Brace Shape |
rightBracket | Right Bracket Shape |
round1Rect | One Round Corner Rectangle Shape |
round2DiagRect | Two Diagonal Round Corner Rectangle Shape |
round2SameRect | Two Same-side Round Corner Rectangle Shape |
roundRect | Round Corner Rectangle Shape |
rtTriangle | Right Triangle Shape |
smileyFace | Smiley Face Shape |
snip1Rect | One Snip Corner Rectangle Shape |
snip2DiagRect | Two Diagonal Snip Corner Rectangle Shape |
snip2SameRect | Two Same-side Snip Corner Rectangle Shape |
snipRoundRect | One Snip One Round Corner Rectangle Shape |
squareTabs | Square Tabs Shape |
star10 | Ten Pointed Star Shape |
star12 | Twelve Pointed Star Shape |
star16 | Sixteen Pointed Star Shape |
star24 | Twenty Four Pointed Star Shape |
star32 | Thirty Two Pointed Star Shape |
star4 | Four Pointed Star Shape |
star5 | Five Pointed Star Shape |
star6 | Six Pointed Star Shape |
star7 | Seven Pointed Star Shape |
star8 | Eight Pointed Star Shape |
straightConnector1 | Straight Connector 1 Shape |
stripedRightArrow | Striped Right Arrow Shape |
sun | Sun Shape |
swooshArrow | Swoosh Arrow Shape |
teardrop | Teardrop Shape |
trapezoid | Trapezoid Shape |
triangle | Triangle Shape |
upArrow | Up Arrow Shape |
upArrowCallout | Callout Up Arrow Shape |
upDownArrow | Up Down Arrow Shape |
upDownArrowCallout | Callout Up Down Arrow Shape |
uturnArrow | U-Turn Arrow Shape |
verticalScroll | Vertical Scroll Shape |
wave | Wave Shape |
wedgeEllipseCallout | Callout Wedge Ellipse Shape |
wedgeRectCallout | Callout Wedge Rectangle Shape |
wedgeRoundRectCallout | Callout Wedge Round Rectangle Shape |