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: 

Reading EXCEL file from Application Server to ITAB

Former Member
0 Kudos

Hi SDN,

what is the procedure to read excel file from application server to internal table.

when i read the file in binary mode using OPEN DATASET and READ DATASET it gives junk data with special characters.

is there any standard FM to read & convert it to ITAB?

I searched & searched many threads but ended in no result.

My requirement is to convert excel file contents from application server to internal table.

Thanks & Regards,

Suman.

5 REPLIES 5

Former Member
0 Kudos

Hello,

try ALSM_EXCEL_TO_INTERNAL_TABLE

Regards

Pedro

0 Kudos

hi Pedro,

I tried this FM earlier.

it will read only the presentation server files and not of application server.

Thanks & Regards,

Suman.

0 Kudos

Hello Suman,

is it possible to access the file through a network path? Like "
servername\path\filename"?

Regards,

Pedro

0 Kudos

hi Pedro,

previously i tried it by pathname and filename.

and as u said, tried with server name aswell.

but it gives Exception : UPLOAD_OLE

here's the input i gave:

filename = EADMZ016D_ZD1_00\D:\USR\SAP\ZD1\INTERFACE\INBOUND\BRANCHES_TFS.XLS

where,

server name = EADMZ016D_ZD1_00

pathname = D:\USR\SAP\ZD1\INTERFACE\INBOUND and

filename = BRANCHES_TFS.XLS

and begin/end row columns i gave as 1 & 100

Thanks & Regards,

Suman.

0 Kudos

I'm not shure if the filename you gave will work...

Try to open the file in windows explorer with that path to see if it works.

Check also if you have read access rights to the file.