Skip to Content
avatar image
Former Member

SAP WEBI EXPORT TO EXCEL - WRAP TEXT

Hi all,

Ive got a case on my webi.

There's a column contain row text like :

for example in 1 row :

Col A Col B

Company A | Bicycle | 200

January Company B | Car | 300

Company C | Train | 230

So the column contain wrap text (which already programmed and logically code from database) , example above is in one row, but unfortunately when i export it to excel, sometimes not all row wrapped.


If above example only 3 row text in one row data is ok, the row that not wrapped contain much text like 30row text in one row data.

Example case like this :


Col A Col B

February Company D | Motorcycle | 210Company E | Car | 320Company F | Monorail | 210Company G | Bus | 270

Is there any configuration in cmc for this?


Thanks.

Setiawan Ang

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 06, 2016 at 10:41 AM

    Hello Setiawan,

    Please refer to link below for the best practice of using Excel O/P. It has all the options that you may try.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f02d9ace-cc7a-3110-9ab9-a126fd7dd8c3?QuickLink=index&…

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hai Niraj,

      Ive checked the document, thanks for the document. But anywy i still havent found the right solution one in that document, and ive tested.

      Thanks.

      Setiawan Ang

  • avatar image
    Former Member
    Apr 12, 2016 at 01:09 PM

    Hi,

    It is quite evident that you have tried to take care of wrapping at database level but has it been taken care at Webi level?

    The formatting done at Webi level gets transferred to Excel.

    Right click on Col B column --> Format Cell --> General tab --> Wrap Text.

    Save this report in Webi and then try saving it as an excel and check.

    Regards,

    Yuvraj

    Add comment
    10|10000 characters needed characters exceeded