We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-abap] Uploading EXCEL data to internal table using fm:ALSM_EXCEL_TO_INTERNAL_TABLE

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from srinivasmalaka on Mar 30 at 8:28 AM
Hi srikarreddy,

Thanks for your reply. My issue was solved. The problem with Alsm_excel...
Is when my outlook was opened.,the is not loaded into my itab,even though
sy-subrc =0.

Thanks for your reply.

Thanks & Regards.
Srinivas.M.V
SAP ABAP team
Vcentric Technologies(P) Ltd.

Email:email@removed

---------------Original Message---------------
From: SREEKAR REDDY ALLURU
Sent: Friday, March 28, 2014 6:11 AM
Subject: Uploading EXCEL data to internal table using fm:ALSM_EXCEL_TO_INTERNAL_TABLE

Hi Srinivas

Try like this

PARAMETERS: P_FILE TYPE RLGRAP-FILENAME.
PARAMETERS: STARTROW TYPE I OBLIGATORY.
PARAMETERS: ENDROW TYPE I OBLIGATORY.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
FILENAME = P_FILE
I_BEGIN_COL = 1
I_BEGIN_ROW = STARTROW
I_END_COL = 10
I_END_ROW = ENDROW
TABLES
INTERN = IT_EXCEL
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.

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
srinivasmalaka  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language