Skip to Content
avatar image
Former Member

Sap design studio 1.5 export to excel or csv

Hi,

I have 2 questions about exporting crosstab to xls or csv. im using design stuio 1.5 sp 2

For xls: sometimes with null values i can´t make excel operations like sum because it gives me value error. or sometimes null values come with @. Is there a way to solve this?

For csv: I can use excel without problem for numbers, but special characters such as Á Ó etc, are not shown correctly, i guess is some configuration of UTF-8 or somenthing like that but how can i change it?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 31, 2017 at 12:59 PM

    #1 on nulls - see Bogdan's reply here: https://archive.sap.com/discussions/thread/3824957

    #2 - I haven't seen this, which version of Excel are you running? Which language?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 03:54 PM

    thanks tammy,

    for the first point i will try it in office 2013 as recommended in the note

    and for the second question we are using excel 2007 or 2010 in spanish, so we have special character as Ñ, á, Á so when we export it as csv this character are like symbols.

    Add comment
    10|10000 characters needed characters exceeded