The error is that

[Former Member]

Excel file FILE://C://Documents and Settings\A_MAN\DESKTOP\BOOK1 cannot be processed...

Why I have encountered with this error?

What is the problem.

Note: Microsoft Office 2007 is installed.

Thanks in advance..

Deniz.

[Former Member]

Excel file FILE://C://Documents and Settings\A_MAN\DESKTOP\BOOK1 cannot be processed...

Why I have encountered with this error?

What is the problem.

Note: Microsoft Office 2007 is installed.

Thanks in advance..

Deniz.

[Former Member]

HI,

The File name which you have mentioned here is the Wrong file name, the format of the file should be start from <b>C://Documents and Settings/A_MAN/DESKTOP/BOOK1.xls</b>

Regards

Sudheer

[Former Member]

hi,

GIve it in this format C://Documents and Settings/A_MAN\DESKTOP/BOOK1.xls to avoid that error.

Regareds,

Santosh

[Former Member]

hi,

check whether the path given by u is correct or not.

for ex: C:/ ADMINISTRATOR/SURESH/...................... or use FM F4_open and declare a string variable in our program and a parameter [ which takes i/p from user] as

parameter: filenam(99) type c.

data: str type s.

str= filenam.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = sy-repid

dynpro_number = syst-dynnr

field_name = str

IMPORTING

file_name = str.

if helpful reward some points.

with regards,

suresh.a

[Former Member]

The excel file and the internal table must have the same format or what?

For examle in the excel I have 3 fields and in internal table 4 columns.

Is this a problem or affects something?

Thanks.Deniz

[Former Member]

hi,

If you are trying to upload the data from an excel sheet. Then the number of target fields should be greater than or equal to the number of source fields provided the unused field should be the last field in your target internal table.

Regards,

Santosh