Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 14, 2015 at 05:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 10:11 AM

    Hi,

    One limitation with excel een the later versions like 2007 and 2010 is that the ".xlsx" file has a row limitation. I think it is just about a million records for a give worksheet in case of Excel 2010. So if you have a substantially large files, it is imposible to have all the data loaded into the file and opened in Excel. The csv and other .txt files are standard data files that can contain any number of records.

    Excel as target file structure is not available till date. We only have work arounds. I would suggest you to prepare the output as a delimited file with a unique column delimiter and load read it in excel. One option I usually follow is to set the column delimiter as "|" and target file name as .txt. Then open the file in Excel. This will work for cases where the number of records in the output file is less than a million.

    kind regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 11:08 AM

    SAP Data Services is unable to create Excel files due to the fact that Excel files are in proprietary format. I came across workarounds in the past but never tried myself. You may wish to try the approach as described above.

    hank you,

    Viacheslav.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 29 at 10:08 PM

    Someone already tried the approach described above (xsl method)?

    Add comment
    10|10000 characters needed characters exceeded