2019 Feb 20 9:21 AM
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
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
2019 Feb 20 10:05 AM
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 ?
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |