+ 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 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Open | Read | Write | Format | Close | XLS | DOC | PPT | ||||||
'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. |