Creating Excel sheets in background [slightly OT]

[Mike Pokraka]

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
>