OfficeDoc properties

  + indicates the property is supported and relevant in both Demo and Professional versions (property name is green)
  P indicates the property is supported and relevant in the Professional version only
  x indicates the property is unsupported or irrelevant in this mode or document format
  
  All property names are case-insensitive; a few property values are case-sensitive, depending on Office.

Property Name	Action Type						Doc Type			Units	Possible values	Default value if unused	Description
Property Name	Open	Read	Write	Format	Print	Close	XLS	DOC	PPT	Units	Possible values	Default value if unused	Description
'Mode'	+	x	x	x	x	x	+	+	+	string	'read' / 'write' / 'append'	'read'	Indicates the read/write mode of the opened file
'Display'	+	x	x	x	x	x	+	+	+	boolean	true/false/1/0/'on'/'off'	false	Indicates whether to display or hide the opened file
'Sheet'	P	P	P	P	x	x	P	x	x	integer or string	positive integer index or sheet name	last saved	Indicates the required XLS worksheet
'Page'	P	P	P	P	x	x	x	P	P	integer	positive integer index	DOC: last saved; PPT: 1	Indicates the required DOC/PPT page number; for XLS use the 'Sheet' property
'Slide'	P	P	P	P	x	x	x	x	P	integer	positive integer index	1	Indicates the required PPT slide number (same as 'Page')
'Range'	P	P	P	P	x	x	P	P	P	XLS: string; DOC/PPT: 2 integers	XLS: 'A1' or 'A1:C4' format; DOC/PPT: [startChar#,endChar#]	none	Selected range: absolute (XLS) or relative to current position (DOC/PPT)
'Line'	P	P	P	P	x	x	x	P	x	integer	positive integer index	none	Selected line number relative to current position; 0 = start of document
'DivType'	x	P	x	x	x	x	x	P	x	string	'Characters' / 'Words' / 'Sentences' / 'Paragraphs' / 'Content'	'Content'	Defines textual divisions in the returned data
'Title'	x	x	+	x	x	x	+	+	+	string	anything	none	Sheet/page/slide title
'Data'	x	x	+	x	x	x	+	+	+	string/ numeric/ matrix/ cell-array/...	anything	none	Data values to be written
'Image' or 'Picture'	x	x	+	x	x	x	+	+	+	string or number	image filename or figure handle	none	Image to be inserted
'Meta'	x	x	P	x	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	Indicates that figure image should be pasted as meta-info, not screenshot. Note: this might fail if Adobe Acrobat is installed
'NewPage'	x	x	P	x	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	Indicates that a page-break should be inserted before the data. Also see 'PageBreakBefore' property below
'HeaderText'	x	x	P	P	x	x	P	P	x	string	anything	'' = empty	Indicates header text for the current worksheet (XLS) or the entire document (DOC). Unavailable in PPT
'FooterText'	x	x	P	P	x	x	P	P	P	string	anything	filename	Indicates footer text for the current worksheet (XLS), current slide (PPT) or the entire document (DOC). Use '' to hide
'Save'	x	x	P	P	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	If true, save the document after modification (false = much faster)
'PageOrientation'	x	x	P	P	x	x	P	P	P	string	'Landscape' / 'Portrait'	none (system dependent)	Page orientation
'BgPicture'	x	x	P	P	x	x	P	P	P	string	filename	''	Background image for the current worksheet/page/slide; Use '' to remove
'Bgcolor' or 'Background'	x	x	P	P	x	x	P	P	P	string or numeric vector	all valid Matlab colors (e.g., 'g','green' or [0,1,0])	'white'	Font background color. PPT: also see 'SlideColor' below
'FontName'	x	x	P	P	x	x	P	P	P	string	valid font name	none	Font name (e.g., 'Times New Roman' or 'Arial')
'FontSize'	x	x	P	P	x	x	P	P	P	number	positive number	none (normally 10 or 12)	Font size (e.g., 13)
'Underline'	x	x	P	P	x	x	P	P	P	integer	XLS: 0-2; DOC: 0-4; PPT: 0/1	0 = no line	Underline font (0=none, 1=single, 2=double, 3=thick, 4=words); Matlab7 also accepts strings: 'wdUnderlineWords' etc.
'Fgcolor' or 'Foreground'	x	x	+	+	x	x	+	+	+	string or numeric vector	all valid Matlab colors (e.g., 'g','green' or [0,1,0])	'black'	Font foreground color
'Bold'	x	x	+	+	x	x	+	+	+	boolean	true/false/1/0/'on'/'off'	false	Bold font
'Italic'	x	x	P	P	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	Italic font
'Subscript'	x	x	P	P	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	Subscript font
'Superscript'	x	x	P	P	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	Superscript font
'Shadow'	x	x	P	P	x	x	P	P	P	boolean	true/false/1/0/'on'/'off'	false	Shadowed font
'Strikethrough'	x	x	P	P	x	x	P	P	x	boolean	true/false/1/0/'on'/'off'	false	Strikethrough font. Unavailable in PPT
'Emboss'	x	x	P	P	x	x	x	P	P	boolean	true/false/1/0/'on'/'off'	false	Embossed font. Unavailable in XLS
'WrapText'	x	x	P	P	x	x	P	x	P	boolean	true/false/1/0/'on'/'off'	false	Wrap text within cell(s) / box. Unavailable in DOC
'TextOrientation'	x	x	P	P	x	x	P	x	P	degrees	XLS: -90:90; PPT: 0 or -90	0 = Eastward	Indicates text direction: -90=downward, +90=upward. PPT only accepts 0 or -90; XLS accepts full range; Unavailable in DOC
'NumberFormat'	x	x	P	P	x	x	P	x	x	string	any valid format specifier	none	Cell format specifier (e.g., '#,##0_);[Red](#,##0)')
'RowHeight'	x	x	P	P	x	x	P	x	x	number	positive number	system dependent	XLS row height (e.g., 12.75)
'ColWidth'	x	x	P	P	x	x	P	x	x	number	positive number	system dependent	XLS column width (e.g., 8.5)
'RowAutoFit'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Auto-fit selected XLS row(s) according to the contained value(s)
'ColAutoFit'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Auto-fit selected XLS column(s) according to the contained value(s)
'RowHidden'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Hides or unhides the selected XLS row(s)
'ColHidden'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Hides or unhides the selected XLS column(s)
'SheetHidden'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Hides or unhides the selected XLS worksheet
'SheetName'	x	x	P	P	x	x	P	x	x	string	almost anything up to 32 chars	none	XLS worksheet (tab) name
'SheetProtected'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Protects or unprotects the selected XLS worksheet
'SheetScaling'	x	x	P	P	x	x	P	x	x	string	'#%' or '#x#'	'100%'	Set XLS worksheet print scaling to the specified % or W-by-H pages. Examples: '75%' or '3x2' Note: 'WxH' format may fail on Matlab 6 or old Excel versions
'PrintArea'	x	x	P	P	x	x	P	x	x	string	'A1' or 'A1:C4' format	'' (=entire sheet)	Set the XLS worksheet print-area
'AutoImageResize'	x	x	P	P	x	x	P	x	x	boolean	true/false/1/0/'on'/'off'	true	Automatically resize the provided image to fit the printed XLS page
'TabColor'	x	x	P	P	x	x	P	x	x	string or numeric vector	all valid Matlab colors (e.g., 'g','green' or [0,1,0])	'white'	XLS worksheet tab color; ''=white
'Valign'	x	x	P	P	x	x	P	x	x	string	'top' / 'center' / 'bottom' / 'justify'	'bottom'	Vertical cell alignment
'Halign'	x	x	P	P	x	x	P	P	x	string	'right' / 'center' / 'left' / 'justify' XLS: also 'fill' / 'general'	'general'	Horizontal cell/paragraph alignment. Unavailable in PPT
'EdgeLeft'	x	x	P	P	x	x	P	P	x	number or cell array	weight (0/0.5/1/1.5/2/3/4) or {weight,color}	none	Left border. Set weight to [] or 0 to remove this border. Note: this property fails in Matlab 6 (ok in 7). Unavailable in PPT
'EdgeRight'	x	x	P	P	x	x	P	P	x	number or cell array	weight (0/0.5/1/1.5/2/3/4) or {weight,color}	none	Left border. Set weight to [] or 0 to remove this border. Note: this property fails in Matlab 6 (ok in 7). Unavailable in PPT
'EdgeTop'	x	x	P	P	x	x	P	P	x	number or cell array	weight (0/0.5/1/1.5/2/3/4) or {weight,color}	none	Left border. Set weight to [] or 0 to remove this border. Note: this property fails in Matlab 6 (ok in 7). Unavailable in PPT
'EdgeBottom'	x	x	P	P	x	x	P	P	x	number or cell array	weight (0/0.5/1/1.5/2/3/4) or {weight,color}	none	Left border. Set weight to [] or 0 to remove this border. Note: this property fails in Matlab 6 (ok in 7). Unavailable in PPT
'AllCaps'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	All-caps font: lowercase 'a' looks exactly like uppercase 'A'
'SmallCaps'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	Small-caps font: lowercase 'a' looks like a small uppercase 'A'
'WidowControl'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	DOC paragraph widow/orphan control
'KeepWithNext'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	DOC paragraph "Keep-with-next" (keep next paragraph on same page)
'KeepTogether'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	DOC paragraph "Keep-Together" (keep this paragraph on same page)
'PageBreakBefore'	x	x	P	P	x	x	x	P	x	boolean	true/false/1/0/'on'/'off'	false	DOC paragraph "Page-Break-Before" (start paragraph on top of new page). Also see 'NewPage' property above
'LineSpacing'	x	x	P	P	x	x	x	P	P	number	positive number	1	Spacing between lines: 1/1.5/2 indicate single-double spacing; any other value is treated as an exact number of [points]. Matlab7 also accepts strings: 'wdLineSpaceSingle' etc. Unavailable in XLS
'SpaceBefore'	x	x	P	P	x	x	x	P	P	number	positive number	0.2	Spacing before selected line(s) in [points]. Unavailable in XLS
'SpaceAfter'	x	x	P	P	x	x	x	P	P	number	positive number	0	Spacing after selected line(s) in [points]. Unavailable in XLS
'Bullet'	x	x	P	P	x	x	x	P	P	string	'None' / 'Numbered' / 'Unnumbered' or 'Bullet'	'None'	Bullet/numberring type (unnumbered = bullet). Unavailable in XLS
'LeftIndent'	x	x	P	P	x	x	x	P	P	number	positive number	0	Left paragraph indent in [points]. Unavailable in XLS
'RightIndent'	x	x	P	P	x	x	x	P	P	number	positive number	0	Right paragraph indent in [points]. Unavailable in XLS
'IndentLevel'	x	x	P	P	x	x	x	x	P	integer	positive integer	1	PPT indentation level. Default = leftmost indent = 1
'SlideHidden'	x	x	P	P	x	x	x	x	P	boolean	true/false/1/0/'on'/'off'	false	Hides or unhides the selected PPT slide
'SlideColor'	x	x	P	P	x	x	x	x	P	string or numeric vector	all valid Matlab colors (e.g., 'g','green' or [0,1,0])	'white'	PPT slide background color; ''=white. Note: 'BgColor' sets the text frame color, not the slide color
'PrintRange'	x	x	x	x	P	x	P	P	P	string	'All' / 'Selection' / 'CurrentPage' or page range	'All'	DOC: page ranges are specified as strings, e.g. '2-6, 13-' XLS, PPT: only simple page ranges are supported, e.g. '2-6' PPT: The 'Selection' option is not supported. Instead, use a page range
'Copies'	x	x	x	x	P	x	P	P	P	number	any positive integer	1	Number of printed copies
'PrinterName'	x	x	x	x	P	x	P	P	P	string	any installed printer name	(default Windows printer)	DOC, XLS: printer name format: 'XYZ Printer on Ne01:' PPT: printer name format: 'XYZ Printer'
'PagesPerSheet'	x	x	x	x	P	x	x	P	P	number	DOC: 1 / 2 / 3 / 4 / 6 / 8 / 9 / 12 / 16 PPT: 1 / 2 / 3 / 4 / 6 / 9 XLS: not supported	1	Number of document pages in each printed sheet (handouts)
'Release'	x	x	x	x	x	+	+	+	+	boolean	true/false/1/0/'on'/'off'	true = release	Indicates whether or not to release the COM server from memory after closing the file (recommended unless the same server will be reused shortly).
'DelStd'	x	x	x	x	x	P	P	x	x	boolean	true/false/1/0/'on'/'off'	false	Deletes the standard XLS worksheets. Note that XLS files must have at least one sheet, so if the file has only the standard sheets, then the last one will not be deleted.

Back to OfficeDoc product page