Can excell sheets be used as target in SAP DS?

dataservices job design
1

Can excell sheets be used as target in SAP DS?

hri (BOB member since 2012-04-16)

2

Yes. I suggest you use the search to find the full answer :wink:

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

Really? My understanding is excel cannot be made a target, only csv is possible. Not sure of this facility available in later versions 4.0 and 4.1

Arun

Arun.K :us: (BOB member since 2011-10-18)

4

Johannes are you talking about my answer? :wink:

ganeshxp :us: (BOB member since 2008-07-17)

5

Ssssssh :mrgreen:

Johannes Vink :netherlands: (BOB member since 2012-03-20)

6

Not possible in BODS 3.2 - I can check later if Excel targets can be used in BODS 4.1.

ErikR :new_zealand: (BOB member since 2007-01-10)

7

Well, as arunkumarcg said you can either do a .csv file or simply name the Flar File Structure as .xls and it will just create a Tab Delimited file. But then you will know you won’t be able apply any Excel Formatting on that file as it is actually a flat file :lol:

ganeshxp :us: (BOB member since 2008-07-17)