Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Merge cell in excel attachment- Formating

Former Member

‎12-07-2015 10:46 AM

0 Kudos

Hi,

I am trying to send mail with excel attachment using cl_bcs class and it is working fine, But there are few rows in which common data is there so i want to merge them into one row. How to merge it using CL_BCS--string_to_solix Class. Please help me.

Example:

Vendor   Vendor description Material  Material Description   Component  New Component  Date

123         Test1                    0123      Test_material            00345         00678                  11/12/2015

123         Test1                    0123      Test_material            00468         00987                  11/12/2015

123         Test1                    0123      Test_material            00789         00989                  11/12/2015

I want like this in excel sheet as one row.

Vendor   Vendor description Material  Material Description   Component  New Component  Date

123         Test1                    0123      Test_material            00345         00678                  11/12/2015

                                                                                       00468         00987

                                                                                       00789         00989

Thanks and Regards,

Shakeer Hussain

2 REPLIES 2

VenkatRamesh_V
Active Contributor

‎12-07-2015 3:27 PM

0 Kudos

Hi Shakeer,

Hope you are using internal table.

Before appending check it.

Read table itab with key vendor   = wa-vendor

                                    material  = wa-material transporting no fields.

if sy-subrc is initial.

clear: wa-vendor, wa-name1, wa-material, wa-maktx.

endif.

append wa to itab.

Hope it helpful,

Regards,

Venkat.

Former Member
In response to VenkatRamesh_V

‎12-08-2015 2:07 PM

0 Kudos

Thanks Venkat..

I already know the solution which you have suggested but with that in excel we can see empty cells.I want the cells to merge like the way we see in excel sheet.

I am not sure this is achievable or not, I have seen many posts on this one but all are using XML or HTML. I want to achieve this one using CL_BCS Class and type is XLS.

Thanks and Regards,

Shakeer Hussain