Oracle® Fusion Middleware Desktop Integration Developer's Guide for Oracle Application Development Framework 11g Release 1 (11.1.1) Part Number E10139-01 |
|
|
View PDF |
This appendix describes how to use the workbook conversion utility and the workbook administration tool. You can use these tools to prepare and manage workbooks that you integrate with a Fusion web application.
This appendix includes the following sections:
Use the conversion utility to convert an Excel workbook so that you can start configuring the workbook with Oracle ADF functionality. Section 4.4, "Preparing Your Workbook" describes how you run the conversion utility.
The Oracle ADF Desktop Integration module stores the conversion utility (convert-adfdi-excel-solution.exe
) in the following directory:
ADFDI_CLIENT\adfdi\bin\excel\convert
where ADFDI_CLIENT
refers to the directory in which you set up the Oracle ADF Desktop Integration module as described in Section 3.7, "Using the Oracle ADF Desktop Integration Module on a Machine with Multiple Instances of JDeveloper".
Table D-1 describes the arguments that the conversion utility supports.
Table D-1 Workbook Conversion Utility Command-line Arguments
Use this argument... | To... |
---|---|
|
Attach properties to an Excel workbook so that you can configure it to use Oracle ADF functionality. Example usage:
|
|
Remove design time, test mode, and runtime Oracle ADF functionality from an integrated Excel workbook. Use this argument if you want to send an integrated Excel workbook to a user who does not have the Oracle ADF Desktop Integration client framework installed. This allows the user to open the integrated Excel workbook without receiving an error message. Example usage:
|
|
Use this argument to change the mode of an integrated Excel workbook from its current mode to design mode, test mode, or runtime mode. Use the
The following example converts a workbook to design mode:
Use the |
|
Modify the value of a workbook's Example usage:
The recommended method of changing a workbook's |
|
Use this argument to determine if a workbook has been converted for integration with Oracle ADF and, if so, identify the solution ID and customization version. Example usage:
|
|
Remove the value of the Example usage:
|
|
Displays help information about the command-line arguments that the workbook conversion utility supports. |
Use the workbook administration tool to set values for a number of workbook properties, such as WebAppRoot
, after you publish the finalized integrated Excel workbook. Use this tool if, for example, the URL of your Fusion web application changes after you publish the integrated Excel workbook.
You can also use it when you want to change workbook settings but cannot or do not want to set values for the HTTP filter as described in Section E.2, "Configuring HTTP Filter Parameters".
The workbook administration tool is a Java-based program that can be executed on operating systems that support the version of Java used by Oracle ADF. It also requires access to the adf-desktop-integration-admin-tool.jar
file which is located in the following directory:
ADFDI_CLIENT\adfdi\lib
where ADFDI_CLIENT
is the folder in which you set up the Oracle ADF Desktop Integration module as described in Section 3.7, "Using the Oracle ADF Desktop Integration Module on a Machine with Multiple Instances of JDeveloper".
The other requirements for components or utilities in the Oracle ADF Desktop Integration module, as outlined in Chapter 3, "Setting Up Your Development Environment", do not apply to the workbook administration tool.
To change workbook settings using the workbook administration tool:
Open a command window and execute the following command:
java -cp adf-desktop-integration-admin-tool.jar oracle.adf.desktopintegration.admintool.WorkbookAdminTool <arg(s)>
where <arg(s)>
is one or more of the required or optional arguments that are described in Table D-2.
Table D-2 Command-line Options for the Workbook Administration Tool
Provide a value for this argument... | To... | Is a value for this argument required? |
---|---|---|
|
Specify the directory path to the workbook to update. |
Yes |
|
Set the value for this property to the fully qualified URL for the web application that you want to integrate your desktop application with. |
No |
|
Change the workbook mode to one of the following:
For more information about workbook modes, see Section 5.1, "Introduction to the Development Tools". |
No |
|
Specify the directory path and file name for the output file. |
Yes |
|
Specify this argument if you do not want to generate verbose output. |
No |
|
Print help information. |
No |
The following command creates a copy of the workbook (text.xlsx
) in runtime mode (RT
) for a Fusion web application (http://hostname:8988/FODADFBC
) and writes it to a directory with a new file name (myresult.xlsx
):
java -cp adf-desktop-integration-admin-tool.jar oracle.adf.desktopintegration.admintool.WorkbookAdminTool -workbook test.xlsx -mode RT -root http://hostname:8988/FODADFBC -out myresult.xlsx