[RBG7-L] - Re: Office Automation

[A. Razzak Memon]

At 11:26 AM 2/9/2005, Greg Miller wrote:

Is there any way to accomplish this from within R:Base 7.1?

Greg,

Remember, nothing is impossible using the next generation R:BASE!

Here are a few options:

01. Prepare the required data in a TEMPORARY table and then use
    the modern GATEWAY EXPORT options (XLS or XLSW) to create
    dynamic spreadsheets on demand!

    For complete details: HELP EXPORT

    Make sure to take a look at the command line export options.

    Example 01 (MS Excel Spreadsheet):

    GATEWAY EXPORT XLS filename.XLS SELECT clause +
    OPTION COL_NAMES value +
    |SHOW_PROGRESS value +
    |MESSAGES value +
    |ACTION value

    Example 02 (MS Excel Workbook):

    GATEWAY EXPORT XLSW filename.XLS SELECT clause +
    OPTION COL_NAMES value +
    |TAB_NAME value +
    |STYLE value +
    |SHOW_PROGRESS value +
    |MESSAGES value +
    |ACTION value

02. Create a cooooool report and then use the OPTION XLS:

    Example 01:

    PRINT reportname WHERE whereclause ORDER BY orderbyclause +
    OPTION XLS +
    |SHOW_CANCEL_DIALOG value +
    |FILENAME filespec +
    |INCLUDE_RICH_TEXT value +
    |LINE_SPACE value +
    |CELL_ATTR value +
    |OPEN value

03. For more examples and templates:

    Start R:Docs | Main Menu | Command Line GATEWAY EXPORT
    Build Syntax for Command Line GATEWAY EXPORT

    OR

    Start R:Docs | Main Menu | PRINT Command
    Build Syntax for PRINT Command

    OR

    Start R:Docs | Main Menu | PRINT Command
    Templates

04. R:BASE 7.5 for Windows includes more ENHANCED options:
    http://www.rbase.com/rbg75

Very Best R:egards,

Razzak.