Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

Debug internal table how many records you are getting. if it is two, then excel is sending the some mess-up date.

when you delete row or column in excel, select entire row or entire column with some extra empty rows or columns and delete them.

then save the file.

Hope that helps.

RM