Application Development and Automation 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: 
Read only

refreshing the excel .

Former Member
0 Likes
278

hi all ,

i'm uploading the text using some data from excel to one internal table . with the same excel i'm downloading the data . now . i need to know how to refresh the excel once after the uploading is done .pls anybody help me how to refresh the excel programattically once it is uploaded ...

1 REPLY 1
Read only

Former Member
0 Likes
239

Hi Premchander,

If you are using GUI_DOWNLOAD for downloading the data to excel, you need not refresh the excel explicitely. There is an import parameter 'APPEND' in 'GUI_DOWNLOAD', based on which it decides whether data should be over written or appended to the excel sheet mentioned in the fm parameter. Do not pass this parameter or pass it as space, the excel data would be refreshed and new data in the internal table will be downloaded to the excel sheet.

Hope this helps you.

Thanks,

deepti