Global type definitions

Angle

Specifies the range angle.

BlipFillType

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

• "tile" - if the image is smaller than the shape 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.

Direction

Specifies the direction of end in the specified range.

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

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 is applied to the top left cell.
• "topRightCell" - specifies that the table formatting is applied to the top right cell.
• "bottomLeftCell" - specifies that the table formatting is applied to the bottom left cell.
• "bottomRightCell" - specifies that the table formatting is applied to the bottom right cell.
• "firstRow" - specifies that the table formatting is applied to the first row.
• "lastRow" - specifies that the table formatting is applied to the last row.
• "firstColumn" - specifies that the table formatting is applied 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 is applied to the last column.
• "bandedColumn" - specifies that the table formatting is applied to odd numbered groupings of rows.
• "bandedColumnEven" - specifies that the table formatting is applied to even numbered groupings of rows.
• "bandedRow" - specifies that the table formatting is applied to odd numbered groupings of columns.
• "bandedRowEven" - specifies that the table formatting is applied to even numbered groupings of columns.
• "wholeTable" - specifies that the conditional formatting is applied 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");