Skip to Content
0
Former Member
Jul 23, 2007 at 04:19 PM

how do we refresh the memory so that above method retrives only the correct

80 Views

Hi,

I'm uploading data from a excel file.

Suppose the excel file is having 2 rows of data.

The uploading works fine and uploads both the records.

Now I delete one row of data from the excel file. Now there is only one record in the excel file.

Now again when i try to upload the same, i get error records.

That is because even though there in only record in the excel file, the internal table which stores the data from the excel file in the program shows 2 records.

The first record is uploaded correctly but the second record will be a data of all # values which leads to error. Evewn though the second record was deleted the memory for the same exists.

How do i avoid this situation.How do I free the memory..How do i retrieve only the correct ones in the excel file and not the previosly deleted ones.

The data is fetched from the excel file as given below:

there is a class interface CL_GUI_FRONTEND_SERVICES which implements the method clipboard_import.

CL_GUI_FRONTEND_SERVICES=>clipboard_import

importing

data = L_I_EXCEL_TAB1.

L_I_EXCEL_TAB1 is the table which stores the data from the excel file.

Now where and how do we refresh the memory so that above method retrives only the correct records and not the deleted ones.

Thank You