Package index • pons

Word Sessions

Creating, retrieving, registering and closing a Word instance.

newWrd(): Create a New Word Session
getWrd(): Get Current Word Session
setWrd(): Set Current Word Session
closeWrd(): Close Word Session
withWrd(): Temporarily Use a Word Session

Writing to Word

Inserting R content into a document and the constants needed to address the Word object model.

toWrd(): Insert Content into Microsoft Word
wdConst: Word Constants for RDCOMClient

Word Bookmarks

Creating, listing, renaming and refilling bookmarks - the mechanism that makes a report updatable in place.

wrdAddBookmark(): Add a Word Bookmark
wrdBookmark(): Get a Word Bookmark
wrdDeleteBookmark(): Delete a Word Bookmark
wrdRenameBookmark(): Rename a Word Bookmark
wrdBookmarks(): List Word Bookmarks
wrdReplaceBookmarkText(): Replace Bookmark Text
wrdGoto(): Go to a Word Object

Excel Sessions

Creating, retrieving, registering and terminating an Excel instance.

newXl(): Create a New Excel Session
getXl(): Get Current Excel Session
setXl(): Set Current Excel Session
closeXl(): Close Excel Session
xxlView(): Run xlView() on selected text.
withXl(): Temporarily Use an Excel Session
xlKill(): Terminate all Microsoft Excel processes

Reading from Excel

Transferring the selected range - including disjoint multi-area selections - into a data frame, matrix, list or table.

xlGetRange(): Read the Raw Values of the Selected Excel Range(s)
xlParseRange(): Organize a Raw Excel Range into a data.frame, matrix, list or table
xlImport(): Interactively Import the Selected Excel Range into R
xlDataTransferDialog(): Excel Data Transfer Dialog

Writing to Excel

Opening R objects and fitted models in a spreadsheet for inspection.

xlView(): View Objects in Excel
xxlView(): Run xlView() on selected text.

Unit Conversion

Converting between the length units used by the Office object models.

cmToPts() ptsToCm(): Convert Between Centimeters and Points