To upload an Excel file using Webdynpro application.

Source: Internet
Author: User

Scenario: To upload an Excel file using Webdynpro application.

Procedure:  

1. Go to transaction SE80.

2. Select "Webdynpro comp./intf" from the list.

3. Create A new Webdynpro component by the name Zexcel_upload.

4. Double-click on the View. Select Context Tab.

5. Create an attribute as shown below.

6. Create a node as shown below:

7. Create attributes for the Data_tab node like below.

8. Double click on View. We would be designing the screens of our application with the following elements:

1. File Upload

2. Button

3. Table

Insert Element file_upload for uploading FILE.

9. Insert Element button.set its Text property as UPLOAD.

Create A new action for button.

Insert an Element TABLE and does binding by right clicking on it and select Create binding.

By pressing Enter button Binding is done.

Set Column ' s header property as below.

The same-on-the-loop Set header property is the age column too.

Select element File upload and set its DATA property as shown below:

Now select View ' s method list

Double click on Onaction_upload method. Write a code as given below.

METHOD Onactionon_upload.

TYPES:

BEGIN of Str_itab,

name (Ten) TYPE C,

Age (Ten) TYPE C,

END of Str_itab.

data:t_table1 TYPE Standard TABLE of Str_itab,

i_data TYPE Standard TABLE of String,

lo_nd_sflight TYPE REF to If_wd_context_node,

lo_el_sflight TYPE REF to If_wd_context_element,

l_string TYPE String,

fs_table TYPE Str_itab,

l_xstring TYPE xstring,

fields TYPE string_table,

Lv_field TYPE string.

data:t_table TYPE If_main=>elements_data_tab,

data_table TYPE if_main=>elements_data_tab.

* Get single attribute

Wd_context->get_attribute (

Exporting

name = ' DATASOURCE '

Importing

value = l_xstring).

call FUNCTION ' hr_kr_xstring_to_string '

Exporting

in_xstring = l_xstring

Importing

out_string = l_string.

SPLIT l_string at Cl_abap_char_utilities=>newline into TABLE i_data.

* Bind with Table Element.

LOOP at I_data to l_string.

SPLIT l_string at Cl_abap_char_utilities=>horizontal_tab to TABLE fields.

READ TABLE fields into Lv_field INDEX 1.

fs_table-name = Lv_field.

READ TABLE fields into Lv_field INDEX 2.

fs_table-age = Lv_field.

APPEND fs_table to T_table1.

Endloop.

lo_nd_sflight = Wd_context->get_child_node (' Data_tab ').

lo_nd_sflight->bind_table (t_table1).

EndMethod.

Activate The program and create a application by right clicking and save it.

. Test Application.

Output:

Click on Browse.select The EXCEL file with the Columns.

Click on UPLOAD button.and Excel data would be displayed like below.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

To upload an Excel file using Webdynpro application.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.