Formatted Excel as Email Attachment by using XML

Former Member — Wed, 20 Feb 2019 09:21:07 GMT

Hey everybody,

i have a requirement in which i have to sent a mail with excel attachment . i have already develop the program by using XML and its working file but now my user want different color in every row .

Can someone help me in that topic?

Regards,

Supriya

Re: Formatted Excel as Email Attachment by using XML

Sandra_Rossi — Wed, 20 Feb 2019 10:05:32 GMT

XMLSS / XML 2003 I guess?

<?xml ...xmlns="urn:schemas-microsoft-com:office:spreadsheet"...?><Workbook ... <Worksheet ... <Table ... <Row><Cell ... <Data ...>value</Data> ...

It's easy to answer yourself to the question: start Excel, create a minimal workbook with 2 rows of 2 different colors, save as "Excel spreadsheet 2003" and look at the XML.

But couldn't you use abap2xlsx ?

topic Re: Formatted Excel as Email Attachment by using XML in Application Development and Automation Discussions

Formatted Excel as Email Attachment by using XML

Re: Formatted Excel as Email Attachment by using XML