XLS and XLSX excel upload in WDA - webdynpro

[former_member193460]

Hi Experts,

     I have a requirement to upload local excel file to a webdynpro application (support both: xls and xlxs).

i checked online and found we can use class cl_fdt_xl_spreadsheet, but this class isnt available in the system(BW 7.0 system).

So i used the option of xstring and converting into string, However the values are not always copied to internal table correctly (garbage values at times).

   CALL FUNCTION 'CRM_IC_XML_XSTRING2STRING'
    EXPORTING
      inxstring = l_xstring
    IMPORTING
     outstring  = l_string.

Please let me know how i can implement this requirement.

Thanks & Regards,

Tashi

[former_member193460]

Hi Everyone,

     i realized it works for tab delimeted txt file (saved as xls).

Is it possible to get it working for actual xls file . i found it can be done using CL_FDT_XL_SPREADSHEET, but this class isnt available in my system.

System : SAP BW 7.0

Can any one tell me if this object will be available after upgrade ?

or is there any other way of excel upload into webdynpro .. ?

Thanks & Regards,

Tashi

[ramakrishnappa]

Hi Tashi,

Please refer the below link to remove the garbage values from excel file

Hope this helps you.

Regards,

Rama

[former_member193460]

Hi Rama,

     i have realized this as i had tried with a excel file which was download from the system. But how can we ensure to create a excel file or a template file in the same format. how do we determine the format of excel file without downloading it.

Thanks & Regards,

Tashi

[ramakrishnappa]

Hi Tashi,

Download the template from WD application by using file download into an excel file as suggested in the above link.

Now, you can modify it as per your requirement i.e. adding your columns and data as per requirement.

The same file can be used to upload data by using WD application.

Here, the template file is just an empty excel file.. which can be modified as per the requirement.

Regards,

Rama