List of all ONLYOFFICE Document Builder classes and methods

Integration API

CDocBuilder

Name	Description
CloseFile	Close the file to stop working with it. You can use a single ONLYOFFICE Document Builder instance to work with all your files, but you need to close the previous file before you can start working with the next one in this case.
CreateFile	Create a new file. The type of the file which will be created needs to be set.
Dispose	Unloading the ONLYOFFICE Document Builder from the application memory when it is no longer needed.
ExecuteCommand	Execute the command which will be used to create the document file (text document, spreadsheet, PDF, etc.). See the Text document API and Spreadsheet API sections for more information which commands are available for various document types.
Initialize	Initializing the ONLYOFFICE Document Builder as a library for the application to be able to work with it.
OpenFile	Open the document file which will be edited and saved afterwards.
Run	Run ONLYOFFICE Document Builder executable. If you do not want to write a C++ application, you can simply use the docbuilder.exe executable file and run it with the .docbuilder file as an argument, where all the code for the document file creation will be written. For C++ the path to the executable file from the sPath parameter must be used, the CDocBuilder object created and the Run method is called.
RunTextA	Run the all the commands for the document creation using a single command. Compared to CDocBuilder.ExecuteCommand where only one command at a time is allowed, CDocBuilder.RunTextA makes it possible to enter all the commands for the document creation at once.
RunTextW	Run the all the commands for the document creation using a single command. Compared to CDocBuilder.ExecuteCommand where only one command at a time is allowed, CDocBuilder.RunTextW makes it possible to enter all the commands for the document creation at once.
SaveFile	Save the file after all the changes are made. The type of the file which will be saved needs to be set.
SetProperty	The argument which can be trasferred to the program outside the CDocBuilder.ExecuteCommand method.
SetPropertyW	The argument which can be trasferred to the program outside the CDocBuilder.ExecuteCommand method.
SetTmpFolder	The path to the folder where the program will temporarily save files needed for the program correct work. After the successful document file creation all the files will be deleted from the folder. If no temporary folder is set, the system one will be used.

Text documents API

Api

Name	Description
CreateBlipFill	Create a blip fill which allows to fill the object using a selected image as the object background.
CreateBlockLvlSdt	Create a new block level container
CreateBullet	Create a bullet for a paragraph with the character or symbol specified with the sBullet parameter.
CreateChart	Create a chart with the parameters specified.
CreateGradientStop	Create a gradient stop used for different types of gradients.
CreateImage	Create an image with the parameters specified.
CreateInlineLvlSdt	Create a new inline container
CreateLinearGradientFill	Create a linear gradient fill which allows to fill the object using a selected linear gradient as the object background.
CreateNoFill	Create no fill and remove the fill from the element.
CreateNumbering	Create a bullet for a paragraph with the character or symbol specified with the sType parameter.
CreateParagraph	Create a new paragraph.
CreatePatternFill	Create a pattern fill which allows to fill the object using a selected pattern as the object background.
CreatePresetColor	Create a color selecting it from one of the available color presets.
CreateRadialGradientFill	Create a radial gradient fill which allows to fill the object using a selected radial gradient as the object background.
CreateRGBColor	Create an RGB color setting the appropriate values for the red, green and blue color components.
CreateRun	Create a new smaller text block to be inserted to the current paragraph or table.
CreateSchemeColor	Create a complex color scheme selecting from one of the available schemes.
CreateShape	Create a shape with the parameters specified.
CreateSolidFill	Create a solid fill which allows to fill the object using a selected solid color as the object background.
CreateStroke	Create a stroke adding shadows to the element.
CreateTable	Create a new table with a specified number of rows and columns.

ApiBlockLvlSdt

Name	Description
GetAlias	Get the alias attribute for this container
GetClassType	Get the type of this class.
GetContent	Get the content of this container
GetLabel	Get the label attribute for this container
GetLock	Get the lock type of this container
GetTag	Get the tag attribute for this container
SetAlias	Set the alias attribute for this container
SetLabel	Set the label attribute for this container
SetLock	Set the lock type of this container
SetTag	Set the tag attribute for this container

ApiBullet

Name	Description
GetClassType	Get the type of this class.

ApiChart

Name	Description
GetClassType	Get the type of this class.
SetHorAxisLablesFontSize	Specifies font size for labels of horizontal axis
SetHorAxisMajorTickMark	Specifies major tick mark for horizontal axis
SetHorAxisMinorTickMark	Specifies minor tick mark for horizontal axis
SetHorAxisOrientation	Specifies a horizontal axis orientation
SetHorAxisTickLabelPosition	Spicifies tick labels position horizontal axis
SetHorAxisTitle	Specify the chart horizontal axis title.
SetLegendFontSize	Specifies a legend position
SetLegendPos	Specify the chart legend position.
SetMajorHorizontalGridlines	Specifies major horizontal gridline's visual properties
SetMajorVerticalGridlines	Specifies major vertical gridline's visual properties
SetMinorHorizontalGridlines	Specifies minor vertical gridline's visual properties
SetMinorVerticalGridlines	Specifies minor vertical gridline's visual properties
SetShowDataLabels	Specifies which chart data labels are shown for the chart.
SetShowPointDataLabel	Spicifies a show options for data labels
SetTitle	Specify the chart title.
SetVerAxisOrientation	Specifies a vertical axis orientation
SetVerAxisTitle	Specify the chart vertical axis title.
SetVertAxisLablesFontSize	Specifies font size for labels of vertical axis
SetVertAxisMajorTickMark	Specifies major tick mark for vertical axis
SetVertAxisMinorTickMark	Specifies minor tick mark for vertical axis
SetVertAxisTickLabelPosition	Spicifies tick labels position vertical axis

ApiDocument

Name	Description
AddElement	Add paragraph or table using its position in the document.
CreateNewHistoryPoint	Create new history point.
CreateNumbering	Create an abstract multilevel numbering with a specified type.
CreateSection	Create a new document section which ends at the specified paragraph. Allows to set local parameters for the current section - page size, footer, header, columns, etc.
CreateStyle	Create a new style with the specified type and name. If there is a style with the same name it will be replaced with a new one. with a new one.
GetAllContentControls	Get the list of all content controls in the document
GetClassType	Get the type of this class.
GetCommentsReport	Get a report about all the comments added to the document.
GetDefaultParaPr	Get a set of default paragraph properties in the current document.
GetDefaultStyle	Get the default style parameters for the specified document element.
GetDefaultTextPr	Get a set of default properties for the text run in the current document.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
GetFinalSection	Get the document final section
GetReviewReport	Get a report about every change which was made to the document in the review mode.
GetStyle	Get a style by the style name.
InsertContent	Insert an array of elements in the current position of the document.
InsertWatermark	Insert watermark on each page of document
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.
SearchAndReplace	Find and replace text.
SetEvenAndOddHdrFtr	Specify whether sections in this document will have different headers and footers for even and odd pages (one header/footer for odd pages and another header/footer for even pages).

ApiDocumentContent

Name	Description
AddElement	Add paragraph or table using its position in the document.
GetClassType	Get the type of the current class.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.

ApiDrawing

Name	Description
GetClassType	Get the type of the class based on this base class.
SetDistances	Specify the minimum distance which will be maintained between the edges of this drawing object and any subsequent text.
SetHorAlign	Specify how the floating object will be horizontally aligned.
SetHorPosition	Set an absolute measurement for the horizontal positioning of the floating object.
SetSize	Set the size of the object (image, shape, chart) bounding box.
SetVerAlign	Specify how the floating object will be vertically aligned.
SetVerPosition	Set an absolute measurement for the vertical positioning of the floating object.
SetWrappingStyle	Set the wrapping type of this object (image, shape, chart). One of the following wrapping style types can be set: "inline" - the object is considered to be a part of the text, like a character, so when the text moves, the object moves as well. In this case the positioning options are inaccessible. If one of the following styles is selected, the object can be moved independently of the text and positioned on the page exactly: "square" - the text wraps the rectangular box that bounds the object. "tight" - the text wraps the actual object edges. "through" - the text wraps around the object edges and fills in the open white space within the object. "topAndBottom" - the text is only above and below the object. "behind" - the text overlaps the object. "inFront" - the object overlaps the text.

ApiFill

Name	Description
GetClassType	Get the type of this class.

ApiGradientStop

Name	Description
GetClassType	Get the type of this class.

ApiImage

Name	Description
GetClassType	Get the type of this class.

ApiInlineLvlSdt

Name	Description
AddElement	Add an element to the inline text content control.
GetAlias	Get the alias attribute for this container
GetClassType	Get the type of this class.
GetElement	Get the element of the current inline text content control using the position specified.
GetElementsCount	Get the number of elements in the current inline text content control. The text content control is created with one text run present in it by default, so any even without any element added this method will return the value of '1'.
GetLabel	Get the label attribute for this container
GetLock	Get the lock type of this container
GetTag	Get the tag attribute for this container
RemoveAllElements	Remove all the elements from the current inline text content control.
RemoveElement	Remove the element using the position specified from the current inline text content control.
SetAlias	Set the alias attribute for this container
SetLabel	Add a string label to the current inline text content control.
SetLock	Set the lock to the current inline text content control: either locks the content from editing, or from deleting the control, or both.
SetTag	Add a string tag to the current inline text content control.

ApiNumbering

Name	Description
GetClassType	Get the type of this class.
GetLevel	Get the specified level of the current numbering.

ApiNumberingLevel

Name	Description
GetClassType	Get the type of this class.
GetLevelIndex	Get the level index.
GetNumbering	Get the numbering definition.
GetParaPr	The paragraph properties which are applied to any numbered paragraph that references the given numbering definition and numbering level.
GetTextPr	Specify the text properties which will be applied to the text in the current numbering level itself, not to the text in the subsequent paragraph. To change the text style for the paragraph, a style must be applied to it using the ApiRun.SetStyle method.
SetCustomType	Set your own customized numbering type.
SetRestart	Specify a one-based index which determines when a numbering level should restart to its starting value. A numbering level restarts when an instance of the specified numbering level, which will be higher (earlier than the this level) is used in the given document contents. By default this value is true.
SetStart	Specify the starting value for the numbering used by the parent numbering level within a given numbering level definition. By default this value is 1.
SetSuff	Specify the content which will be added between a given numbering level text and the text of every numbered paragraph which references that numbering level. By default this value is "tab".
SetTemplateType	Set one of the existing predefined numbering templates.

ApiParagraph

Name	Description
AddColumnBreak	Add column break to the current position and start the next element from a new column.
AddDrawing	Add an object (image, shape or chart) to the current paragraph.
AddElement	Add an element to the current paragraph.
AddInlineLvlSdt	Add a inline container
AddLineBreak	Add line break to the current position and start the next element from a new line.
AddPageBreak	Add page break and start the next element from the next page.
AddPageNumber	Insert the number of the current document page into the paragraph. This method works for the paragraphs in the document header/footer only.
AddPagesCount	Insert the number of pages in the current document into the paragraph. This method works for the paragraphs in the document header/footer only.
AddTabStop	Add a tab stop to the current paragraph.
AddText	Add some text to the element.
GetClassType	Get the type of this class.
GetElement	Get the element of the paragraph using the position specified.
GetElementsCount	Get the number of elements in the current paragraph.
GetNumbering	Get a numbering definition and numbering level for the numbered list.
GetParagraphMarkTextPr	Get the text properties of the paragraph mark which is used to mark the paragraph end. The mark can also acquire common text properties like bold, italic, underline, etc.
GetParaPr	Get paragraph properties.
RemoveAllElements	Remove all elements from the current paragraph. When all elements are removed from the paragraph, a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
RemoveElement	Remove the element using the position specified. If the element you remove is the last paragraph element (i.e. all elements are removed from the paragraph), a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
SetBetweenBorder	Specify the border which will be displayed between each paragraph in a set of paragraphs which have the same set of paragraph border settings.
SetBottomBorder	Specify the border which will be displayed below a set of paragraphs which have the same paragraph border settings. The paragraphs of the same style going one by one are considered as a single block, so the border is added to the whole block rather than to every paragraph in this block.
SetBullet	Set the bullet or numbering to the current paragraph.
SetContextualSpacing	Specify that any space before or after this paragraph set using the ApiParaPr.SetSpacingBefore or ApiParaPr.SetSpacingAfter spacing element, should not be applied when the preceding and following paragraphs are of the same paragraph style, affecting the top and bottom spacing respectively.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetKeepLines	Specify that when rendering this document using a page view, all lines of this paragraph are maintained on a single page whenever possible.
SetKeepNext	Specify that when rendering this document using a paginated view, the contents of this paragraph are at least partly rendered on the same page as the following paragraph whenever possible.
SetLeftBorder	Specify the border which will be displayed at the left side of the page around the specified paragraph.
SetNumbering	Specify that the current paragraph references a numbering definition instance in the current document.
SetNumPr	Specify that the current paragraph references a numbering definition instance in the current document.
SetPageBreakBefore	Specify that when rendering this document using a paginated view, the contents of this paragraph are rendered at the beginning of a new page in the document.
SetRightBorder	Specify the border which will be displayed at the right side of the page around the specified paragraph.
SetShd	Specify the shading applied to the contents of the paragraph.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetStyle	The paragraph style base method. This method is not used by itself, as it only forms the basis for the ApiParagraph.SetStyle method which sets the selected or created style for the paragraph.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.
SetTopBorder	Specify the border which will be displayed above a set of paragraphs which have the same set of paragraph border settings. The paragraphs of the same style going one by one are considered as a single block, so the border is added to the whole block rather than to every paragraph in this block.
SetWidowControl	Specify whether a single line of this paragraph will be prevented from being displayed on a separate page from the remaining content at display time by moving the line onto the following page.

ApiParaPr

Name	Description
GetClassType	Get the type of this class.
SetBetweenBorder	Specify the border which will be displayed between each paragraph in a set of paragraphs which have the same set of paragraph border settings.
SetBottomBorder	Specify the border which will be displayed below a set of paragraphs which have the same paragraph border settings. The paragraphs of the same style going one by one are considered as a single block, so the border is added to the whole block rather than to every paragraph in this block.
SetBullet	Set the bullet or numbering to the current paragraph.
SetContextualSpacing	Specify that any space before or after this paragraph set using the ApiParaPr.SetSpacingBefore or ApiParaPr.SetSpacingAfter spacing element, should not be applied when the preceding and following paragraphs are of the same paragraph style, affecting the top and bottom spacing respectively.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetKeepLines	Specify that when rendering this document using a page view, all lines of this paragraph are maintained on a single page whenever possible.
SetKeepNext	Specify that when rendering this document using a paginated view, the contents of this paragraph are at least partly rendered on the same page as the following paragraph whenever possible.
SetLeftBorder	Specify the border which will be displayed at the left side of the page around the specified paragraph.
SetNumPr	Specify that the current paragraph references a numbering definition instance in the current document.
SetPageBreakBefore	Specify that when rendering this document using a paginated view, the contents of this paragraph are rendered at the beginning of a new page in the document.
SetRightBorder	Specify the border which will be displayed at the right side of the page around the specified paragraph.
SetShd	Specify the shading applied to the contents of the paragraph.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetStyle	The paragraph style base method. This method is not used by itself, as it only forms the basis for the ApiParagraph.SetStyle method which sets the selected or created style for the paragraph.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.
SetTopBorder	Specify the border which will be displayed above a set of paragraphs which have the same set of paragraph border settings. The paragraphs of the same style going one by one are considered as a single block, so the border is added to the whole block rather than to every paragraph in this block.
SetWidowControl	Specify whether a single line of this paragraph will be prevented from being displayed on a separate page from the remaining content at display time by moving the line onto the following page.

ApiPresetColor

Name	Description
GetClassType	Get the type of this class.

ApiRGBColor

Name	Description
GetClassType	Get the type of this class.

ApiRun

Name	Description
AddColumnBreak	Add a column break to the current run position and start the next element from a new column.
AddDrawing	Add an object (image, shape or chart) to the current text run.
AddLineBreak	Add a line break to the current run position and start the next element from a new line.
AddPageBreak	Add a page break and start the next element from a new page.
AddTabStop	Add a tab stop to the current run.
AddText	Add some text to this run.
ClearContent	Remove all content from the current run.
GetClassType	Get the type of this class.
GetTextPr	Get the text properties of the current run.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetColor	Set the text color for the current text run in the RGB format.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetHighlight	Specify a highlighting color in the RGB format which is applied as a background for the contents of the current run.
SetItalic	Set the italic property to the text character.
SetLanguage	Specify the languages which will be used to check spelling and grammar (if requested) when processing the contents of this text run.
SetPosition	Specify the amount by which text is raised or lowered for this run in relation to the default baseline of the surrounding non-positioned text.
SetShd	Specify the shading applied to the contents of the current text run.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetStyle	The text style base method. This method is not used by itself, as it only forms the basis for the ApiRun.SetStyle method which sets the selected or created style for the text.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiSchemeColor

Name	Description
GetClassType	Get the type of this class.

ApiSection

Name	Description
GetClassType	Get the type of this class.
GetFooter	Get the content for the specified footer type.
GetHeader	Get the content for the specified header type.
RemoveFooter	Remove the footer of the specified type from the current section. After removal the footer will be inherited from the previous section or, if this is the first section in the document, no footer of the specified type will be present.
RemoveHeader	Remove the header of the specified type from the current section. After removal the header will be inherited from the previous section or, if this is the first section in the document, no header of the specified type will be present.
SetEqualColumns	Specify that all text columns in the current section are of equal width.
SetFooterDistance	Specify the distance from the bottom edge of the page to the bottom edge of the footer.
SetHeaderDistance	Specify the distance from the top edge of the page to the top edge of the header.
SetNotEqualColumns	Specify that all columns in the current section are of a different width. Number of columns is equal to the length of the aWidth array. The length of the aSpaces array MUST BE equal to (aWidth.length - 1).
SetPageMargins	Specify the page margins for all pages in this section.
SetPageSize	Specify the properties (size and orientation) for all pages in the current section.
SetTitlePage	Specify whether the current section in this document have different header and footer for the section first page.
SetType	Specify the type of the current section. The section type defines how the contents of the current section are placed relative to the previous section. WordprocessingML supports five distinct types of section breaks: Next page section breaks (the default if type is not specified), which begin the new section on the following page. Odd page section breaks, which begin the new section on the next odd-numbered page. Even page section breaks, which begin the new section on the next even-numbered page. Continuous section breaks, which begin the new section on the following paragraph. This means that continuous section breaks might not specify certain page-level section properties, since they shall be inherited from the following section. These breaks, however, can specify other section properties, such as line numbering and footnote/endnote settings. Column section breaks, which begin the new section on the next column on the page.

ApiShape

Name	Description
GetClassType	Get the type of this class.
GetDocContent	Get the shape inner contents where a paragraph or text runs can be inserted.
SetPaddings	Set text paddings
SetVerticalTextAlign	Set the vertical alignment for the shape content where a paragraph or text runs can be inserted.

ApiStroke

Name	Description
GetClassType	Get the type of this class.

ApiStyle

Name	Description
GetClassType	Get the type of this class.
GetConditionalTableStyle	Get a set of formatting properties which will be conditionally applied to the parts of a table that match the requirement specified in the sType parameter.
GetName	Get the name of the current style.
GetParaPr	Get the paragraph properties of the current style.
GetTableCellPr	Get the table cell properties of the current style.
GetTablePr	Get the table properties of the current style.
GetTableRowPr	Get the table row properties of the current style.
GetTextPr	Get the text properties of the current style.
GetType	Get the type of the current style.
SetBasedOn	Specify the reference to the parent style which this style inherits from in the style hierarchy.
SetName	Set the name of the current style.

ApiTable

Name	Description
AddColumn	Add a new column to the current table.
AddRow	Add a new row to the current table.
GetClassType	Get the type of this class.
GetRow	Get the table row by its position in the table.
GetRowsCount	Get the number of rows in the current table.
MergeCells	Merge an array of cells. If the merge is done successfully it will return the resulting merged cell, otherwise the result will be "null". Please note: the number of cells in any row and the number of rows in the current table may be changed.
RemoveColumn	Remove the table column with a specified cell.
RemoveRow	Remove the table row with a specified cell.
SetCellSpacing	Specify the default table cell spacing (the spacing between adjacent cells and the edges of the table).
SetJc	Specify the alignment of the current table with respect to the text margins in the current section.
SetShd	Specify the shading which is applied to the extents of the current table.
SetStyle	Set the style for the current table.
SetStyleColBandSize	Specify the number of columns which will comprise each table column band for this table style.
SetStyleRowBandSize	Specify the number of rows which will comprise each table row band for this table style.
SetTableBorderBottom	Set the border which will be displayed at the bottom of the current table.
SetTableBorderInsideH	Specify the border which will be displayed on all horizontal table cell borders which are not on an outmost edge of the parent table (all horizontal borders which are not the topmost or bottommost border).
SetTableBorderInsideV	Specify the border which will be displayed on all vertical table cell borders which are not on an outmost edge of the parent table (all vertical borders which are not the leftmost or rightmost border).
SetTableBorderLeft	Set the border which will be displayed on the left of the current table.
SetTableBorderRight	Set the border which will be displayed on the right of the current table.
SetTableBorderTop	Set the border which will be displayed at the top of the current table.
SetTableCellMarginBottom	Specify the amount of space which will be left between the bottom extent of the cell contents and the border of all table cells within the parent table (or table row).
SetTableCellMarginLeft	Specify the amount of space which will be present between the left extent of the cell contents and the left border of all table cells within the parent table (or table row).
SetTableCellMarginRight	Specify the amount of space which will be present between the right extent of the cell contents and the right border of all table cells within the parent table (or table row).
SetTableCellMarginTop	Specify the amount of space which will be present between the top extent of the cell contents and the top border of all table cells within the parent table (or table row).
SetTableInd	Specify the indentation which will be added before the leading edge of the current table in the document (the left edge in a left-to-right table, and the right edge in a right-to-left table).
SetTableLayout	Specify the algorithm which will be used to lay out the contents of this table within the document.
SetTableLook	Specify the components of the conditional formatting of the referenced table style (if one exists) which will be applied to the set of table rows with the current table-level property exceptions. A table style can specify up to six different optional conditional formats, for example, different formatting for first column, which then can be applied or omitted from individual table rows in the parent table. The default setting is to apply the row and column banding formatting, but not the first row, last row, first column, or last column formatting.
SetWidth	Set the preferred width for this table. Tables are created with the ApiTable.SetWidth method properties set by default, which always override the ApiTablePr.SetWidth method properties. That is why there is no use to try and apply ApiTablePr.SetWidth , we recommend that you use the ApiTablePr.SetWidth method instead.

ApiTableCell

Name	Description
GetClassType	Get the type of this class.
GetContent	Get the cell content.
SetCellBorderBottom	Set the border which will be displayed at the bottom of the current table cell.
SetCellBorderLeft	Set the border which will be displayed to the left of the current table cell.
SetCellBorderRight	Set the border which will be displayed to the right of the current table cell.
SetCellBorderTop	Set the border which will be displayed at the top of the current table cell.
SetCellMarginBottom	Specify the amount of space which will be left between the bottom extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginLeft	Specify the amount of space which will be left between the left extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginRight	Specify the amount of space which will be left between the right extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginTop	Specify the amount of space which will be left between the upper extent of the cell contents and the border of a specific table cell within a table.
SetNoWrap	Specify how this table cell is laid out when the parent table is displayed in a document. This setting only affects the behavior of the cell when the ApiTablePr.SetTableLayout table layout for this table is set to use the `"autofit"` algorithm.
SetShd	Specify the shading applied to the contents of the table cell.
SetTextDirection	Specify the direction of the text flow for this table cell.
SetVerticalAlign	Specify the vertical alignment for text contents within the current table cell.
SetWidth	Set the preferred width for the current table cell.

ApiTableCellPr

Name	Description
GetClassType	Get the type of this class.
SetCellBorderBottom	Set the border which will be displayed at the bottom of the current table cell.
SetCellBorderLeft	Set the border which will be displayed to the left of the current table cell.
SetCellBorderRight	Set the border which will be displayed to the right of the current table cell.
SetCellBorderTop	Set the border which will be displayed at the top of the current table cell.
SetCellMarginBottom	Specify the amount of space which will be left between the bottom extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginLeft	Specify the amount of space which will be left between the left extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginRight	Specify the amount of space which will be left between the right extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginTop	Specify the amount of space which will be left between the upper extent of the cell contents and the border of a specific table cell within a table.
SetNoWrap	Specify how this table cell is laid out when the parent table is displayed in a document. This setting only affects the behavior of the cell when the ApiTablePr.SetTableLayout table layout for this table is set to use the `"autofit"` algorithm.
SetShd	Specify the shading applied to the contents of the table cell.
SetTextDirection	Specify the direction of the text flow for this table cell.
SetVerticalAlign	Specify the vertical alignment for text contents within the current table cell.
SetWidth	Set the preferred width for the current table cell.

ApiTablePr

Name	Description
GetClassType	Get the type of this class.
SetCellSpacing	Specify the default table cell spacing (the spacing between adjacent cells and the edges of the table).
SetJc	Specify the alignment of the current table with respect to the text margins in the current section.
SetShd	Specify the shading which is applied to the extents of the current table.
SetStyleColBandSize	Specify the number of columns which will comprise each table column band for this table style.
SetStyleRowBandSize	Specify the number of rows which will comprise each table row band for this table style.
SetTableBorderBottom	Set the border which will be displayed at the bottom of the current table.
SetTableBorderInsideH	Specify the border which will be displayed on all horizontal table cell borders which are not on an outmost edge of the parent table (all horizontal borders which are not the topmost or bottommost border).
SetTableBorderInsideV	Specify the border which will be displayed on all vertical table cell borders which are not on an outmost edge of the parent table (all vertical borders which are not the leftmost or rightmost border).
SetTableBorderLeft	Set the border which will be displayed on the left of the current table.
SetTableBorderRight	Set the border which will be displayed on the right of the current table.
SetTableBorderTop	Set the border which will be displayed at the top of the current table.
SetTableCellMarginBottom	Specify the amount of space which will be left between the bottom extent of the cell contents and the border of all table cells within the parent table (or table row).
SetTableCellMarginLeft	Specify the amount of space which will be present between the left extent of the cell contents and the left border of all table cells within the parent table (or table row).
SetTableCellMarginRight	Specify the amount of space which will be present between the right extent of the cell contents and the right border of all table cells within the parent table (or table row).
SetTableCellMarginTop	Specify the amount of space which will be present between the top extent of the cell contents and the top border of all table cells within the parent table (or table row).
SetTableInd	Specify the indentation which will be added before the leading edge of the current table in the document (the left edge in a left-to-right table, and the right edge in a right-to-left table).
SetTableLayout	Specify the algorithm which will be used to lay out the contents of this table within the document.
SetWidth	Set the preferred width for this table. Tables are created with the ApiTable.SetWidth method properties set by default, which always override the ApiTablePr.SetWidth method properties. That is why there is no use to try and apply ApiTablePr.SetWidth , we recommend that you use the ApiTablePr.SetWidth method instead.

ApiTableRow

Name	Description
GetCell	Get the cell by its position.
GetCellsCount	Get the number of cells in the current row.
GetClassType	Get the type of this class.
SetHeight	Set the height of the current table row within the current table.
SetTableHeader	Specify that the current table row will be repeated at the top of each new page wherever this table is displayed. This gives this table row the behavior of a 'header' row on each of these pages. This element can be applied to any number of rows at the top of the table structure in order to generate multi-row table headers.

ApiTableRowPr

Name	Description
GetClassType	Get the type of this class.
SetHeight	Set the height of the current table row within the current table.
SetTableHeader	Specify that the current table row will be repeated at the top of each new page wherever this table is displayed. This gives this table row the behavior of a 'header' row on each of these pages. This element can be applied to any number of rows at the top of the table structure in order to generate multi-row table headers.

ApiTableStylePr

Name	Description
GetClassType	Get the type of this class.
GetParaPr	Get the set of the paragraph properties which will be applied to all the paragraphs within a table which match the conditional formatting type.
GetTableCellPr	Get the set of the table cell properties which will be applied to all the cells within a table which match the conditional formatting type.
GetTablePr	Get the set of the table properties which will be applied to all the regions within a table which match the conditional formatting type.
GetTableRowPr	Get the set of the table row properties which will be applied to all the rows within a table which match the conditional formatting type.
GetTextPr	Get the set of the text run properties which will be applied to all the text runs within the table which match the conditional formatting type.
GetType	Get the type of the current table conditional style.

ApiTextPr

Name	Description
GetClassType	Get the type of this class.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetColor	Set the text color for the current text run in the RGB format.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetHighlight	Specify a highlighting color in the RGB format which is applied as a background for the contents of the current run.
SetItalic	Set the italic property to the text character.
SetLanguage	Specify the languages which will be used to check spelling and grammar (if requested) when processing the contents of this text run.
SetPosition	Specify the amount by which text is raised or lowered for this run in relation to the default baseline of the surrounding non-positioned text.
SetShd	Specify the shading applied to the contents of the current text run.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetStyle	The text style base method. This method is not used by itself, as it only forms the basis for the ApiRun.SetStyle method which sets the selected or created style for the text.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiUniColor

Name	Description
GetClassType	Get the type of the class based on this base class.

ApiUnsupported

Name	Description
GetClassType	Get the type of this class.

Spreadsheet API

Api

Name	Description
AddSheet	Create a sheet.
CreateBlipFill	Create a blip fill which allows to fill the object using a selected image as the object background.
CreateBullet	Create a bullet for a paragraph with the character or symbol specified with the sBullet parameter.
CreateColorByName	Create a color selecting it from one of the available color presets.
CreateColorFromRGB	Create an RGB color setting the appropriate values for the red, green and blue color components.
CreateGradientStop	Create a gradient stop used for different types of gradients.
CreateLinearGradientFill	Create a linear gradient fill which allows to fill the object using a selected linear gradient as the object background.
CreateNoFill	Create no fill and remove the fill from the element.
CreateNumbering	Create a bullet for a paragraph with the character or symbol specified with the sType parameter.
CreateParagraph	Create a new paragraph.
CreatePatternFill	Create a pattern fill which allows to fill the object using a selected pattern as the object background.
CreatePresetColor	Create a color selecting it from one of the available color presets.
CreateRGBColor	Create an RGB color setting the appropriate values for the red, green and blue color components.
CreateRun	Create a new smaller text block to be inserted to the current paragraph or table.
CreateSchemeColor	Create a complex color scheme selecting from one of the available schemes.
CreateSolidFill	Create a solid fill which allows to fill the object using a selected solid color as the object background.
CreateStroke	Create a stroke adding shadows to the element.
Format	Returns a class formatted according to instructions contained in a format expression
GetActiveSheet	Get the object that represents the active sheet.
GetLocale	Returns current locale id.
GetSheet	Returns an object that represents the sheet
GetSheets	Returns a Sheets collection that represents all the sheets in the active workbook.
GetThemesColors	Get the list of all available theme colors for the spreadsheet.
SetLocale	Set locale for document.
SetThemeColors	Set the theme colors to the current spreadsheet.

ApiBullet

Name	Description
GetClassType	Get the type of this class.

ApiChart

Name	Description
ApplyChartStyle	Apply set of visual settings for chart
GetClassType	Get the type of this class.
SetHorAxisLablesFontSize	Specifies font size for labels of horizontal axis
SetHorAxisMajorTickMark	Specifies major tick mark for horizontal axis
SetHorAxisMinorTickMark	Specifies minor tick mark for horizontal axis
SetHorAxisOrientation	Specifies the direction of the data displayed on the horizontal axis.
SetHorAxisTickLabelPosition	Set the possible values for the position of the chart tick labels in relation to the main horizontal label or the values of the chart data.
SetHorAxisTitle	Specify the chart horizontal axis title.
SetLegendFontSize	Specifies a legend position
SetLegendPos	Specify the chart legend position.
SetMajorHorizontalGridlines	Specifies major horizontal gridline's visual properties
SetMajorVerticalGridlines	Specifies major vertical gridline's visual properties
SetMinorHorizontalGridlines	Specifies minor vertical gridline's visual properties
SetMinorVerticalGridlines	Specifies minor vertical gridline's visual properties
SetShowDataLabels	Specifies which chart data labels are shown for the chart.
SetShowPointDataLabel	Spicifies a show options for data labels
SetTitle	Specify the chart title.
SetVerAxisOrientation	Specifies the direction of the data displayed on the vertical axis.
SetVerAxisTitle	Specify the chart vertical axis title.
SetVertAxisLablesFontSize	Specifies font size for labels of vertical axis
SetVertAxisMajorTickMark	Specifies major tick mark for vertical axis
SetVertAxisMinorTickMark	Specifies minor tick mark for vertical axis
SetVertAxisTickLabelPosition	Set the possible values for the position of the chart tick labels in relation to the main vertical label or the values of the chart data.

ApiColor

Name	Description
GetClassType	Get the type of this class.

ApiDocument

Name	Description
AddElement	Add paragraph or table using its position in the document.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.

ApiDocumentContent

Name	Description
AddElement	Add paragraph or table using its position in the document.
GetClassType	Get the type of the current class.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.

ApiDrawing

Name	Description
GetClassType	Get the type of the class based on this base class.
SetPosition	Change the position for the drawing object. Please note, that the horizontal nColOffset and vertical nRowOffset offsets are calculated within the limits of the specified nFromCol column and nFromRow row cell only. If this value exceeds the cell width or height, another vertical/horizontal position will be set.
SetSize	Set the size of the object (image, shape, chart) bounding box.

ApiFill

Name	Description
GetClassType	Get the type of this class.

ApiGradientStop

Name	Description
GetClassType	Get the type of this class.

ApiImage

Name	Description
GetClassType	Get the type of this class.

ApiParagraph

Name	Description
AddElement	Add an element to the current paragraph.
AddLineBreak	Add line break to the current position and start the next element from a new line.
AddTabStop	Add a tab stop to the current paragraph.
AddText	Add some text to the element.
GetClassType	Get the type of this class.
GetElement	Get the element of the paragraph using the position specified.
GetElementsCount	Get the number of elements in the current paragraph.
GetParaPr	Get paragraph properties.
RemoveAllElements	Remove all elements from the current paragraph. When all elements are removed from the paragraph, a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
RemoveElement	Remove the element using the position specified. If the element you remove is the last paragraph element (i.e. all elements are removed from the paragraph), a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
SetBullet	Set the bullet or numbering to the current paragraph.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.

ApiParaPr

Name	Description
GetClassType	Get the type of this class.
SetBullet	Set the bullet or numbering to the current paragraph.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.

ApiRange

Name	Description
AddComment	Adds a comment to the range.
ForEach	The ForEach() method executes a provided function once for each cell
GetAddress	Get cell adress
GetCol	Get the number of the column for the selected cell.
GetColumnWidth	Get columns width value
GetCount	Get count rows or columns
GetHidden	Get hidden value
GetRow	Get the number of the row for the selected cell.
GetRowHeight	Get rows height value
GetValue	Set cell value
Merge	Merge the selected cell range into a single cell or a cell row.
SetAlignHorizontal	Set the horizontal alignment of the text in the current cell range.
SetAlignVertical	Set the vertical alignment of the text in the current cell range.
SetBold	Set the bold property to the text characters in the current cell or cell range.
SetBorders	Set the border to the cell/cell range with the parameters specified.
SetColumnWidth	Set columns width value
SetFillColor	Set the background color for the current cell range with the previously created color object.
SetFontColor	Set the text color for the current cell range with the previously created color object.
SetFontName	Set the specified font family as the font name for the current cell range.
SetFontSize	Set the font size for the characters of the current cell range.
SetHidden	Set hidden value
SetItalic	Set the italic property to the text characters in the current cell or cell range.
SetNumberFormat	Specifies whether the number in the cell should be treated like number, currency, date, time, etc. or just like text.
SetOffset	Set cell offset
SetRowHeight	Set rows height value
SetStrikeout	Specify that the contents of the cell/cell range are displayed with a single horizontal line through the center of the line.
SetUnderline	Specify that the contents of this cell/cell range are displayed along with a line appearing directly below the character.
SetValue	Set the value for the current cell or a cell range.
SetWrap	Specifies whether the words in the cell must be wrapped to fit the cell size or not.
UnMerge	Split the selected merged cell range into single cells.

ApiRGBColor

Name	Description
GetClassType	Get the type of this class.

ApiRun

Name	Description
AddLineBreak	Add a line break to the current run position and start the next element from a new line.
AddTabStop	Add a tab stop to the current run.
AddText	Add some text to this run.
ClearContent	Remove all content from the current run.
GetTextPr	Get the text properties of the current run.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetItalic	Set the italic property to the text character.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiSchemeColor

Name	Description
GetClassType	Get the type of this class.

ApiShape

Name	Description
GetClassType	Get the type of this class.
GetDocContent	Get the shape inner contents where a paragraph or text runs can be inserted.
SetVerticalTextAlign	Set the vertical alignment for the shape content where a paragraph or text runs can be inserted.

ApiStroke

Name	Description
GetClassType	Get the type of this class.

ApiTextPr

Name	Description
GetClassType	Get the type of this class.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetItalic	Set the italic property to the text character.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiUniColor

Name	Description
GetClassType	Get the type of the class based on this base class.

ApiWorksheet

Name	Description
AddChart	Create a chart of the set type from the selected data range of the current sheet. Please note, that the horizontal nColOffset and vertical nRowOffset offsets are calculated within the limits of the specified nFromCol column and nFromRow row cell only. If this value exceeds the cell width or height, another vertical/horizontal position will be set.
AddImage	Adds the image to the current sheet with the parameters specified.
AddShape	Adds the shape to the current sheet with the parameters specified. Please note, that the horizontal `nColOffset` and vertical `nRowOffset` offsets are calculated within the limits of the specified `nFromCol` column and `nFromRow` row cell only. If this value exceeds the cell width or height, another vertical/horizontal position will be set.
FormatAsTable	Format the selected range of cells from the current sheet as a table (with the first row formatted as a header). As the first row is always formatted as a table header, you need to select at least two rows for the table to be formed correctly.
GetActiveCell	Returns an object that represents the active cell
GetBottomMargin	Get bottom margin sheet
GetCells	Returns a ApiRange that represents all the cells on the worksheet (not just the cells that are currently in use).
GetCols	Returns a ApiRange that represents all the cells on the columns range.
GetIndex	Get sheet index
GetLeftMargin	Get left margin sheet
GetName	Get sheet name
GetPageOrientation	Get page orientation
GetRange	Returns an object that represents the selected range of the current sheet. Can be a single cell - A1, or cells from a single row - A1:E1, or cells from a single column - A1:A10, or cells from several rows and columns - A1:E10.
GetRangeByNumber	Returns an object that represents the selected range of the current sheet using the row/column coordinates for the cell selection.
GetRightMargin	Get right margin sheet
GetRows	Returns a ApiRange that represents all the cells on the rows range.
GetSelection	Returns an object that represents the selection range
GetTopMargin	Get top margin sheet
GetUsedRange	Returns a ApiRange that represents the used range on the specified worksheet.
GetVisible	Returns Visible of sheet
ReplaceCurrentImage
SetBottomMargin	Set bottom margin sheet
SetColumnWidth	Set the width to the selected column of the current active sheet. The width is equal to the set number multiplied by 7 pixels - so if you set the width to 10 it will be equal to 70 pixels.
SetDisplayGridlines	Specifies whether the current sheet gridlines must be displayed or not.
SetDisplayHeadings	Specifies whether the current sheet row/column headers must be displayed or not.
SetLeftMargin	Set left margin sheet
SetName	Set a name to the current active sheet.
SetPageOrientation	Set page orientation
SetRightMargin	Set right margin sheet
SetRowHeight	Set Row height
SetTopMargin	Set top margin sheet
SetVisible	Set Visible of sheet

Presentation API

Api

Name	Description
CreateBlipFill	Create a blip fill which allows to fill the object using a selected image as the object background.
CreateBullet	Create a bullet for a paragraph with the character or symbol specified with the sBullet parameter.
CreateChart	Create a chart with the parameters specified.
CreateGradientStop	Create a gradient stop used for different types of gradients.
CreateGroup	Create a group of drawings.
CreateImage	Create an image with the parameters specified.
CreateLinearGradientFill	Create a linear gradient fill which allows to fill the object using a selected linear gradient as the object background.
CreateNoFill	Create no fill and remove the fill from the element.
CreateNumbering	Create a bullet for a paragraph with the character or symbol specified with the sType parameter.
CreateParagraph	Create a new paragraph.
CreatePatternFill	Create a pattern fill which allows to fill the object using a selected pattern as the object background.
CreatePresetColor	Create a color selecting it from one of the available color presets.
CreateRadialGradientFill	Create a radial gradient fill which allows to fill the object using a selected radial gradient as the object background.
CreateRGBColor	Create an RGB color setting the appropriate values for the red, green and blue color components.
CreateRun	Create a new smaller text block to be inserted to the current paragraph or table.
CreateSchemeColor	Create a complex color scheme selecting from one of the available schemes.
CreateShape	Create a shape with the parameters specified.
CreateSlide	Create a new slide.
CreateSolidFill	Create a solid fill which allows to fill the object using a selected solid color as the object background.
CreateStroke	Create a stroke adding shadows to the element.
CreateTable	Create table
GetPresentation	Get the main presentation.

ApiBullet

Name	Description
GetClassType	Get the type of this class.

ApiChart

Name	Description
GetClassType	Get the type of this class.
SetHorAxisLablesFontSize	Specifies font size for labels of horizontal axis
SetHorAxisMajorTickMark	Specifies major tick mark for horizontal axis
SetHorAxisMinorTickMark	Specifies minor tick mark for horizontal axis
SetHorAxisOrientation	Specifies a horizontal axis orientation
SetHorAxisTickLabelPosition	Spicifies tick labels position horizontal axis
SetHorAxisTitle	Specify the chart horizontal axis title.
SetLegendFontSize	Specifies a legend position
SetLegendPos	Specify the chart legend position.
SetMajorHorizontalGridlines	Specifies major horizontal gridline's visual properties
SetMajorVerticalGridlines	Specifies major vertical gridline's visual properties
SetMinorHorizontalGridlines	Specifies minor vertical gridline's visual properties
SetMinorVerticalGridlines	Specifies minor vertical gridline's visual properties
SetShowDataLabels	Specifies which chart data labels are shown for the chart.
SetShowPointDataLabel	Spicifies a show options for data labels
SetTitle	Specify the chart title.
SetVerAxisOrientation	Specifies a vertical axis orientation
SetVerAxisTitle	Specify the chart vertical axis title.
SetVertAxisLablesFontSize	Specifies font size for labels of vertical axis
SetVertAxisMajorTickMark	Specifies major tick mark for vertical axis
SetVertAxisMinorTickMark	Specifies minor tick mark for vertical axis
SetVertAxisTickLabelPosition	Spicifies tick labels position vertical axis

ApiDocument

Name	Description
AddElement	Add paragraph or table using its position in the document.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.

ApiDocumentContent

Name	Description
AddElement	Add paragraph or table using its position in the document.
GetClassType	Get the type of the current class.
GetElement	Get the element by its position in the document.
GetElementsCount	Get the number of elements in the current document.
Push	Push a paragraph or a table to actually add it to the document.
RemoveAllElements	Remove all elements from the current document or from the current document element. When all elements are removed, a new empty paragraph is automatically created. If you want to add content to this paragraph, use the ApiDocumentContent.GetElement method.
RemoveElement	Remove element using the position specified.

ApiDrawing

Name	Description
GetClassType	Get the type of the class based on this base class.
SetPosition	Set the position of the drawing on the slide.
SetSize	Set the size of the object (image, shape, chart) bounding box.

ApiFill

Name	Description
GetClassType	Get the type of this class.

ApiGradientStop

Name	Description
GetClassType	Get the type of this class.

ApiImage

Name	Description
GetClassType	Get the type of this class.

ApiParagraph

Name	Description
AddElement	Add an element to the current paragraph.
AddLineBreak	Add line break to the current position and start the next element from a new line.
AddTabStop	Add a tab stop to the current paragraph.
AddText	Add some text to the element.
GetClassType	Get the type of this class.
GetElement	Get the element of the paragraph using the position specified.
GetElementsCount	Get the number of elements in the current paragraph.
GetParaPr	Get paragraph properties.
RemoveAllElements	Remove all elements from the current paragraph. When all elements are removed from the paragraph, a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
RemoveElement	Remove the element using the position specified. If the element you remove is the last paragraph element (i.e. all elements are removed from the paragraph), a new empty run is automatically created. If you want to add content to this run, use the ApiParagraph.GetElement method.
SetBullet	Set the bullet or numbering to the current paragraph.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.

ApiParaPr

Name	Description
GetClassType	Get the type of this class.
SetBullet	Set the bullet or numbering to the current paragraph.
SetIndFirstLine	Set the paragraph first line indentation.
SetIndLeft	Set the paragraph left side indentation.
SetIndRight	Set the paragraph right side indentation.
SetJc	Set paragraph contents justification.
SetSpacingAfter	Set the spacing after the current paragraph. If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.
SetSpacingBefore	Set the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.
SetSpacingLine	Set the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
SetTabs	Specify a sequence of custom tab stops which will be used for any tab characters in the current paragraph. Warning: The lengths of aPos array and aVal array MUST BE equal to each other.

ApiPresentation

Name	Description
AddSlide	Append a new slide to the end of the presentation.
CreateNewHistoryPoint	Create new history point.
GetClassType	Get the type of this class.
GetCurrentSlide	Get the current slide.
GetCurSlideIndex	Get the index for the current slide.
GetSlideByIndex	Get the slide by its position in the presentation.
ReplaceCurrentImage	Replace current image
SetSizes	Set the size for the current presentation.

ApiPresetColor

Name	Description
GetClassType	Get the type of this class.

ApiRGBColor

Name	Description
GetClassType	Get the type of this class.

ApiRun

Name	Description
AddLineBreak	Add a line break to the current run position and start the next element from a new line.
AddTabStop	Add a tab stop to the current run.
AddText	Add some text to this run.
ClearContent	Remove all content from the current run.
GetClassType	Get the type of this class.
GetTextPr	Get the text properties of the current run.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetItalic	Set the italic property to the text character.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiSchemeColor

Name	Description
GetClassType	Get the type of this class.

ApiShape

Name	Description
GetClassType	Get the type of this class.
GetDocContent	Get the shape inner contents where a paragraph or text runs can be inserted.
SetVerticalTextAlign	Set the vertical alignment for the shape content where a paragraph or text runs can be inserted.

ApiSlide

Name	Description
AddObject	Add an object (image, shape or chart) to the current presentation slide.
GetClassType	Get the type of this class.
GetHeight	Get the slide height in English measure units.
GetWidth	Get the slide width in English measure units.
RemoveAllObjects	/** Remove all the objects from the current slide.
SetBackground	Set the background to the current presentation slide.

ApiStroke

Name	Description
GetClassType	Get the type of this class.

ApiTable

Name	Description
AddColumn	Add a new column to the end of the current table.
AddRow	Add a new row to the current table.
GetClassType	Returns type of object
GetRow	Returns row by index
MergeCells	Merge array of cells. If merge was done successfully it will return merged cell, otherwise "null". Warning: The number of cells in any row and the numbers of rows in the current table may be changed.
RemoveColumn	Remove the table column with a specified cell.
RemoveRow	Remove the table row with a specified cell.
SetShd	Specify the shading which shall be applied to the extents of the current table.
SetTableLook	Specify the components of the conditional formatting of the referenced table style (if one exists) which shall be applied to the set of table rows with the current table-level property exceptions. A table style can specify up to six different optional conditional formats [Example: Different formatting for first column. end example], which then can be applied or omitted from individual table rows in the parent table. The default setting is to apply the row and column banding formatting, but not the first row, last row, first column, or last column formatting.

ApiTableCell

Name	Description
GetClassType	Get the type of this class.
GetContent	Returns cell content
SetCellBorderBottom	Set the border which shall be displayed at the bottom of the current table cell.
SetCellBorderLeft	Set the border which shall be displayed at the left of the current table cell.
SetCellBorderRight	Set the border which shall be displayed at the right of the current table cell.
SetCellBorderTop	Set the border which shall be displayed at the top of the current table cell.
SetCellMarginBottom	Specifies the amount of space which shall be left between the bottom extent of the cell contents and the border of a specific table cell within a table.
SetCellMarginLeft	Specifies the amount of space which shall be left between the left extent of the current cell contents and the left edge border of a specific individual table cell within a table.
SetCellMarginRight	Specifies the amount of space which shall be left between the right extent of the current cell contents and the right edge border of a specific individual table cell within a table.
SetCellMarginTop	Specifies the amount of space which shall be left between the top extent of the current cell contents and the top edge border of a specific individual table cell within a table.
SetShd	Specify the shading which shall be applied to the extents of the current table cell.
SetTextDirection	Specify the direction of the text flow for this table cell.
SetVerticalAlign	Specify the vertical alignment for text within the current table cell.

ApiTableRow

Name	Description
GetCell	Get cell by position.
GetCellsCount	Get the number of cells in the current row.
GetClassType	Get the type of this class.
SetHeight	Set the height of the current table row within the current table.

ApiTextPr

Name	Description
GetClassType	Get the type of this class.
SetBold	Set the bold property to the text character.
SetCaps	Specify that any lowercase characters in this text run are formatted for display only as their capital letter character equivalents.
SetDoubleStrikeout	Specify that the contents of this run is displayed with two horizontal lines through each character displayed on the line.
SetFill	Set the text color for the current text run.
SetFontFamily	Set all 4 font slots with the specified font family.
SetFontSize	Set the font size for the characters of the current text run.
SetItalic	Set the italic property to the text character.
SetSmallCaps	Specify that all small letter characters in this text run are formatted for display only as their capital letter character equivalents in a font size two points smaller than the actual font size specified for this text.
SetSpacing	Set text spacing measured in twentieths of a point.
SetStrikeout	Specify that the contents of this run are displayed with a single horizontal line through the center of the line.
SetUnderline	Specify that the contents of this run are displayed along with a line appearing directly below the character (less than all the spacing above and below the characters on the line).
SetVertAlign	Specify the alignment which will be applied to the contents of this run in relation to the default appearance of the run text: "baseline" - the characters in the current text run will be aligned by the default text baseline. "subscript" - the characters in the current text run will be aligned below the default text baseline. "superscript" - the characters in the current text run will be aligned above the default text baseline.

ApiUniColor

Name	Description
GetClassType	Get the type of the class based on this base class.