Excel.Interfaces.TextFrameUpdateData interface
An interface for updating data on the TextFrame
object, for use in textFrame.set({ ... })
.
Properties
auto |
The automatic sizing settings for the text frame. A text frame can be set to automatically fit the text to the text frame, to automatically fit the text frame to the text, or not perform any automatic sizing. |
bottom |
Represents the bottom margin, in points, of the text frame. |
horizontal |
Represents the horizontal alignment of the text frame. See |
horizontal |
Represents the horizontal overflow behavior of the text frame. See |
left |
Represents the left margin, in points, of the text frame. |
orientation | Represents the angle to which the text is oriented for the text frame. See |
reading |
Represents the reading order of the text frame, either left-to-right or right-to-left. See |
right |
Represents the right margin, in points, of the text frame. |
top |
Represents the top margin, in points, of the text frame. |
vertical |
Represents the vertical alignment of the text frame. See |
vertical |
Represents the vertical overflow behavior of the text frame. See |
Property Details
autoSizeSetting
The automatic sizing settings for the text frame. A text frame can be set to automatically fit the text to the text frame, to automatically fit the text frame to the text, or not perform any automatic sizing.
autoSizeSetting?: Excel.ShapeAutoSize | "AutoSizeNone" | "AutoSizeTextToFitShape" | "AutoSizeShapeToFitText" | "AutoSizeMixed";
Property Value
Excel.ShapeAutoSize | "AutoSizeNone" | "AutoSizeTextToFitShape" | "AutoSizeShapeToFitText" | "AutoSizeMixed"
Remarks
bottomMargin
Represents the bottom margin, in points, of the text frame.
bottomMargin?: number;
Property Value
number
Remarks
horizontalAlignment
Represents the horizontal alignment of the text frame. See Excel.ShapeTextHorizontalAlignment
for details.
horizontalAlignment?: Excel.ShapeTextHorizontalAlignment | "Left" | "Center" | "Right" | "Justify" | "JustifyLow" | "Distributed" | "ThaiDistributed";
Property Value
Excel.ShapeTextHorizontalAlignment | "Left" | "Center" | "Right" | "Justify" | "JustifyLow" | "Distributed" | "ThaiDistributed"
Remarks
horizontalOverflow
Represents the horizontal overflow behavior of the text frame. See Excel.ShapeTextHorizontalOverflow
for details.
horizontalOverflow?: Excel.ShapeTextHorizontalOverflow | "Overflow" | "Clip";
Property Value
Excel.ShapeTextHorizontalOverflow | "Overflow" | "Clip"
Remarks
leftMargin
Represents the left margin, in points, of the text frame.
leftMargin?: number;
Property Value
number
Remarks
orientation
Represents the angle to which the text is oriented for the text frame. See Excel.ShapeTextOrientation
for details.
orientation?: Excel.ShapeTextOrientation | "Horizontal" | "Vertical" | "Vertical270" | "WordArtVertical" | "EastAsianVertical" | "MongolianVertical" | "WordArtVerticalRTL";
Property Value
Excel.ShapeTextOrientation | "Horizontal" | "Vertical" | "Vertical270" | "WordArtVertical" | "EastAsianVertical" | "MongolianVertical" | "WordArtVerticalRTL"
Remarks
readingOrder
Represents the reading order of the text frame, either left-to-right or right-to-left. See Excel.ShapeTextReadingOrder
for details.
readingOrder?: Excel.ShapeTextReadingOrder | "LeftToRight" | "RightToLeft";
Property Value
Excel.ShapeTextReadingOrder | "LeftToRight" | "RightToLeft"
Remarks
rightMargin
Represents the right margin, in points, of the text frame.
rightMargin?: number;
Property Value
number
Remarks
topMargin
Represents the top margin, in points, of the text frame.
topMargin?: number;
Property Value
number
Remarks
verticalAlignment
Represents the vertical alignment of the text frame. See Excel.ShapeTextVerticalAlignment
for details.
verticalAlignment?: Excel.ShapeTextVerticalAlignment | "Top" | "Middle" | "Bottom" | "Justified" | "Distributed";
Property Value
Excel.ShapeTextVerticalAlignment | "Top" | "Middle" | "Bottom" | "Justified" | "Distributed"
Remarks
verticalOverflow
Represents the vertical overflow behavior of the text frame. See Excel.ShapeTextVerticalOverflow
for details.
verticalOverflow?: Excel.ShapeTextVerticalOverflow | "Overflow" | "Ellipsis" | "Clip";
Property Value
Excel.ShapeTextVerticalOverflow | "Overflow" | "Ellipsis" | "Clip"
Remarks
Office Add-ins