Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel as Target in BODS 4.2

Hi,

My Client is asking me to generate O/P file as Excel file.

Could you please tell me is it possible?.

We have just an option to generate CSV file format?.

Regards.

Former Member
replied

Hi Chaitanya,

We cannot use excel as a target it was clearly written in Designer Guide but there is work around to achieve, Please refre the below links:

Designer -> Help -> Technical Manual - search for Excel. You will find:

Excel workbook format

Description

An Excel workbook format describes the structure defined in an Excel workbook (denoted with a .xls extension). You store format templates for Excel data ranges in the object library. You use the template to define the format of a particular source in a data flow.
SAP BusinessObjects Data Services accesses Excel workbooks as sources only (not as targets).

Work Around:

Excel target in BODS 4.1

An approach to build Target file in Excel format in SAP BODS using XSL

http://scn.sap.com/community/data-services/blog/2014/09/16/an-approach-to-build-target-file-in-excel-format-in-sap-bods-using-xsl

Thanks,

Daya

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question