topic Re: uploading data from spread sheet in Application Development and Automation Discussions

uploading data from spread sheet

Former Member — Thu, 12 Jun 2008 14:48:06 GMT

Hi all,

i am using this function module for uplaod CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD

which is working fine if i upload the data from text file like notepad but if i am trying to upload it from exel or spreadsheet it is not uploading the excat data is loading some junk data. please give me the reply i am running behind the schedule.

Re: uploading data from spread sheet

Former Member — Thu, 12 Jun 2008 15:00:27 GMT

Hi,

Try fn, module GUI_UPLOAD

Re: uploading data from spread sheet

Former Member — Thu, 12 Jun 2008 15:58:03 GMT

Hi,

Upload data from spread sheet can be done with FM 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Re: uploading data from spread sheet

Former Member — Fri, 13 Jun 2008 03:43:10 GMT

Hi,

For Excel you have to use the function module ,

'ALSM_EXCEL_TO_INTERNAL_TABLE'

Pass all these parameters according to your recording....

exporting

FILENAME = P_FILE

I_BEGIN_COL = 1

I_BEGIN_ROW = 4

I_END_COL = 21

I_END_ROW = 9999

tables

INTERN = IT_EXCEL

Thanks.

Swati.

Re: uploading data from spread sheet

Former Member — Fri, 13 Jun 2008 03:58:53 GMT

hi there....

to upload data into sap system, use gui_upload function module. or lsmw wil be helpful too...

regards'

Prem Sharma

Re: uploading data from spread sheet

megha_h — Fri, 13 Jun 2008 08:47:56 GMT

GUI_UPLOAD always collects converted data in the internal table.

You need to convert the data using FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Regards

Megha

Edited by: Eclectic on Jun 13, 2008 2:19 PM

Re: uploading data from spread sheet

Former Member — Fri, 13 Jun 2008 17:30:45 GMT

Hi,

Try with function module: 'TEXT_CONVERT_XLS_TO_SAP'.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_file

TABLES

i_tab_converted_data = it_datatab[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Regards,

Bhaskar

Re: uploading data from spread sheet

Former Member — Sun, 15 Jun 2008 11:12:12 GMT

Hi,

U can try the following code :

report zdemo_program .

types: begin of t_excel,

fld1(20) type c,

fld2(20) type c,

fld3(20) type c,

end of t_excel.

data: it001 type table of t001.

data: xt001 type t001.

data: iexcel type table of t_excel.

data: xexcel type t_excel.

select * into table it001 from t001.

xexcel-fld1 = 'Field 1'.

xexcel-fld2 = 'Field 2'.

xexcel-fld3 = 'Field 3'.

append xexcel to iexcel.

loop at it001 into xt001.

xexcel-fld1 = xt001-bukrs.

xexcel-fld2 = xt001-butxt.

xexcel-fld3 = xt001-ort01.

append xexcel to iexcel.

endloop.

call method cl_gui_frontend_services=>gui_download

exporting

filename = 'C:/test.xls'

write_field_separator = 'X'

changing

data_tab = iexcel.

Regards,

Biswanath

Re: uploading data from spread sheet

Former Member — Mon, 16 Jun 2008 07:05:57 GMT

hi.....

when you are using gui_upload function...chect the file type which you have given....

For text file the fil type is DAT and for excel file the file type is ASC....

filename = file

filetype = 'ASC'

MAYBE THATS THE REASON....

just check an let me know.....

Re: uploading data from spread sheet

Former Member — Tue, 17 Jun 2008 07:10:41 GMT

Use ALSM_EXCEL_TO_INTERNAL_TABLE -

> To upload excel data.

GUI_UPLOAD -

>To upload flat file data.

Rewards points...........

Edited by: Murali Krishna Makineni on Jun 17, 2008 9:11 AM

Re: uploading data from spread sheet

Former Member — Thu, 26 Jun 2008 19:48:40 GMT

Hi Guru,

i have tried putting the module what you have recomended still it is not working from portal, it is working fine when i upload from GUI. i really apprecite the answers i have got from all of the respected fellows.

Re: uploading data from spread sheet

Former Member — Fri, 27 Jun 2008 04:58:14 GMT

for excel files there are some other FM like

ALSM_excel_to_internal_table and many other like to upload different sheet of a excel file for details go to the link below...

http://www.sap-img.com/abap/uploading-multiple-multitab-excel-sheets-or-ranges.htm

with luck,

pritam.

Re: uploading data from spread sheet

Former Member — Fri, 27 Jun 2008 05:29:04 GMT

Hi,

Use the Function Module TEXT_CONVERT_XLS_TO_SAP.

I hope this will help you.

Help children of U.N World Food Program by rewarding points and encourage others to answer your queries.