Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

1
Replies
426
Views
 Srilipta Nanda (SriliptaN) TATA Consultancy Services Ltd
TATA Consultancy Services Ltd
IN
SriliptaN Member since 2017 4 posts
TATA Consultancy Services Ltd
Posted: October 4, 2017
Last activity: October 4, 2017
Posted: 4 Oct 2017 4:57 EDT
Last activity: 4 Oct 2017 7:30 EDT
Closed

How to insert data into an excel sheet from database

Report

Hi,

I want to know how to insert data into an excel sheet from DB2 database..

Regards

Srilipta Nanda

Data Integration
Posted: 5 years ago
Posted: 4 Oct 2017 5:14 EDT
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
Pegasystems Inc.
GB
Report

Probably high-level you might want to do this:

1. Map your DB2 Table into PRPC as an 'External Table'.

2. Create a PRPC 'Report' based on that data.

3. Use the 'Export To Excel' facility (which is built into the Report Viewer) to generate your Excel file.

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice