topic Re: Excel upload problem in Application Development and Automation Discussions

Excel upload problem

Former Member — Thu, 28 Sep 2006 09:32:30 GMT

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 — Thu, 28 Sep 2006 09:34:58 GMT

Check out if this function module meets what you need.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_field_seperator = 'X'

i_tab_raw_data = i_tab_raw_data

i_filename = p_filepath

TABLES

i_tab_converted_data = l_table

christian_wohlfahrt — Thu, 28 Sep 2006 09:36:11 GMT

Use 23!

Former Member — Thu, 28 Sep 2006 09:38:36 GMT

hi,

increase the column number

Hope it helps

Former Member — Thu, 28 Sep 2006 09:38:45 GMT

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

Former Member — Thu, 28 Sep 2006 09:59:26 GMT

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

here is the link,how to do that.

Regards

srikanth