topic Re: how to uploat EXCEL data to BDC programing in Application Development and Automation Discussions

how to uploat EXCEL data to BDC programing

Former Member — Tue, 30 May 2006 04:43:23 GMT

hi,

how to uploat Excel data to BDC programing and also sheets?

thank you.

Re: how to uploat EXCEL data to BDC programing

Former Member — Tue, 30 May 2006 04:48:38 GMT

Hi,

U can upload data from the Excel sheet to the BDC program by using FM GUI_UPLOAD use this FM and pass the data from Excel sheet to internal table and use this internal table in BDC program

Re: how to uploat EXCEL data to BDC programing

Simha_ — Tue, 30 May 2006 04:52:01 GMT

Hi,

check this code...

&----

*& Report ZNEGI6 *

*& *

&----

*& *

&----

REPORT ZNEGI6 .

data: itab like alsmex_tabline occurs 0 with header line.

TYPES: Begin of t_record,

name1 like itab-value,

name2 like itab-value,

age like itab-value,

End of t_record.

DATA: it_record type standard table of t_record initial size 0,

wa_record type t_record.

DATA: gd_currentrow type i.

*Selection Screen Declaration

*----

PARAMETER p_infile like rlgrap-filename .

************************************************************************

*START OF SELECTION

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'

exporting

filename = p_infile

i_begin_col = '1'

i_begin_row = '2' "Do not require headings

i_end_col = '14'

i_end_row = '31'

tables

intern = itab

exceptions

inconsistent_parameters = 1

upload_ole = 2

others = 3.

if sy-subrc <> 0.

message e010(zz) with text-001. "Problem uploading Excel Spreadsheet

endif.

Sort table by rows and colums

sort itab by row col.

Get first row retrieved

read table itab index 1.

Set first row retrieved to current row

gd_currentrow = itab-row.

loop at itab.

Reset values for next row

if itab-row ne gd_currentrow.

append wa_record to it_record.

clear wa_record.

gd_currentrow = itab-row.

endif.

case itab-col.

when '0001'. "First name

wa_record-name1 = itab-value.

when '0002'. "Surname

wa_record-name2 = itab-value.

when '0003'. "Age

wa_record-age = itab-value.

endcase.

endloop.

append wa_record to it_record.

*!! Excel data is now contained within the internal table IT_RECORD

Display report data for illustration purposes

loop at it_record into wa_record.

write:/ sy-vline,

(10) wa_record-name1, sy-vline,

(10) wa_record-name2, sy-vline,

(10) wa_record-age, sy-vline.

endloop.

This will give u idea of how to uplaod the data from excel to internal table and after that u can use ur BDC mechanism to fill ur fields..'

Cheers,

Simha.

<b>Reward Points If it is needful.</b>

Re: how to uploat EXCEL data to BDC programing

Former Member — Tue, 30 May 2006 04:52:36 GMT

GOOD

YOU CAN VARIOUS PROCESS TO UPLOAD YOUR EXCEL DATA

1-CALL TRANSACTION

2-BDC SESSION

3-LSMW

4-IDOCS

5-BAPI

AS PER YOUR REQUIREMENT YOU CAN USE THEM.

THANKS

MRUTYUN

Re: how to uploat EXCEL data to BDC programing

dani_mn — Tue, 30 May 2006 04:53:06 GMT

use the function module WS_UPLOAD to fill your internal table of same structure as excel file.

and then fill your BDC with this internal table using recording.

Re: how to uploat EXCEL data to BDC programing

Former Member — Tue, 30 May 2006 05:02:02 GMT

use 'ALSM_EXCEL_TO_INTERNAL_TABLE'

regds

gunjan

Re: how to uploat EXCEL data to BDC programing

Former Member — Wed, 16 Jul 2008 04:30:26 GMT

thanks.