Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Exporting Decision Tables to the Microsoft Excel Files at the Command Line

You can export a single decision table or all the decision tables from a project folder to the respective Microsoft Excel files using the command line.

Procedure
1. Navigate to BE_HOME/studio/bin/ and open a command prompt.
2. Execute a command with the following format (all in one line) at a command prompt:

       studio-tools -dt exportToExcel [-h] -studioProjPath studioProjectDir -dtPath decisionTablePath -excelPath exportedExcelFilePath [-useColumnAlias exportColumnAlias [-legacy] -e earPath

   For example:

       studio-tools -dt exportToExcel -studioProjPath D:/be/5.2/examples/standard/WebStudio/CreditCardApplication -dtPath /Virtual_RF -excelPath C:/temp/exportedDTs -e D:/be/5.2/examples/standard/WebStudio/CreditCardApplication.ear

   TIBCO BusinessEvents Studio Tools Options for Exporting Decision Tables to Excel Files
   Option | Description
   --- | ---
   `-dt exportToExcel` | Within the `dt` category of operations, specifies the `exportToExcel` operation for exporting single or all decision tables to Microsoft Excel files.
   `-h` | Optional. Displays help.
   `-studioProjPath` | The file path to the TIBCO BusinessEvents Studio project, from which the decision table is exported.
   `-dtPath` | The project relative path of the decision table to be exported. The path could be for a decision table file or the folder containing decision tables to be exported.
   `-excelPath` | The file path where the exported Excel files are generated.
   `-useColumnAlias` | Optional. Whether to use column alias in the exported Excel files.
   `-legacy` | (Optional) Use this option to export decision table in the `.xls` format instead of the default `.xlsx` format.
   `-e` | The file path of the project EAR file.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.