topic Read an EXCEL file from application server in Application Development and Automation Discussions

Read an EXCEL file from application server

Former Member — Mon, 05 May 2008 04:07:38 GMT

Hi all

I have to read an excel file from applicatin sever and update my custom tablels.

The problem is when the file is uploaded into the application server .

the fields it has are

name age gender

xyz 67 m.

when seeing the file using al11 tcode :

its showing the following:

###ࡱ##################>#######################################################################################################################

##############################################################################################################################################

#################################################################O#b#j#I#n#f#o################################################################

##############################################################################################################################################

How do i read this and put in my internal table

Pleaes help.

Thanks and Regards,

Former Member — Mon, 05 May 2008 04:21:24 GMT

Hi Somya,

When you read the file in your program from al11 you will get the data properly. As the data displayed there may be stored in some other format.

Regards,

Anuj

Former Member — Mon, 05 May 2008 04:25:07 GMT

Try using FM RZL_READ_FILE

Former Member — Mon, 05 May 2008 04:26:20 GMT

Hi,

I am using ECC6.0.

I think the EXCEL file is stored in compressed format to save space.

Please let me know how to decompress etc.

I tried using the function moduel

text_convert_xls_to_sap.

How do I pass the parameter to I_filename.

Regards,