Skip to Content
0

Sap design studio 1.5 export to excel or csv

Jan 31, 2017 at 12:41 PM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jan 31, 2017 at 12:59 PM
0

#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?

Share
10 |10000 characters needed characters left characters exceeded
Manuela Andreina Villavicencio Ramos Jan 31, 2017 at 03:54 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded