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
- Navigate to
BE_HOME
/studio/bin/
and open a command prompt. - 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.
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 " |