IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Email with attachment


 
IBM Mainframe Forums -> FAQ & Basics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Sat Jun 01, 2013 9:36 am
Reply with quote

We have 4 data sets (data delimited by tab) to be sent through email as excel attachment. Is it possible to put the data in 4 worksheets in a single excel attachment instead of multiple attachments. Please advise...
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1566
Location: Andromeda Galaxy

PostPosted: Sat Jun 01, 2013 12:32 pm
Reply with quote

Why not copy the 4 dataset to one and attach?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Sat Jun 01, 2013 2:01 pm
Reply with quote

Quote:
Is it possible to put the data in 4 worksheets in a single excel attachment instead of multiple attachments.


NO

topic has been discussed too may times, search the forum for the explanation
Back to top
View user's profile Send private message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Sat Jun 01, 2013 6:03 pm
Reply with quote

Pandora-Box wrote:
Why not copy the 4 dataset to one and attach?

Thanks for the reply.
Our requirement is to present in different tabs in a spreasheet.Each dataset would be having ~2000 records. For e.g
Dataset 1 has US customers list
Dataset 2 has UK customers list
Dataset 3 has Japan customers list
Dataset 4 has Indian customers list

Instead of attaching four spreadsheets in a email, am checking whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Sat Jun 01, 2013 6:11 pm
Reply with quote

Quote:
Instead of attaching four spreadsheets in a email, am checking whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet.

NO ( again )

did You search the forum for the why ???

You cannot do that with CSV data ,
You will have to build a WORKSPACE/SPREADSHEET according to EXCEL specifications.

if Your organization has the stringent requirements to do that, there are products able to do it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8566
Location: Dubuque, Iowa, USA

PostPosted: Sat Jun 01, 2013 6:14 pm
Reply with quote

Quote:
whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet
In order to do this, you have a couple of choices:
1) purchase a program to generate Excel files on the mainframe, or use an existing program (such as SAS) to do it. If your site needs to buy such a program, expect to spend between 10 and 100 thousand US dollars for the program.

2) find a copy of the Microsoft file specification on the Internet, and use that to write your own mainframe program to generate Excel spreadsheets files on the mainframe. The specificiations run well over 1000 pages so such a project could be completed by a team of 3 or 4 programmers in about a year, most likely.

Or you could do what most people do and download the worksheets as separate delimited (comma or tab) files and combine them in Excel.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> FAQ & Basics
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts TXT2PDF and then SMTP email a PDF JCL & VSAM 4
No new posts Send email without SMTP All Other Mainframe Topics 5
No new posts Using the SAS module to email mainfra... JCL & VSAM 3
No new posts JCL to send email along with formated... JCL & VSAM 5
No new posts Need Help on sending email by includi... JCL & VSAM 9

Back to Top