Excel as Target in BODS 4.2
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?.
Daya Jha replied
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
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).
An approach to build Target file in Excel format in SAP BODS using XSL