How can I use a Javelin flow to export two tables from Oracle to a single Excel spreasheet.

book

Article ID: 195016

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a need to export two Oracle tables to a NEW single excel Spreadsheet.
We can not seem to find a way to do this.

 

Cause

The bulk export will create a new excel file and create a new sheet the first time.
If you go to add additional information to an existing spreadsheet the sheet name must already exist.

Environment

Javelin 4.8X
Oracle 12.x 

Windows 2016 Server
Excel is required to modify an existing spreadsheet and add new sheet via vbscript.

Resolution

Find attached a workflow that will create a new excel spreadsheet, Add an additional sheet and then populate the second sheet with the additional table information.
For this to work Javelin must be installed on a windows machine.
Excel must be installed on this machine as the VBscript makes a system call to open the excel spreadsheet and add the additional sheet and update the name.

 

Additional Information

Javelin Version 4.8.133 will let you do this without the script.
  

Attachments

1594670860645__MultipleOracleTablesToXls.vwf get_app