MULTIPLE WORKSHEETS - using XSLT

[Former Member]

HI,

Can anyone well versed in ABAP to XML conversion using XSLT please provide me with some valuable pointers on how multiple worksheets can be created in a single excel file.

Im calling the xslt transformation from a bsp program by passing an internal table.

Ive tried coding the worksheet statement inside a loop statement.

<xsl:for-each select="ROWS/ZTABLE">

<Worksheet ss:Name="FIRSTCOL">

But this gives me an error saying file cannot be opened.

Im not sure how to proceed from here. Kindly request anyone with experience in this area to please help out.

<removed_by_moderator>

Edited by: Julius Bussche on Sep 8, 2008 12:20 PM

[Former Member]

Check below blog which transfers various internal table data to multiple sheets in a excel sheet....

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/5394] [original link is broken] [original link is broken] [original link is broken];

[Former Member]

Jai,

Check this link...

Regards

Indu

[Former Member]

Hi Indu,

Thanks for your very prompt reply. Unfortunately my requirement is to achieve multiple worksheets using XSLT not through OLE concept. Thanks anyway

[bpawanchand]

Hi

Check this

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/exporting%2bdata%2bto%2bexcel%2b-%2bxml%2bto...

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/sap%2bxi%2binterview%2bquestions

Regards

Pavan