Creating Excel sheets in background [slightly OT]

[Mike Pokraka]

Hi David,

That definitely sounds on target, I would be grateful for any hints. Just
the key bits where the file is created would be very helpful.

Thanks,
Mike

On Fri, November 3, 2006 12:28, Bibby, David wrote:
> 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.
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>