Autofit formatting for excel

[Former Member]

Hello Folks,

Can you please let me know, how can i perform autofit formatting for an excel which is sent as attachement,I have tried programs like BCS_EXAMPLE_7.I have data in internal table (Used  xstring_to_solix ).

Regards

Aradhya.J.M.

[Former Member]

Hello Folks,

Can you please let me know, how can i perform autofit formatting for an excel which is sent as attachement,I have tried programs like BCS_EXAMPLE_7.I have data in internal table (Used  xstring_to_solix ).

Regards

Aradhya.J.M.

[matt]

Have you tried to create the excel spreadsheet using abap2xlsx: http://scn.sap.com/community/abap/blog/2010/07/12/abap2xlsx--generate-your-professional-excel-spread...

This allows autofit formatting and is very easy to use.

[Former Member]

Hello Matthew,

Thanks for your responce,

I tried accessing it,but unable to see the code since it is stating  "You have already accepted the Code Exchange Terms of Use and your request is being processed."

Regards

Aradhya.J.M.

[matt]

That's a problem using the site; I can't help you with that. The solution to your technical problem remains the same - use abap2xlsx.

[Former Member]

Matthew,Can you please let me know which Content i need to refer since there are some many in that Site. I am still waiting for responce from SDN to give access to those codes.

Regards

Aradhya.J.M.

[matt]

I do not understand what you are asking. I registered, downloaded the relevant files, uploaded and used the product. It was all very straightforward - just a question of following what is written in the various blogs and documents.