SAP WEBI EXPORT TO EXCEL - WRAP TEXT

[Former Member]

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

[Former Member · Accepted solution]

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

Regards

Niraj

[Former Member · Accepted solution]

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

[Former Member]

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