on 04-20-2007 9:23 AM
Hi,
How can we make a excelsheet having three sheet inside it.
Regards
Hemant
Answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Try to write a Adapter module to put the data into Excel sheet and in code we can handle the sheets also in excel , i hope ,.. try it will solve your requirement
how to write a adapter module see the below link
Also see the below links
/people/community.user/blog/2006/09/07/email-reporting
/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword
http://www.utoronto.ca/ian/books/html4ed/appb/mimetype.html
"JAVA MAPPING", an alternate way of reading a CSV file -/people/rahul.nawale2/blog/2006/07/18/java-mapping-an-alternate-way-of-reading-a-csv-file
Regards
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is this post related to XI ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes prabhu.......Actually when the output is coming out from XI we want that output should be a Excel sheet means xml should convert into EXCel .
An Excel sheet can have 2,3 or more sheet in it. So we want it should make 3 sheets in an Excel document according to conditions......
Regards
Hemant
Check out this blog:
/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter
and this java excel api:
http://jexcelapi.sourceforge.net/.
Also, check my message at this thread:
With it, you can create a java mapping that will create a workbook, and in that workbook, you can set the sheets the way you want.
However, check this blog:
/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible
If you modify Michals xslt a little, you can achieve multiple sheets in one workbook. Just refer to Worksheet node. You can create multiple entries of it.
Regards,
Henrique.
Hi,
I Know to make a excel sheet using XSLt mapping. BUt main thing is to generate a sheet having three differnt sheet within a EXcel Document according to condition.
Can anybody give me some suggestion.
Regards
Hemant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.