---

Please note: This page has been retired.

We no longer sell Jumar Solutions products, please visit their web site instead:

• http://www.rainier.co.uk/products.htm

To view alternative products, please see the following:

Other information on this page is shown for historical reference only and may have changed considerably since.

---

What's New in V5.0

This version offers Word 2003 compliance. Earlier versions do not support Word 2003. In addition there are many new functions, including extensive support for Word tables.

There is a new DLL, a new version of the sample application and updated documentation (DOC and HLP).

The new functions offered include the following:

• wdcApplyTableAutoFormat
• wdcApplyTableStyle
• wdcCloseAllDocuments
• wdcConvertTextToTable
• wdcGetActiveDocumentName
• wdcGetBookmarkNames
• wdcGetDocumentWindowCount
• wdcGetDocumentWindowName
• wdcInsertBookmark
• wdcInsertContentAtBookmark
• wdcInsertTable
• wdcRunMacroWithParameters
• wdcSelectTable
• wdcSelectTableCell
• wdcSelectTableColumn
• wdcSelectTableRow
• wdcSetTableColumnWidth
• wdcSetTableRowHeight

WordController

Running on top of the functionality exposed by Word, WordController detects which version is present at runtime and executes code appropriate to that version. It becomes simple to write one set of code, which can be deployed to users without worrying what version of Word they have.

WordController aggregates complex Word functionality into high-level new functions that allow Developers to manipulate Word without requiring them to understand the Word object model.

Developers who wish to integrate with Word face a major problem with regard to the different behaviour of different Word versions. Applications that are written for one version of Word do not necessarily work when run on a workstation that has a different version installed.

With the help of WordController Plus a client application can:

• Determine if Word is running and return the Word window handle
• Launch Word in any state (hidden, normal, minimized, maximized)
• Open Word documents (optionally with password and/or read only) and create new documents (optionally from templates)
• Build form letters based on Word templates
• Perform Word MailMerges to produce merge documents or labels based on templates
• Create Word documents from data in text files
• Move within and between documents, insert text, files and graphics
• Apply styles and formatting
• Create Word tables from data contained in text files. If desired the tables can be embedded in Word template documents.
• Replace all occurrences of a string in an open document with another string.
• Retrieve and set document properties
• Protect and unprotect sections or complete documents
• Print, save, convert and close documents
• Make use of Word's spell checking functionality
• Run Word macros
• Close Word

Excel Controller

ExcelController Plus is an is an ActiveX component which allows Developers to quickly and easily integrate their applications with multiple versions of Microsoft Excel.

Developers who wish to integrate their applications with Excel on the user machine face a major problem with regard to the different behaviour of different Excel versions. Applications which are written for one version of Excel do not necessarily work when run on a workstation which has a different version installed.

Developers do not want to have to specify that their Users have a particular version, nor do they want to revisit their applications when the next version of Excel is released. ExcelController Plus addresses these issues by adding a layer on top of the functionality exposed by Excel, detecting what version is present at runtime and executing code that will work with that version. It is now possible to write one set of code which can be deployed to users without worrying what version of Excel they have. And when the next version of Excel is released let us worry about testing its behaviour and making any changes necessary to ensure that the ExcelController functions behave in a manner as consistent as possible with the earlier versions.

With the help of ExcelController Plus a client application can

• determine if Excel is running and return the Excel window handle
• launch Excel in any state (hidden, normal, minimized, maximized)
• open and close Excel workbooks (optionally with passwords and/or read only)
• navigate workbooks, activating workbooks, worksheets and ranges
• create new workbooks, optionally based on pre-defined templates
• import data into Excel from text files. If desired the data can be embedded in Excel template workbooks.
• format Excel tables and defined ranges to create a sophisticated, custom look
• insert values, pictures and formulae into cells. Retrieve data from cells.
• copy data, formulae and/or formatting from one part of a workbook to another.
• insert, delete and rename worksheets
• create a variety of different charts
• create pivot tables
• run Excel macros
• search and replace
• print ranges, worksheets and workbooks
• protect and unprotect cells, worksheets and workbooks
• freeze and unfreeze the Excel window
• close Excel