Creating Excel sheets in background

[Andy Curtis]

 Mike

What a cool project you must be working on!  It is possible to store an XLS
file as a MIME object in SE80.  Could you store a template XLS as a MIME
object, read it and edit it as an internal table using an FM like

'text_convert_xls_to_sap'
and email the edited file as an attachment?

I haven't tried it, but it might give you some ideas.

Andy


---------- Forwarded message ----------
> From: "Mike Pokraka" <asap at workflowconnections.com>
> To: sap-wug at mit.edu
> Date: Thu, 2 Nov 2006 18:01:42 -0000 (UTC)
> Subject: Creating Excel sheets in background [slightly OT]
> 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
>
>
> --
> Andy Curtis
> (m) 07798 603099
> (t) 01737 843948
> (e) abcurtis at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20061103/f17ef74a/attachment.htm