selva_gov

 Profile Answers by selva_gov 

• Dec 5th, 2005

 

using call function 'UPLOAD'

selva(selva_gov@yahoo.com)

bhanu

• Dec 23rd, 2005

 

using function module UPLOAD or WS_UPLOAD or GUI_UPLOAD, but we need to give file type as 'wxi'. OR use function module : alsm_excel_to_internaltable.

MANISH BATRA

• Jan 7th, 2006

 

sorry , this function is only for uploading data fom notepad.for excel uploading,use function module alsm_excel_internal_table

Natarajan

• Mar 2nd, 2006

 

Pls,Send me the details that how to load data from MS Excel Sheet to SAP by Using BDC Method

John

• Jul 13th, 2006

 

KCD_EXCEL_OLE_TO_INT_CONVERT even takes care of blank cells and is available in older versions of SAP

* Add values to internal table                                                     
   SORT t_cells BY row col.                                                       
   LOOP AT t_cells INTO wa_cells.                                                 
     MOVE : wa_cells-col TO l_index.                                              
 ASSIGN COMPONENT l_index OF STRUCTURE itab TO <f_value>.           
     MOVE : wa_cells-value TO <f_value>.                                          
     AT END OF row.                                                               
       APPEND itab                                                 
       CLEAR itab.                                                  
     ENDAT.                                                                       
   ENDLOOP.