Excel upload problem

[Former Member]

I am using the function module

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = P_FILE1

i_begin_col = 1

i_begin_row = 1

i_end_col = 22

i_end_row = 65536

TABLES

intern = t_excel

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

And passing the parameters as shown . My excel sheet has 22 columns . It is not reading last record .

[Former Member]

Hi

Check out if this function module meets what you need.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_field_seperator = 'X'

• I_LINE_HEADER =

i_tab_raw_data = i_tab_raw_data

i_filename = p_filepath

TABLES

i_tab_converted_data = l_table

• EXCEPTIONS

• CONVERSION_FAILED = 1

• OTHERS = 2

[christian_wohlfahrt]

Use 23!

[Former Member]

When I am using 23 it is not reading last two records

[Former Member]

easy way of doing this is by using the FM "TEXT_CONVERT_XLS_TO_SAP"

here is the link,how to do that.

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Regards

srikanth

[Former Member]

hi,

increase the column number

Hope it helps