cancel
Showing results for 
Search instead for 
Did you mean: 

Excel as Target in BODS 4.2

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

DayaJha
Active Contributor
0 Kudos

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...

Thanks,

Daya

Answers (3)

Answers (3)

oualid
Discoverer
0 Kudos

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

vnovozhilov
Employee
Employee
0 Kudos

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.

former_member211387
Contributor
0 Kudos

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