topic Re: Excel Sheet upload! in Application Development and Automation Discussions

Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 07:24:45 GMT

Hi,

I am uploading data from excel sheet. Which is the suitable fm?

One problem is , excel sheet contents 2-3 spreadsheets in first there is data and in second it contains picture file. So while uploading it creates the problem

How can i solve it as i dont want to manipulate excel sheet.

Thanks in advamce.

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:01:38 GMT

Any solution?? lttile Urgent!

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:17:17 GMT

Hi,

Try this FM.

CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT'
EXPORTING
filename = p_file
i_begin_col = p_scol
i_begin_row = p_srow
i_end_col = p_ecol
i_end_row = p_erow
TABLES
intern = IT_INTERN
EXCEPTIONS
inconsistent_parameters = 1
upload_ole = 2
OTHERS = 3.

An alternative is 'ALSM_EXCEL_TO_INTERNAL_TABLE'.

But you can never upload pictures thru this....

Rewards points if helpful.

Regards,

Kirti

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:20:26 GMT

use func module

ALSM_EXCEL_TO_INTERNAL_TABLE, Use unique spread sheet for uploading the data.

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:21:00 GMT

check this below code may be helpful for you

Uploading data from Excel

Sample source for uploading data from excel into any ztable.

You can use the following code and get an idea……

REPORT ZEXCEL_TO_INTERNAL .

data: begin of itab occurs 0,

name(20) type c,

addre(20) type c,

end of itab.

DATA : ITAB1 LIKE ALSMEX_TABLINE OCCURS 0 WITH HEADER LINE.

DATA : B1 TYPE I VALUE 1,

C1 TYPE I VALUE 1,

B2 TYPE I VALUE 100,

C2 TYPE I VALUE 9999.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME =

'C:\Documents and Settings\administrator\Desktop\ppcon001bd_24.xls'

I_BEGIN_COL = B1

I_BEGIN_ROW = C1

I_END_COL = B2

I_END_ROW = C2

TABLES

INTERN = itab1

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at itab1.

write:/ itab1.

Endlop.

mark the helpful answers

Regards,

Naveen

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:23:33 GMT

hi,

you can use the FM TEXT_CONVERT_XLS_TO_SAP.

its pretty simple.

regards,

Mahesh

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 08:25:17 GMT

hi,

plz chkout this link for excelsheet upload

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

i dont think that u can upload data with 2-3 spreedsheets,copy tha data u want to upload in seperate excel file & then upload

Thanks

Madhuri

Re: Excel Sheet upload!

Former Member — Wed, 29 Nov 2006 09:07:14 GMT

Check this thread..

may be that can help you in solving your issue.

Regards

Vijay

Re: Excel Sheet upload!

jayanthi_jayaraman — Wed, 29 Nov 2006 09:16:57 GMT

Hi,

If you know the no. of rows to be uploaded,you can use ALSM_EXCEL_TO_INTERNAL_TABLE function module.