displaying excel sheets in view

[Former Member]

hai all,

i need to display 5 excel sheets in a view.since thats more complicated i think its better to give link to the sheets in a view.please guide me in doing that.If you find any other way of doing that plz suggest me that too.

Thanks n Regards

Sharanya.R

[Former Member]

Hi,

You can use following code to set links to your file. that file should be in your server.

if the file is in local machine you need to upload it to server using fileupoad ui element.

FileInputStream excelCSVFile = new FileInputStream(f);

IWDCachedWebResource cachedWebResource = null;

if (excelCSVFile!= null)

{

cachedWebResource = WDWebResource.getWebResource(excelCSVFile, WDWebResourceType.getWebResourceType(

"xls",

"application/ms-excel"));

cachedWebResource.setResourceName(fileName);

}

cachedExcelResource =cachedWebResource;

wdContext.currentContextElement**().setURLlink(cachedExcelResource.getURL());

Regards

Deepak

Edited by: Deepak Tiwari on Mar 7, 2008 12:45 PM

[Former Member]

Hi,

Uploading and Downloading Files in Web Dynpro Java

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00062266-3aa9-2910-d485-f1088c3a...

Regards

Ayyapparaj

[Former Member]

Hi,

This link may help you.

Link:[https://www.sdn.sap.com/irj/sdn?rid=/library/uuid/49f2ea90-0201-0010-ce8e-de18b94aee2d#58]