Export to excel problem

[Former Member]

Hi All,

I am getting some problem, when I am Implementing the excel eport functionality from webdynpro.

The data is exporting to excel properly but the problem is , when i am opening that excel sheet it is asking for the three options like 1) open this file as an XML list, 2)As read only work book, 3)use xml source task pane.

I dont know why it is asking for those options, when I am opening that excel sheet.

My requirement is, it should open as if we open normal excel sheet.

What could be the problem?

Any ideas.

Regards,

Bala

[Former Member · Accepted solution]

Hi,

The reason for that might be because you are using "Web Dynpro Binary Cache" method to implement the Export to Excel functionality.

To avoid this you can use Hssf api or Jxcel api.

Regards,

Padmalatha.K

[Former Member · Accepted solution]

Hi ,

Thanks for your reply.

I followed this PDF to implement the excel export functionality.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-tec...

This is making use of JXL API only, Binay cach is there.

How can I avoid this? can you please explain in detail ?

Regards,

Bala

[Former Member · Accepted solution]

hi ,

But whats the problem if u are not able to create like this try some apis like u have mentioned and it works fine In my project I have recently implemented Binary Cache which is working fine

Regards

[Former Member · Accepted solution]

Hi Bala,

Try this and Check:

1. In onActionExportToExcel2003(), add this code at the end:

// Begin

IWDWindow win;

win =

wdComponentAPI.getWindowManager().createExternalWindow(

wdContext.currentContextElement().getExcelFileURL(),

wdContext.currentContextElement().getExcelFileName(),

true);

win.open();

// End

2. In exportToExcel2003() method, Comment openExcelLinkPopup();

// This method will open Popup Window

With Regards,

Laksh.

[Former Member · Accepted solution]

Hi,

Opening the window is not my problem.

My problem is how to remove, asking those options while opening the excel shhet.

The data is exporting to excel properly but the problem is , when i am opening that excel sheet it is asking for the three options like 1) open this file as an XML list, 2)As read only work book, 3)use xml source task pane.

I dont know why it is asking for those options, when I am opening that excel sheet.

My requirement is, it should open as if we open normal excel sheet.

Regards,

Bala

[Former Member · Accepted solution]

Have you tried what i said? I think it will not ask for those options...

or else as suggested by padma go for some other APIs

With Regards,

Laksh.

Edited by: Laksh on Sep 18, 2008 2:52 PM

[dhruv_shah3 · Accepted solution]

Hi, Bala,

This problem comes as you have implemented export to excel functionality for 2003 Version.

And you are using Excel 2007 version. Thus its giving you this 3 popup's.

HTH

Regards,

Dhruv