|
View previous topic :: View next topic
|
| Author |
Message |
swatheeswaran
New User
Joined: 04 Nov 2008
Posts: 7
Location: Chennai
|
|
|
|
| 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 |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| Why not copy the 4 dataset to one and attach? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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 |
|
|
swatheeswaran
New User
Joined: 04 Nov 2008
Posts: 7
Location: Chennai
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
|
|
