Creating Excel sheets in background [slightly OT]

[Bibby, David]

Mike,
Only just seen your mail but I recently had to write a program that runs
in background and then e-mails the results in Excel format to a list of
users (determines from a workflow rule). 

Not sure if it would help but if you want I can send you the relevant
bits from the program.
It's pretty basic i.e. no colour coding or multiple sheets but it might
be a start for you.
Rgds
David
 

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Mike Pokraka
Sent: 03 November 2006 11:55
To: SAP Workflow Users' Group
Subject: RE: Creating Excel sheets in background [slightly OT]

Hi Jocelyn, Kjetil & Andy,

Thanks for your feedback on this. I'll rather write one reply to
everyone to keep all info together.

Kjetil: You'll be pleased to hear that your suggestion won't work. Why
pleased? Because we don't have a .NOT team, and part of the reason it
has to be in background is that the universe doesn't run on Windows
(thankfully or we'd keep having to do the big bang thing all over
again), we have a significant portion of mac users (and possibly some
Linux).

Andy: Yes, this is in many ways a unique environment. The FM's you
mention are the ones that won't cut it in background - they require OLE
and a SAPGUI session on a PC that has Excel installed.

Jocelyn: Good idea, similar to our current best attempt at a hack -
we're have some minor results using delimited files and using server
cookies to change the mime types to get it to look like an Excel file
when it's really a delimited file inside.

Part of the original problem is that we send out PDF's, but some info is
too complex for a PDF and needs to be in Excel. They even want formulas
and multiple sheets - oh whilst we're at it could we format it with
pretty colours and so on. Also playing with ideas of crowbar-ing data
into a template file....

Thanks for the input.
Cheers,
Mike



On Fri, November 3, 2006 03:00, Dart, Jocelyn wrote:
> Mike,
> What if you just created a raw tab-delimited file and included 
> instructions in the message to suggest they convert to XLS on download
the attachment?
>
>
> Regards,
> Jocelyn Dart
> Senior Consultant
> SAP Australia Pty Ltd.

(ridiculous disclaimer snipped)
>
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On 
> Behalf
Of Mike Pokraka
> Sent: Friday, 03 November 2006 5:02 AM
> To: sap-wug at mit.edu
> 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
>
>
> _______________________________________________
> 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

_______________________________________________
This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake please let us know by reply and then delete it from your system; you should not copy it or disclose its contents to anyone. All messages sent to and from Linklaters may be monitored to ensure compliance with internal policies and to protect our business. Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks.

The contents of any email addressed to our clients are subject to our usual terms of business; anything which does not relate to the official business of the firm is neither given nor endorsed by it.

The registered address of the UK partnership of Linklaters is One Silk Street, London, EC2Y 8HQ. Please refer to http://www.linklaters.com/regulation for important information on the regulatory position of the firm.