EXCEL SHeet

[Former Member]

Hi,

How can we make a excelsheet having three sheet inside it.

Regards

Hemant

[Former Member]

Answered

[Former Member]

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/02706f11-0d01-0010-e5ae-ac2...

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

[Former Member]

Hi,

I had prepare XSLT mapping. But when we add new sheet(after one sheet), it is not finding the parser. Can you please tell me how to add new sheet in EXCELBOOK in the XSLT mapping.

Regards

Hemant

[Former Member]

Hi All,

I wanted to have a mail Excel workbook created with more then one work sheet in it what checnges wil be needed in the XSLT mapping of

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

Urgent Help needed

[prabhu_s2]

is this post related to XI ?

[Former Member]

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

[henrique_pinto]

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.

[Former Member]

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