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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to upload an excel to a dynamically generated internal table?

Former Member

‎2008 Mar 15 10:58 AM

0 Kudos
537

Hi,

I have an excel sheet. I have to create an internal table dynamically according to the fields of the excel sheet. The internal table i have created successfully, the fields are exactly coming as the excel sheet. I need to upload the excel sheet directly to my Internal table.

Similar to the FM GUI_UPLOAD, which directly uploads the text document into the internal table

I am not able to pass my dynamic internal table to the GUI_UPLOAD, The tables parameter in the GUI_UPLOAD is accepting only the standard tables.

How to do?

-Sudheer

2 REPLIES 2
Read only

Former Member

‎2008 Mar 15 11:06 AM

0 Kudos
500

Hi,

Use TEXT_CONVERT_XLS_TO_SAP Function Module.

AWARD POINTS IF USEFUL

Read only

abhisek_ank
Newcomer

‎2024 Jul 08 12:05 PM

0 Kudos
464

Hi is your problem resolved ?? if yes, then what you did for your requirement..