Creating Excel sheets in background [slightly OT]

[Mike Pokraka]

Not sure, since this is "firmly outside the realm of WF", so someone else
is doing the real work :-)
But I see your point and will pass it on. The complexities stem in part
from the data we are supposed to generate but XSLT should definitively be
of use to make the transformation easier.

Thanks for the heads up,
Mike

On Wed, November 15, 2006 23:31, Soady, Phil wrote:
> 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
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>