Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Converting a CSV File to a Microsoft Excel File with the Studio Tools Utility

If you have a CSV (comma-separated values) file of a decision table, you can open and save it in Excel, so that it can be used for import to TIBCO BusinessEvents Decision Manager.

Note: The Studio Tools utility runs only on Microsoft Windows and Linux platforms as it has dependencies on Eclipse.

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

       studio-tools -dt convertCSV2Excel [-h] -csvPath CSVFilePath -excelPath excelFilePath -s columnSeparator

   For example:

       studio-tools -dt convertCSV2Excel -csvPath D:\myfolder\BankUser.csv -excelPath D:\myotherfolder\BankUser.xlsx -s ;

Result

Importing the Microsoft Excel File to a Decision Table at the Command Line provides detailed information about the options.

TIBCO BusinessEvents Studio Tools Options for Importing Excel Files into TIBCO BusinessEvents Decision Manager
Option | Description
--- | ---
-dt convertCSV2Excel | Within the `dt` category of operations, specifies the `convertCSV2Excel` operation for converting comma separated value (CSV) files to Excel format files.
-h | Optional. Displays help.
-CSVPath | File path to the CSV file to be converted.
-excelPath | File path to the Excel (`.xls` or `.xlsx`) file to be created.
-s | Optional. The column separator that is used in the CSV file. Default is "`,`" (comma).

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.