Global type definitions

BlipFillType

The type of a fill which uses an image as a background.

• "tile" - if the image is smaller than the shaped which is filled, the image will be tiled all over the created shape surface.
• "stretch" - if the image is smaller than the shape which is filled, the image will be stretched to fit the created shape surface.

Example

// Create a blip fill with an image which is tiled all over the created shape:
oFill = Api.CreateBlipFill("https://example.com/myimage.png", "tile");

BordersIndex

Specifies the cell border position.

Example

// The cell will have a bottom black dotted border:
oWorksheet.GetRange("E2").SetBorders("Bottom", "Dotted", Api.CreateColorFromRGB(0, 0, 0));

BorderType

A border type

Example

// The paragraph will have a single 3 point wide green bottom border with a zero offset from the bottom paragraph edge:
oParaPr.SetBottomBorder("single", 24, 0, 0, 255, 0);

BulletType

A bullet type which will be added to the paragraph in spreadsheet or presentation.

Example

// The paragraph will be starting with the Arabic numeral which has parenthesis:
oBullet = Api.CreateNumbering("ArabicParenR");

byte

A numeric value from 0 to 255.

Example

// The resulting color is green, the bytes are measured in decimal numbers:
oRGBColor = Api.CreateRGBColor(0, 255, 0);
// The resulting color is green, the bytes are measured in hexadecimal numbers:
oRGBColor = Api.CreateRGBColor(0, 0xff, 0);

ChartType

This type specifies the available chart types which can be used to create a new chart.

Example

// ChartType used in text documents
// The resulting chart will have a 'bar3D' type:
oDrawing = Api.CreateChart("bar3D", [[200, 240, 280],[250, 260, 280]], ["Projected Revenue", "Estimated Costs"], [2014, 2015, 2016], 4051300, 2347595, 24);

// ChartType used in spreadsheets
// The resulting chart will have a 'bar3D' type:
oDrawing = Api.CreateChart("bar3D", [[200, 240, 280],[250, 260, 280]], ["Projected Revenue", "Estimated Costs"], [2014, 2015, 2016], 4051300, 2347595, 24);

ContentControl

ContentControlLock

Is a value that defines if it is possible to delete and/or edit the content control or not

0 - only deleting 1 - disable deleting or editing 2 - only editing 3 - full access

ContentControlProperties

ContentControlPropertiesAndContent

Is array of properties and contents of content controls.

ContentControlType

Is a numeric value that specifies the content control type.

DocumentElement

Any valid element which can be added to the document structure.

Example

// Add a document element called 'paragraph' to the document:
oDocument.AddElement(oParagraph);

EMU

English measure unit. 1 mm = 36000 EMUs, 1 inch = 914400 EMUs.

Example

// Set the size of the drawing to be created as 100 mm (10 cm) in width and 100 mm (10 cm) in height:
oDrawing.SetSize(100 * 36000, 100 * 36000);

HdrFtrType

Header and footer types which can be applied to the document sections.

• "default" - a header or footer which can be applied to any default page.
• "title" - a header or footer which is applied to the title page.
• "even" - a header or footer which can be applied to even pages to distinguish them from the odd ones (which will be considered default).

Example

// Remove the header of the 'title' type from the final document section:
var oDocContent = oFinalSection.RemoveHeader("title");

hps

Half-points (2 half-points = 1 point).

Example

// Set the text font size to 11 points:
oTextPr.SetFontSize(22);

line240

240ths of a line.

Example

// The paragraph line spacing is set to 1 line:
oParaPr.SetSpacingLine(240, "auto");

LineStyle

Specifies the line style used to form the cell border.

Example

// The cell will have a bottom black dotted border:
oWorksheet.GetRange("E2").SetBorders("Bottom", "Dotted", Api.CreateColorFromRGB(0, 0, 0));

PageOrientation

ParagraphContent

The types of elements that can be added to the paragraph structure.

Example

// Add an element called 'text run' to the paragraph:
oParagraph.AddElement(oRun,0);

PatternType

The available preset patterns which can be used for the fill.

Example

// Create a fill with a 'dashDnDiag' pattern which has two colors - green and red:
oFill = Api.CreatePatternFill("dashDnDiag", Api.CreateRGBColor(0, 225, 0), Api.CreateRGBColor(255, 0, 0));

PositiveFixedAngle

A 60000th of a degree (5400000 = 90 degrees).

Example

// The resulting gradient direction angle is 90 degrees:
oFill = Api.CreateLinearGradientFill([oGs1, oGs2], 5400000);

PositivePercentage

The 1000th of a percent (100000 = 100%).

Example

// The resulting gradient stop position is 100%:
var oGs2 = Api.CreateGradientStop(Api.CreateRGBColor(255, 164, 101), 100000);

PresetColor

The available preset color names.

Example

// Create a scheme color using the 'lightYellow' color preset:
oSchemeColor = Api.CreatePresetColor("lightYellow");

pt

A point.

Example

// The paragraph will have a single 3 point wide green bottom border with a 1 point offset from the bottom paragraph edge:
oParaPr.SetBottomBorder("single", 24, 1, 0, 255, 0);

pt_8

Eighths of a point (24 eighths of a point = 3 points).

Example

// The paragraph will have a single 6 point wide green bottom border with a zero offset from the bottom paragraph edge:
oParaPr.SetBottomBorder("single", 48, 0, 0, 255, 0);

RelFromH

The possible values for the base which the relative horizontal positioning of an object will be calculated from.

Example

// The created drawing will be centered horizontally relative to the page width:
oDrawing.SetHorAlign("page", "center");

RelFromV

The possible values for the base which the relative vertical positioning of an object will be calculated from.

Example

// The created drawing will be centered vertically relative to the paragraph height:
oDrawing.SetHorAlign("paragraph", "center");

SchemeColorId

The available color scheme identifiers.

Example

// Create a scheme color with the 'accent2' identifier:
oSchemeColor = Api.CreateSchemeColor("accent2");

SdtLock

ShapeType

This type specifies the preset shape geometry that will be used for a shape.

Example

// Create a shape using the 'diamond' preset:
oDrawing = Api.CreateShape("diamond", 100 * 36000, 100 * 36000, oFill, oStroke);

ShdType

A shade type which can be added to the document element.

Example

// Add a green shadow to the table:
oTablePr.SetShd("clear", 0, 255, 0, false);

StyleType

The style type used for the document element.

Example

// Assign the default document paragraph style to the 'oNormalStyle' variable:
var oNormalStyle = oDocument.GetDefaultStyle("paragraph");

TabJc

Types of custom tab.

Example

// Set tab positions at 50, 75 and 150 points with the text aligned center, left and right at each tab stop accordingly:
oParaPr.SetTabs([1000, 1500, 3000], ["center", "left", "right"]);

TableStyleOverrideType

This simple type specifies possible values for the table sections to which the current conditional formatting properties will be applied when this selected table style is used.

• "topLeftCell" - specifies that the table formatting applies to the top left cell.
• "topRightCell" - specifies that the table formatting applies to the top right cell.
• "bottomLeftCell" - specifies that the table formatting applies to the bottom left cell.
• "bottomRightCell" - specifies that the table formatting applies to the bottom right cell.
• "firstRow" - specifies that the table formatting applies to the first row.
• "lastRow" - specifies that the table formatting applies to the last row.
• "firstColumn" - specifies that the table formatting applies to the first column. Any subsequent row which is in table header ( ApiTableRowPr.SetTableHeader ) will also use this conditional format.
• "lastColumn" - specifies that the table formatting applies to the last column.
• "bandedColumn" - specifies that the table formatting applies to odd numbered groupings of rows.
• "bandedColumnEven" - specifies that the table formatting applies to even numbered groupings of rows.
• "bandedRow" - specifies that the table formatting applies to odd numbered groupings of columns.
• "bandedRowEven" - specifies that the table formatting applies to even numbered groupings of columns.
• "wholeTable" - specifies that the conditional formatting applies to the whole table.

Example

// Apply the created style (set shadow) to the top left cell of the table:
oTableStyle.GetConditionalTableStyle("topLeftCell").GetTableCellPr().SetShd("clear", 255, 0, 0);

TableWidth

The possible values for the units of the width property are defined by a specific table or table cell width property.

• "auto" - set the table or table cell width to auto width.
• "twips" - set the table or table cell width to be measured in twentieths of a point.
• "nul" - set the table or table cell width to be of a zero value.
• "percent" - set the table or table cell width to be measured in percent to the parent container.

Example

// Set the width of the table cell equal to 100 points (2000 twips):
oTableCell.SetWidth("twips", 2000);

TickLabelPosition

Possible values for the position of chart tick labels (either horizontal or vertical).

• "none" - not display the selected tick labels.
• "nextTo" - set the position of the selected tick labels next to the main label.
• "low" - set the position of the selected tick labels in the part of the chart with lower values.
• "high" - set the position of the selected tick labels in the part of the chart with higher values.

Example

// Set the position of the vertical tick labels next to the main vertical label:
oChart.SetVertAxisTickLabelPosition("nextTo");

TickMark

twips

Twentieths of a point (equivalent to 1/1440th of an inch).

Example

// Set the distance between columns equal to 36 points:
oParagraph.SetEqualColumns(2, 720);

VerticalTextAlign

The available text vertical alignment (used to align text in a shape with a placement for text inside it).

Example

// The inner text for the created shape will be added aligned vertically closer to the shape upper part:
oDrawing.SetVerticalTextAlign("top");