topic Re: UPLOAD in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490114#M839240 <HTML><HEAD></HEAD><BODY><P>FORM UPLOAD_EXCEL_FILE .</P><P></P><P>CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'</P><P>EXPORTING</P><P>FILENAME = P_FNAME " File Name</P><P>I_BEGIN_COL = 1 " start Column</P><P>I_BEGIN_ROW = 2 " start row</P><P>I_END_COL = 22 " total columns</P><P>I_END_ROW = 9999 " max rows</P><P>TABLES</P><P>INTERN = IT_FILE_UPLOAD. " internal table</P><P></P><P>ENDFORM.</P><P></P><P>Use the above FM to upload data from excel sheet</P></BODY></HTML> Wed, 05 Mar 2008 09:41:03 GMT former_member609120 2008-03-05T09:41:03Z UPLOAD https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490113#M839239 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P>I need to upload Text DATA at each line item level of the Quotation (VA21 From an excel sheet .Tere r around 500 Line items and each will be loaded with text from excel sheet</P><P>Thank you very much in advance</P></BODY></HTML> Wed, 05 Mar 2008 09:33:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490113#M839239 Former Member 2008-03-05T09:33:36Z Re: UPLOAD https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490114#M839240 <HTML><HEAD></HEAD><BODY><P>FORM UPLOAD_EXCEL_FILE .</P><P></P><P>CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'</P><P>EXPORTING</P><P>FILENAME = P_FNAME " File Name</P><P>I_BEGIN_COL = 1 " start Column</P><P>I_BEGIN_ROW = 2 " start row</P><P>I_END_COL = 22 " total columns</P><P>I_END_ROW = 9999 " max rows</P><P>TABLES</P><P>INTERN = IT_FILE_UPLOAD. " internal table</P><P></P><P>ENDFORM.</P><P></P><P>Use the above FM to upload data from excel sheet</P></BODY></HTML> Wed, 05 Mar 2008 09:41:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490114#M839240 former_member609120 2008-03-05T09:41:03Z Re: UPLOAD https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490115#M839241 <HTML><HEAD></HEAD><BODY><P>TEXT_CONVERT_XLS_TO_SAP</P><P></P><P>ALSM_EXCEL_TO_INTERNAL_TABLE</P><P></P><P>Reward if useful</P></BODY></HTML> Wed, 05 Mar 2008 09:46:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upload/m-p/3490115#M839241 Former Member 2008-03-05T09:46:59Z