Creating Excel sheets in background [slightly OT]

[Soady, Phil]

did you use XSLT to generate the XML file ? 


Phil Soady 
Solution Architect 
Netweaver Consulting 
SAP Australia 
M  +61 412 213 079 
F  +61 2 9957 7263 
mailto:phil.soady at sap.com 


-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Mike Pokraka
Sent: Thursday, 16 November 2006 3:29 AM
To: SAP Workflow Users' Group
Subject: Re: Creating Excel sheets in background [slightly OT]

Short update on this:
Excel supports an XML format where you can generate almost anything you
like from pretty colours to pivot tables in an XML file which you can
attach to an email as a proper Excel file. Small word of warning: though
not very difficult, it can be quite laborious and a lot of coding.

Thanks all for your help - especially David for all the code.
Cheers,
Mike

On Thu, November 2, 2006 18:01, Mike Pokraka wrote:
> Hi all,
>
> We have a requirement where a mail is sent out to a user with some
info.
> Basic stuff, however the twist here is that they require this as an
Excel
> spreadsheet.
>
> Easy enough to do in dialog, but does anyonw know how to create an
Excel
> spreadsheet attachment in background? All methods we've lookied at
come
> back to the use of OLE functions which require a GUI session of a user
> with Excel installed. This must be completely in background.
>
> I know this is on the far-flung borders of the workflow realm, but
seeing
> as we have some very knowledgeable people on this list I figured I
might
> throw the question out here.
>
> Any input appreciated.
> Cheers,
> Mike
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>


_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug